Oracle Database Reviews

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. 

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.

We use Oracle Database to store large amounts of production data for our manufacturing industry clients. Our software analyzes this data to optimize production processes and ensure quality. We then use the insights to control production machines and fine-tune sensors for better performance.

The most valuable features of Oracle Database for data management are its ability to handle large datasets seamlessly, support for writing custom PL/SQL stored procedures, and its capability to perform complex computations and statistics directly within the database. These features allow us to manage millions of database rows efficiently and run analytical processes on the database machine itself, rather than relying heavily on front-end applications for visualization and support.

Improvements in Oracle Database could focus on simplifying deployment processes and providing clearer documentation. The installation process can be complex, especially across different architectures and operating systems, leading to manual adjustments and longer setup times, often taking around two months with multiple people involved.

I have been working with Oracle Database since 1990.

Tech support from Oracle has been lacking, as they often resort to trial and error rather than providing specific knowledge-based solutions. The support process involved trying different versions and configurations without clear guidance, leading to frustration and dissatisfaction with the level of assistance provided. Oracle's support for installation, particularly in Unix environments, needs improvement. I would rate the support as a two out of ten.

Negative

Deploying Oracle Database initially can be a bit challenging and not as straightforward.

Oracle Database is often perceived as expensive compared to alternatives like Microsoft SQL Server. Many customers opt for mixed environments, with production data stored in Oracle Database and analytical or reporting data transferred to Microsoft SQL Server for easier access and cost efficiency. The high cost of Oracle Database licenses and support drives this decision.

We optimize the performance of Oracle Database by monitoring logs, analyzing performance metrics, and tuning specialized tables. We can also utilize features like Database Warehousing for specific data analysis needs, ensuring efficient performance even with large datasets.

Oracle Database sometimes introduces new features that may not always be necessary or relevant to stable systems. For example, adding complex data types like datetime with nanosecond precision may not be practical for many users. This approach can lead to an increase in features without clear benefits for users.

If you need a highly available system capable of storing vast amounts of data over the long term, I would recommend Oracle Database. However, for smaller projects with less demanding data needs, other technologies might be more suitable.

Overall, I would rate Oracle Database as an eight out of ten. It is a great product.

Our transaction system is designed using the Oracle Database.

In our day-to-day operations, it's evident that we should have a transaction system. Our channel partners are also onboarded on the same platform, and they do the transaction. We need to track, so we need a single platform. Our internal data management system runs on Oracle Database. The solution has good security features.

The solution’s integration could be improved.

I have been using Oracle Database for 20 years.

Oracle Database is a stable solution.

I rate the solution a nine out of ten for stability.

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

The solution’s initial setup is complex.

Oracle-skilled people are easier to get, and that's why we want to keep the solution intact.

We need to pay an annual subscription for the solution, which is moderately priced.

Oracle Database is on-premises, and we want it migrated to the cloud. If you're a new organization to start with an IT role or IT design, start with the cloud. If you are an old user of IT infrastructures, then it's high time to migrate from on-premises solutions to the cloud. It was easy to migrate to Oracle Database from another database system.

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

We are storing our data in Oracle. We collect data from a third-party vendor, transform it, and put it in Oracle. We use it as staging for report development.

The features are similar to any other database. Our company is a financial organization. Most financial organizations are run on Oracle. Oracle's security features are up to the mark. It is being approved by a person in our organization who controls and governs data. The solution has every security aspect that needs to be there in enterprise software.

The stability could be improved.

I have been using the solution for two years.

The tool is stable. I rate the stability an eight out of ten. We are still testing some of the use cases with more data. We must optimize it at the query level. We need to increase the resources if we have to get the throughput. The tool performs at a level where we get the expected results.

The tool is scalable. We have DevOps. We have 200 users in our organization. We use it extensively.

We have a team of 10 to 12 members to deploy and maintain the solution.

We work as an individual contributor. I work for an enterprise. The organization makes sure that the security is intact. They ensure that every security request comes or gets approved by a stakeholder or a data steward who knows what they are approving.

Organizations that want to use the tool must see if Oracle will be helpful for their use cases. My advice depends on the use cases. The use cases are decided at an architectural level depending on the organization's technology stack. Finance companies use Oracle as a front-end solution. If we use Oracle E-Business Suite, we will use Oracle Database. If we use Oracle Database, the organization will push it to every other application.

If we need to process data for monthly or weekly reporting and do a Delta load, Oracle is sufficient. Suppose we are already using it and paying for the license. In that case, using it for other applications is better than investing it in any other database and procuring hardware. It all depends on the use cases. Oracle is one of the oldest and most well-known databases in the market. It is stable and has a good development team.

Overall, I rate the product an eight and a half out of ten.