Oracle Database Reviews

It's very stable and highly available. I also like the row-level locking feature. It can manage billions of rows of data.

The performance is pretty good, and the maintenance is very low.

Oracle Database is easily scalable and has so many enterprise benefits.

The product is so robust and bug-free. It handles anything that is thrown at it. If there are any issues, it's easy enough for our people to identify and fix them ourselves.

The initial setup could be easier.

We have been using Oracle Database for around 30 years.

It's very stable.

It's very highly scalable.

We currently have three users.

The Initial setup is tough. It's not a common off-the-shelf product. It's a very highly engineered product that caters to billions of records every year. As a result, you need a qualified person to do the installation.

It can take a whole day for the installation. 

We have Oracle Certified engineers who do the installation. You do not need a consultant. Oracle's website is pretty good and has a lot of documentation.

There are licensing costs.

We have implemented PostgreSQL Server, but we use it for non-critical systems.

Oracle Database is highly parameterized and is so flexible. You can design the databases the way you want to. A lot of parameters are there, and the documentation is perfect.

I would recommend Oracle Database and rate it at nine on a scale from one to ten.

The platform supports our large-scale transaction processing needs by digitizing workflows within various governmental entities. It includes everything from applying required forms to processing payments and completing transactions automatically.

The solution is stable. It meets our high availability, resilience, and large-scale data management requirements.

The product requires higher expertise compared to Microsoft. It could be easy to use. 

We have worked with Oracle Database for over seven or eight years.

The solution is very stable and robust. It is more trusted and capable than other solutions like Microsoft.

The product is highly scalable. 

We have thousands of users across multiple locations and departments, all served by a centralized data center that supports various public sector departments.

We use it in our large data centers to manage and store large volumes of data with high availability and disaster recovery capabilities.

While I have previous experience with Oracle's global support, our local partners currently manage the support, and we haven't needed to escalate issues to the worldwide team.

The setup process can be more challenging than that of Microsoft solutions. However, it is straightforward once you have skilled personnel handling the deployment.

Different partners usually handle the implementation and deployment. We also have support contracts with the technology vendor covering updates, services, and other necessary support.

Oracle may require higher expertise than Microsoft. While Microsoft has a larger pool of professionals and is easier to use, Oracle offers more robust and capable solutions, albeit with a higher skill requirement.

We work with various technologies, including Microsoft, MongoDB, and others, and Oracle integrates well with all solutions.

I rate it a ten out of ten. 

The solution's most valuable feature is the row-level security that helps mask and encrypt data. In industries like healthcare and retail marketing, the details of patients' diseases and diagnostic reports can be masked using rollover encryption. In the financial sector, credit card numbers, user IDs, and passwords can also be masked using row-level encryption.

Oracle Cloud has a bit of a learning curve, so from an improvement perspective, we need to have a simple way to connect to computing in Oracle Cloud. Oracle Cloud should be leveraged to have structured, semi-structured, and unstructured data. Oracle Cloud should be like Amazon S3 bucket and needs to come with the versioning part. If the tool can provide options for versioning the data, it would be more useful.

There is a need to have backward compatibility from version to version. If a tool has all its versions, it would be better. Sometimes, we are missing the backward compatibility function in Oracle. Some versions are deprecated and removed. Migration somewhat involves coding of data and coding of queries, along with pre-querying the data.

I have been using Oracle Database for ten years. I am a user of the tool.

The tool is always upgraded as per the user's requirements. So I don't feel any issue. Stability-wise, I rate the solution a nine out of ten.

It is a good and scalable solution. Scalability-wise, I rate the solution a nine out of ten.

I have seen multiple use cases in different companies. I see that for one million or two million files, it works fine, but with twenty million files, it slows down because it lacks NoSQL properties. Around 30 to 40 developers use the tool in my company.

I have ten years of experience with the product, so I am habituated to installing the solution all the time. I did not find any issues during the installation of the product. The product is simple to install, especially because the instructions offered by the solution are very user-friendly. The tool offers a very good User experience during the installation phase. Each installation step is very well documented for a user to be able to understand.

I rate the product's initial setup phase as a nine out of ten.

The product's deployment process can be completed in a very optimal amount of time.

The tool's ROI is good.

The tool is expensive. Compared to its stability and eligibility, the tool is expensive, but if I consider the tool's ROI to be better, the tool is affordable with its set of features.

I use Oracle Database in our company's daily operations as we have a data pipeline which can cleanse the database. We have many connectors to ingest the data in Oracle Database. In the data lake, we do perform transformation, after which the cleansed data is moved to the warehouse.

The security features of Oracle Database match our data protection needs since it provides a particular user ID and a password while binding to the roles and privileges, like in the case of admin accounts and user accounts.

When it comes to data analysis, the tool has a very huge kind of data in it. In our company, we used to write queries, and Oracle helped us analyze the data, after which we can select a particular data set based on what we require. The queries are very fast.

The migration from Oracle Database 18c to Oracle Database 19c has affected my operations because I think that some of the features are being deprecated during each of the migration processes. I can rate the whole migration process as seven out of ten.

I started with Oracle Linux 7, and now I use Oracle Database 21c. The tool has matured and is good.

I recommend the tool to others. It is better to use Oracle's functions, whichever will improve scalability and app performance. The tool has many areas that will help us query data, code data, and perform analytics.

I rate the tool an eight out of ten.

The tool's most valuable feature is data encryption. The security features are good. They include field-level security, role-level security, and easy access controls.

The tool is costly, and migration is hard. We need tools like Database Migration Assistant for Oracle to migrate data between databases. Sometimes, older versions of Oracle are no longer supported, making the transition even more difficult.

I have been using the product for ten years. 

I rate Oracle Database's stability an eight out of ten. 

The tool's scalability is fine. However, you need to pay for additional nodes. 
Scalability is an issue because expanding the system requires additional hardware and licenses for each node. There's no option for mirroring the initial license across different nodes, so each new node requires its license. My company has 300,000 users. We're planning to increase usage gradually, depending on customer demand and database growth, aiming for about a 10 to 20 percent increase annually.

I used Microsoft SQL Server before Oracle Database. 

Oracle Database's deployment is fine. The deployment process for the Oracle database involves considering hardware compatibility. Licensing costs may vary based on the server model used.

The licensing cost is not based on a yearly subscription but rather on the number of devices used annually.

I rate the overall solution an eight out of ten. Consider starting with an open-source database instead of Oracle Database, as the enterprise versions and licensing costs can be quite significant.

My clients use Oracle Database for their ERP applications. Manufacturing companies use it for their ERP systems, and there are financial organizations, including banks, using the database to secure their data. They specifically use the enterprise database Oracle with licensed products.

Oracle Database is a Gartner-listed number one database, renowned for its robust and mission-critical capabilities. It is highly secure, with an architecture that prevents hacking incidents, making it the most secure database available. 

The database also supports mission-critical applications and large datasets, providing high availability and reliability. It is equipped with features like autonomous functionality and memory-efficient operations, reducing the need for machine resources.

Regarding room for improvement, there is not anything specific from a feature standpoint, as Oracle is a database company always enhancing and updating its products. However, the pricing could be more cost-effective, as the high price is driving some customers to consider migrating to open-source alternatives.

I have been connected with Oracle Database for 15 to 16 years, starting from my career's inception.

The stability of Oracle Database is excellent, rated at ten out of ten.

The scalability of Oracle Database is very good, which I rate between nine and ten.

Oracle's technical support is generally rated at eight out of ten due to some delays and challenges with ticket resolution, particularly regarding different time zones. The quality of the support is top-notch and deserves a ten, but response times can be improved.

Positive

The initial setup of Oracle Database is straightforward, with a step-by-step guide available. The abundance of documentation and resources makes it easy to follow along and complete the setup.

Oracle Database is highly-priced. Although it is robust and feature-rich, the pricing can be a concern for some customers, leading them to consider alternative options.

Overall, I rate Oracle Database a seven out of ten. While highly functional and stable, the cost remains a significant factor for many customers. If Oracle could make it more cost-effective, it would benefit many users. I rate the overall solution on a scale of one to ten at a seven.

The tool's most valuable feature is its ACID transaction, as it is a consistent way of storing the database. The tool offers an RBAC or a role-based access system, and as per the role, you define the role, and then only those forms, reports, and tables will be accessible to the end user. The tool's features are associated with the data security area I like the most.

Oracle itself does not provide an excellent migration tool to users, which is a shortcoming where the product needs to improve a lot.

The tool needs to do something on the columnar storage side, as we are storing it in a row right now. The tool has to offer some columnar storage.

I have been using Oracle Database for twenty-two years.

In India, the market is switching over to the cloud service provider because storage tools and everyone else are moving to the cloud side and are very less on-premises. It is very feasible for people moving to the cloud side.

The tool's price is high. The price is very high in the Asia-Pacific region. The European and US regions don't find the tool's prices high. In the Asia Pacific region, specifically Southeast Asia and the Pacific, like India, Singapore, and Malaysia, people find the price a bit difficult to manage.

Oracle's performance optimization has had an excellent impact on our database. It has a step-by-step approach, like excellent indexing. It also has an explained plan. I can use the explain plan, hints, AWR report, and tuning the query level and server level, which are all excellent features compared to other RDBMS tools.

The migration process to Oracle Database was pretty good, but Oracle itself does not provide any migration tools. Other vendors, like Microsoft Azure, AWS, or GCP, offer excellent tools for migrations.

I recommend the tool to others.

I rate the tool a ten out of ten.

We use the Oracle Database for applications such as sensor data management, banking tools, e-commerce forms, and similar functionalities. It is a data warehouse.

We have used the database in different production and environments. It has good features for performance tuning. I am using multiple environments for the Oracle web. The main functions are high availability, scalability, load balancing, and data integration.

The price could be lower.

I have been using Oracle Database for 7 to 8 years.

The solution’s scalability is good.

The customer support is better.

Neutral

The initial setup is neither easy nor complex.

The product is expensive.

Most customers use the stable version of the Oracle database. They should update it. Oracle V19 is the stable version.

Overall, I rate the solution a 7 out of 10.

We use the solution for ETL and real-time data analytics.

We use the solution for the ERP system, which utilizes dynamic APIs, SQL, and ETL processes.

The solution is easy to use. It also offers a Database Vault.

The pricing could be improved.

I have been using Oracle Database for five years.

The product is stable.

I rate the solution’s stability a ten out of ten.

Depending on where you deploy, Oracle is also scalable. Sixteen sites with 50 users each are using this solution.

I rate the solution’s scalability a ten out of ten.

The initial setup was straightforward and took a couple of weeks. You can set up a new instance, import/export databases, or a new blank database. For on-premise, we use Jenkins. We set it up for the cloud so we can receive alerts using Jenkins or any other suitable tool.

Deployment was done in-house.

The solution is very expensive.

We had an annual subscription, but Oracle only recognizes certain VMs. Eventually, we had to migrate to Oracle Linux and allocate a specific number of CPUs to a product to reduce the price.

Four people are required to maintain the solution.

Overall, I rate the solution a ten out of ten.