Oracle Database Reviews

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.

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 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 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 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.

We use the solution for data warehousing. 

The tool supports a large volume of transactions compared to other databases we've used. One feature that had a significant impact is Oracle Data Integrator. It allows us to transfer data from the enterprise database to the data warehouse. This is useful for creating different data sets for finance teams and other departments.

Oracle Database offers encryption and decryption features, which help avoid cyber attacks.It is easy to transfer data from different countries to one location. This helps us provide information to higher management for decision-making.

The tool's deployment and configuration is difficult. Sometimes, the network DNS settings aren't connected, so we need to check and enable the configuration, which is the difficult part. Maintenance requires a bit of effort. We need to monitor the database performance, check the number of concurrent users on Oracle, and handle any unwanted queries from users. You need at least two people to do it. 

I have encountered delays in getting support. 

Neutral

I have used Microsoft SQL Server and MySQL before Oracle Database. Microsoft SQL Server is very easy to use compared to MySQL. It offers simplicity in loading and exporting data, making it more user-friendly.

The tool's pricing is high and yearly. 

Most of our applications already use the database, so the impact is minimal. We use Oracle Data Integrator for migration. I rate the overall product a nine out of ten. For database usage, Oracle Database would be suitable if it's an enterprise organization. For mid-sized organizations, Microsoft SQL Server would be a good option.

I set up ERP projects for applications and databases to implement infrastructure and scalability. The solutions include SAP and IFS on the Linux operating system. 

When planning a database strategy for running applications in a client-server environment, Oracle Database can integrate smoothly and steadily. 

The MS SQL Server is cost-effective, however, fails to meet global centralization in IT. SAP and IFS also recommend that transactions exceed certain numbers and need to be replaced with Oracle Database instead for performance issues.

Oracle Database covers performance capabilities, scalability, security features, and integration with cloud technologies. We selected the top choice for organizations across industries after an overall assessment. For Linux platforms in cloud solutions, Oracle is committed to supporting business industries and maintains its popularity for memory-based enterprise data. 

For expansion, Oracle can quickly expand its capacity to handle growing data needs by adding additional server resources. It is designed to offer high-performance capabilities in order to handle complex, demanding workloads.

For Oracle's 12c version, the database in-memory enhances query performance by storing data in a columnar format. This makes it faster to access and analyze large datasets. It improves data warehousing and analytics surrounding the API. 

Although we embed in MS Azure, the overall cloud technology improves software/hardware revision, database partition extension, data file reallocation, and multi-thread instance issues. For most DBA concerns, Oracle helps resource revision and reduces the efforts of software and hardware ever-upgrading. 

Cost is always a concern. Improvements in licensing models and resource utilization could help organizations reduce their overall costs.  

For SAP views, Oracle integrations are more enhanced than MS SQL, however, the Azure solution may be the next generation needed to evaluate OS and application/database for single-sign-on compatibility. 

I've used the solution for five years.

The primary use case is a stable relational database used to manage business applications with less downtime for the business. It seems to have the ability to scale up and down depending upon business needs. We needed a database with effective backup and recovery tools to protect the database against data loss and reconstruct the database quickly in case of any loss. The database addresses information security by providing cutting-edge security features to protect corporate assets and data critical to business.

Oracle Database is easy to install and set up. It has provided great stability and reliability to meet business requirements. The performance of the database is very good and is able to handle extensive workloads. It can run complex queries without any issues. 

Oracle Database offers great new features in every new release and these features provide more enhancements for running and developing smooth database operations. The database backup and recovery tools are easy to use to protect data from any failures.

Oracle Database offers performance, scalability, reliability, and security which are important for any business. 

The Oracle Data Guard helps with high availability, data protection, and disaster recovery for enterprise data. It also helps to survive disasters and data corruption while creating, maintaining, and managing one or most synchronized standby databases important to a business. 

The Recovery Manager (RMAN) is a great feature for backup and recovery which will enable to per perform cold, hot, and incremental database backups, as well as point-in-time recoveries to protect data. 

The high availability features are a little complex to set up and manage. I would like to see some improvements in this feature to make it easier to manage.

I would like to see generative AI services integration to help organizations automate business processes, enhance customer experience and collaboration, and improve decision-making. I'd also like to see increased performance.

Oracle comes with great new features with every new release. These new features help to facilitate and enhance smooth database operations.

I have been using the solution for 20+ years.

The product is very stable.

The solution has great scalability solutions.

The solution has good support. That said, it needs improvement. 

Positive

I did not previously use a different solution.

The product is easy to set up - except for the high availability features, which are difficult to implement.

We did not implement the solution via a vendor.

The ROI I have witnessed has been good.

It's great product, however, it is a little pricy for the licensing costs. 

I did not previously evaluate other options. 

If you need a better product, then you need to plan the budget accordingly.

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.