Oracle Database Reviews

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

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.

I use Oracle Database to support the customized Java ERP setup that I currently have.

Oracle Database has improved how we do our administrative backups. The solution has a smaller footprint than 11g, it's more efficient on the resources for the users. It has a smoother user experience with the ERP and fewer field transactions.

Oracle Database is running on the same old hardware that I had the 11g version on and it is operating faster. It seems to be really good. It's fast even when the workload is heavy, easy to do backups and other administrative tasks with the Enterprise Manager. 

Oracle Database can automatically assign resources to threads that are heavy. We hardly notice when they are running a heavy query and it is better at managing memory than the older 11g version. When we use the same amount of indexes when migrating to 19c, I didn't have to do any other modification and we have increased usage on the ERP. The Oracle Database is handling everything very well.

Oracle Database could improve by having a better-integrated view of the containerized databases. The Enterprise Manager is great at that, but if there was a centralized view of all the containers it would be a large benefit.

I have been using Oracle Database for approximately one year.

The reliability of the Oracle Database is excellent and the performance is very good. I have used MySQL for large transactions which have given me some problems, but in Oracle Database version 19c I have not had these issues. In the Oracle Database version 11g, sometimes I would have some lagging, but in the newer version, it has been fine.

The scalability of the solution is good.

We have approximately 70 users that are using the solution through the ERP.

The support I have received from Oracle Database has been very great. The response times have been good.

I have previously used MySQL.

The initial setup of Oracle Database is straightforward, it was easy. The migration from an older version was not a problem at all, and it took under one hour.

I did the implementation mostly myself, but because of the ERP setup, I had to have support from the vendor. It was a partnership setup.

I do the maintenance of the solution, we only require one person. I use the solution on a daily basis.

Oracle Database could make the documentation better around licensing. The way you have to access software from Oracle is difficult. You have to go through the licensing lawyer to understand what your reach is when you subscribe to one unit. I wish the documents were easier to understand for everyone. This is a problem I have always grappled with and it's not changed. Having clarity is even more important now that I'm thinking of having a hybrid setup for the database in the cloud for high availability.

The cost of the solution is reasonable. It costs approximately $4,000 with some extra features we have.

I would recommend this solution to others. However, it does depend on different organizations and their needs. If the resources are a little heavy, which makes for disaster recovery planning, a little bit tricky.  

I would advise people to explore how their workloads would be and if they can be containerized in the cloud. That would make it way easier for them to manage them. The scalability of Oracle Database is very easy to grow or shrink as the need.

I rate Oracle Database a nine out of ten.

I work for an insurance organization and we have been using Oracle Database for our application architecture. We store all the user-level information in the Oracle Database that our company deals in, such as policy information. Before I joined this organization, they were only using the Oracle Database but now we are migrating from Oracle to the SQL Server Database. For any new applications that are getting built or designed, we are trying to use SQL Server instead of Oracle.

I have been looking for a virtualization database engine from Oracle. They have third-party vendors that can do it but if Oracle comes with its own virtual engine, it would be helpful. Additionally, the solution could be more user-friendly and improve the Transparent Data Encryption. 

I have been using Oracle Database for approximately 10 years.

Oracle Database is stable.

The solution is scalable.

We have approximately 2,000 users using this solution.

I have been satisfied with the technical support from Oracle.

We use SQL Server.

The installation was not a good experience it took a lot of time.

We have a 10 person technical team which consists of administrators and managers that do the implementation and maintenance of the solution.

We have been paying for an annual enterprise license Oracle Database.

If I had the choice to pick between Orcale Database or SQL Server, I would choose SQL Server.

I rate Oracle Database a seven out of ten.

I use the solution in my company for developing applications, of course, with the ERP in place, along with the different modules that are related to the financial system, HR's internal functionalities, project management, and invoicing. My company uses it more for the in-house development of IT applications.

The most valuable feature of the solution is database management, which is good, along with the backup. The server-based programming, PL/SQL, is good.

The high price of the product is an area of concern where improvements are required. In general, the product should be priced more economically for users.

I have been using Oracle Database for thirty years.

It is a very stable solution.

It is a scalable solution. You can always tune the parameters and decide on how much to scale based on the memory available. You can configure your SGA along with memory, and once you outgrow it, you can always reconfigure and re-initiate it, making it a scalable tool.

Over a long period of time, my company has been dealing with a user base of various sizes. There are times when the user base can go up to 200 people.

The product is extensively used, and my company plans to increase its use in the future.

I have used the product's online community to get answers to the questions I post related to the tool.

I have experience with Ingres. My company started to use Oracle Database because of its flexibility and the availability of more tools. The overall comprehensiveness provided by the tool was good.

The product's initial setup phase was very easy. There are no real challenges in the setup phase, as it is a sophisticated product.

For the product's deployment phase, if you have your operating system ready, you can decide whether you want to put Oracle Database in Microsoft or Linux, after which you need to make the prerequisites available for JRE or Microsoft's .NET platform. Once the prerequisites are in place, you can download a suitable VM, and the deployments can be done.

The solution is deployed on an on-premises model.

There is no need for a team to take care of the deployment and maintenance of the product since the tool is well-documented and a lot of information is available in it. In the past, the deployment and maintenance of the product used to be a bit tough. Over a period of time, the deployment and maintenance of the product have become quicker and easier.

The product is costly. You need to pay for all the product components that you use. You can go for an annual or multi-year subscription model, depending on your requirements.

Currently, my company uses the tool for record-keeping purposes, specifically for some information. My company uses Power BI for real-time data analytics.

The critical applications our company runs on Oracle Database are attached to areas involving invoicing and financial systems.

The security features of Oracle Database are good, reliable, and stable.

The cloud-based solution available is good for those who plan to start using the tool. Instead of choosing the on-premises version, people can go with the tool's cloud-based version. Potential uses of the product should attempt to start small, and then when the need arises, they can grow the tool's usage capacity. The tool offers fallback, resilience, and redundancy features, which you can always add whenever required.

Though I have never tried to use the migration capabilities of the product, I know that there is a process for using it, which is not very difficult but sometimes time-consuming.

I rate the product an eight out of ten.