Oracle Database Reviews

1. Adaptive Query Optimization - enable the optimizer to make run-time adjustments to execution plans and discover additional information that can lead to better statistics. This new approach is extremely helpful when existing statistics are not sufficient to generate an optimal plan.
2. Pluggable databases - allows you to put 253 databases into one instance of Oracle.
3. Redaction Policy - The Oracle Database 12c provides runtime protection of sensitive data. The stored data remains unchanged, while the data to be displayed to the end user is transformed on-the-fly before leaving the database.

I have worked on an Oracle databases that processes over 100 billion rows daily as well as provide reporting in a timely manner to end users. Oracle's years of maturity and continuous improvement allows the database to perform exceptionally well especially on Oracle's Exadata hardware.

I would like to see Oracle Business Intelligence and maintenance tools incorporate virtual reality interfaces so DBAs and end users could interact with the database.

I have used Oracle over 15 years and the database is very scalable, reliable, and well supported.

There were no issues with the deployment.

We have had no issues with the stability.

We haven't needed to scale it.

I think that the most valuable feature of Oracle Database is the knowledge base that's available. If there's a bug, I can find the solution in the knowledge base. If I need to know why something's happened, or whether there's a workaround, I can find the solution in the knowledge base. There's a wealth of information available there, and I live and die by it.

Our core business relies on its ability to work with RDBS. You could say that we make all our money by using Oracle. Since version 8i, it's been my bread and butter. I love the product and use it every day.

The features that are there, it usually works perfectly. The new features, you see that it takes some time to pick up and sometimes they break things they really shouldn't.

I've been using it since Oracle 8i, which was 18 years ago.

We've had no issues with deployment.

Oracle has added a new optimizer option to do some very fancy stuff, but it provides the wrong results. And at this stage in the life of the product, wrong results should never happen. That's why I have Database -- to get the correct results.

It scales very well. With NoSQL though, there are scalability issues because it just cannot spin up. But I've found that with Hadoop and AWS, you can spin up to 2,000 new nodes and it works fine. You can't do that with Oracle, but it's legacy software nowadays.

Technical support is fine. Fortunately, we don't have any priority-one issues within our business that depend on Oracle Database. For minute-to-minute operations, I get a good enough response from technical support.

As a vendor, we support older versions and the customer will never touch them. I really don't need to ask technical support for a fix, I know that the customers will not use it.

We haven't used a different RDBMS since I started with the company.

The initial setup was done before I started my current position.

The implementation was done before I started my current position.

I mainly use this solution for data warehouse applications, report generation, and transactional data processing.

Partitioning is the most valuable feature.

It would be useful if I could connect to an expert for one-on-one help.

I've been using Oracle Database for more than twenty years.

Oracle Database is stable and reliable.

The basic initial setup was straightforward, but a professional would be required if the solution needed to be fine-tuned.

I've seen a good ROI.

Oracle Database is expensive.

I would recommend Oracle Database to others - it's a well-developed solution and is accepted on the market. I would give it a rating of eight out of ten.

We're using Oracle Database for corporate enterprise resources planning, manufacturing systems, etc. It's deployed in a Red Hat Linux environment.

I've been using Oracle Database for about 15 years.

Oracle Database is stable. I'm quite happy with the performance.

Oracle Database is scalable. We're running it on around 250 devices.

We previously used some small-scale SQL servers running Microsoft SQL Server for access control.

Installing Oracle Database is straightforwad. 

The price should be lower. We're currently paying for it yearly.

I rate Oracle Database 10 out of 10. I would definitely recommend it.

Most of the use cases for Oracle Database I was involved in were for data migration. I was performing analysis and writing scripts to support the data migration from one data model to a new data model within the database. I wrote PVT scripts to test to make sure that the actions expected were all completed correctly. Additionally, I did ad hoc analysis in Oracle Health data quality issues and potential issues.

The interface of Oracle Database is very workable and easy to use.

The monitoring of processes that are executing could be better. I find it very difficult to find processes that had been in a suspended state in order to stop them.

I have used Oracle Database for approximately one year.

The solution is reliable and stable.

We have approximately 10 to 100 users using the solution in my organization.

I work in a medium to large enterprise and there are dedicated teams that do the implementation and maintenance of the solutions.

I would recommend this solution to others. It is a good performing database on medium to large data sets. The SQL Developer is a full-function user interface.

I rate Oracle Database a seven out of ten.

We use this solution as the core database in the banking and insurance systems.

Oracle Database is easy to use.

I would like to see more security included.

I would also like to see more features added and the stability needs improvement.

I have been using Oracle Database for five years.

We are using the latest version.

The stability of the Oracle Database needs to be improved.

Oracle Database is a very scalable product.

Technical support is great, but it can be faster.

Our users have used Windows 10.

I have used Oracle Linux for six years.

For someone who has used Oracle, before it's easy.

We have a DBA and our technical team of six who maintain this solution.

The license fee is paid annually.

The fees are another area that can be improved. The pricing should be cheaper.

I would recommend this solution to others.

I would rate Oracle Database a nine out of ten. Because we work in banking and insurance systems, many people use this solution.

We use this solution based on the requirements of a client.

We primarily use it for a client that has a huge amount of data and has another application that also has lots of data. It's very good at handling jobs that have huge datasets.  

I'm not a regular user of the solution.

It's a great product overall.

The initial setup isn't too difficult.

The product does have a lot of features. However, I've barely explored them.

The main issue with Oracle is the maintenance required. They should work to make it less maintenance-heavy. This is especially true if you are using it on Linux. You need more experience and skills in order to maintain it on Linux in general.

We've had corruption occur if the power gets cut off. We had a bad experience with some cases. However, this might have been due to our own infrastructure issues that have since been dealt with.

We've used the solution for three or four years.

The solution isn't widely used by our company. I'm the only one testing it. The people in our company don't use Oracle at all.

I've never directly dealt with technical support. I cannot speak to how helpful or responsive they would be. Whenever I have a problem or issue, I google it and search for answers online. 

While I don't have much personal experience, my understanding is that the initial setup isn't too difficult. It's pretty simple and straightforward.

In our organization, we don't use Oracle, aside from in labs. We use Oracle in our labs just for testing and connectivity. We have versions of Oracle in our labs and other SQL devices.

We don't really use the solution too much in the company and therefore don't have a license. We test it for customers. I can't speak to the licensing process or costs. 

I'd rate the solution at an eight out of ten. It's mostly been a positive experience, working with the product.

Between Oracle and SQL, I would recommend SQL to other users and companies. 

Once we get the installation done, we migrate items to our new DB and we maintain the service with tasks such as clearing the caches and taking the backups, and checking the logs. We look at what it's doing - if something's wrong or if there are any kinds of issues. Occasionally, we do some performance tuning.

The latest version is a lot more organized than the previous version. We can check out the regular files and our dictionaries and our created files, which are a little better organized right now.

The initial setup was pretty simple.

The solution is pretty stable.

The previous version was a little clunky. 

I'm not exactly experienced in troubleshooting. There are issues that I can't really fix. Sometimes I'm helpless with Google also. Trying to learn to identify the exact issue I was getting a Boolean error. I need to improve my knowledge. I'd like to have more documentation or assistance in this area.

The solution could be more user-friendly,

I've been using the solution for five or six years. It's been a while.

It's a wonderful product. Those that have a lot of experience working with the product, those with ten or 15 years of experience, will be able to understand its core processes. Those with only a few year's experience will feel there's a certain lack of transparency.  That said, I haven't had any issues with bugs or glitches, and when it is set up correctly, it doesn't crash or freeze.

The initial setup is not complex or difficult. It's straightforward and pretty easy to set up.

If you are experienced it is an easy task for you, however, it is a process. We have to check every step. If we've done something wrong in any step, then the whole installation process will be for nothing. New errors will come up. We have to document everything and we have to have the requirements clearly laid out. I've learned the hard way that you cannot take shortcuts.

We're just a customer and an end-user. We don't have a business relationship with Oracle.

We have our primary DB on Oracle 19C.

We have to manage everything, including the frontend and backend.

I'd rate the solution at an eight out of ten. If it was more user-friendly, I would rate it higher.

I would recommend Oracle Database to others. We have some colleagues who are doing some small-scale businesses. For them, it might not be suitable. Not everyone should get into Oracle. It is a standard product, however, you need to understand your exact requirements.