Oracle Database Reviews

Row Locking, which is probably the reason why Oracle is number one.

Oracle database is more reliable than anything else.

From my point of view as a DBA, the administration tools, especially the database administration tools and the developer tools. They are still behind compared to Toad or anything else.

It's pretty stable.

In terms of scaling, I haven't seen any issues. I don't really like RAC. From our experience, the single instance was better for us than the RAC. We do have RAC and the single instance, but we are actually moving our RAC machines to the single instance because the overhead by direct was not really acceptable. One of the main reasons was because now you have to use ASM, and we didn't find ASM very efficient.

It's probably the worst tech support that any company has, compared to anything that I have worked with.

It's a nightmare if I have to open a service request. I opened a simple service request with a question about two months ago. I found the workaround, but the service request is still open. No one ever even bothered to answer anything, and it was level-2.

Go through the concepts. Once when you get the concepts, then you can easily figure it out. Everything is available, but you have to know what you are doing with the database otherwise you can screw up very badly.

Oracle Database helps you store and root through data as fast as possible, which is really valuable to our organization. In addition, while I can do everything I would like to with the product, if there is something that is not possible in the current version, you can build your own features.

The expansiveness of the Oracle Database has been beneficial. You can find more than you could ever think of in the product, which increases business efficiencies by returning information to you quickly and allowing you to do work in the database that you would otherwise have to do in a different application.

The product could have more persistent data types, like Boolean and the simple features in MySQL and most databases.

It is so stable that I have this mantra: “If you have not crushed the server you have not been trying hard enough.” I have not crushed it in a long while. It is really stable.

It scales very well.

It is pretty good. They always ask the same questions about log files, so since we already know what they are going to be asking, it’s pretty fast. Most of the time they come up with solutions really quickly.

Do as much as you can in the database. It is the fastest product you can have, when working with data. The product is an eight out of ten.

Partitions and the various methods available

Statistics for the Partitions Lack of support for Oracle Text Indexing with all the various partitioning options

Gathering Statistics is important for query plans. However, in a partitioned table environment, it would seem that each partition of a table would have about the same number of records especially when the major key is something like transaction date. So why not have an option to copy the statistics from a "standard partition" when a new partition is added? OR allow for parameters in the table partition metadata to store and update the values that have to be copied for the statistics. The partition is not fully loaded until the end of the "transaction day" and maybe the auto-statistics gathering processes can then make the updates to the finer points.Update:Gathering Statistics on Partitioned Tables using the INCREMENTAL = TRUE setting for the table keeps the statistics gathering humming nicely. A bit of a "to do" for the first time though. Also need to be aware that some disk space will be used to store statistics which can be referenced for the next run of gathering statistics (augmenting?)

I mainly work on business intelligence with Qlik and use Oracle Database for the reporting and replicating. Together, we use Oracle Database and Oracle MySQL for this PoC.

We use MySQL to feed the data to the Qlik compose.

The procedures work very well. 

It's fast compared to other databases.

The syntax options are available in Google.

The initial setup should be improved.

I have been working with Oracle Database for three years.

I have not worked on Oracle Database a lot, as I concentrate on business intelligence. However, I have not experienced any issues or limitations.

It's a scalable product.

I have not contacted technical support. It's is handled through my internet team.

During the installation, we had to install certificates, but it was not mentioned in the documentation.

Definitely, I would recommend this solution to others.

I would rate Oracle Database a nine out of ten.

On-premises

Oracle Database is really good for a distributed system and the scalability is really good. We use it for a large amount of data and it gives us good performance. For really complex, distributed business cases, it's a really good choice.

• I really appreciate the performance of Oracle.
• When using AWR records you can really see where a problem is.
• You can get advice about which queries are the heaviest for the database.
• You also can see advice for indexes. If an index isn't used, then you can remove it to improve performance. This is a really good feature. 
• The JDBC connection is also quite good.
• The object types are really good, the types of tables you can use in PL/SQL are also really helpful.

Its performance could always be better and better but, other than that, I can't think of any additional features I would like to see.

More than five years.

It's stable. It's good. But I think it could be better.

The scalability is quite good. We have experience in many countries with distributed systems and it has really satisfied us, and our clients are satisfied as well.

We did not have a previous solution, as far as I know.

It's not really good from the pricing point of view.

I would recommend Oracle Database if you have enough money and you need a big, stable system in which performance is important.

We are starting to think about other solutions because of money and because of the cloud. Oracle is on the cloud, but we have started thinking about another cloud, which could use PostgreSQL and Microsoft Server. That may be our solution in the future.

The most important criteria when selecting a vendor are their ability to handle a huge volume of data, security, and then price. Price is not the first one, but it's an important one. And finally, the cloud could be important.

I would rate Oracle Database at nine out of ten because of the stability and because they try to improve the product in every release. The next release is always better than the previous one. From release to release, we get more performance, which is really good. Even if you aren't a DBA, there a lot of features that you can put to use by yourself.

Ease of the database. 

I can't think of anything to improve the database features.

More than 12 years.

Stable, absolutely.

It's scalable, it will meet the needs of our company, moving forward.

I had some issues that were resolved by the Oracle support team. There was an issue that I reported myself and the response time was adequate, within expectations. Eighty percent positive.

I don't know. From the time I was employed here it was already installed and working and up and running.

At first, when I was in the learning stage it was a bit difficult to install with Linux or Unix in the environment. Only with Windows can you can install it using a wizard. 

You should have some knowledge, to be familiar with it, the product for installing and plan managing. It was not easy.

We were using Oracle Streams, that is deprecated right now. Before we changed it to Oracle GoldenGate we were just using Streams.

I recommend this product. It's stable, advanced, I think it's the number-one database.

We are using Oracle Database for corporation development.

Oracle Database has high-level features that are very good.

The solution could improve security.

I have been Oracle Database for approximately 12 years.

The solution is scalable.

We have approximately 200 users using this solution.

I have previously used MySQL.

We have a four-person team that does the implementation and maintenance of the solution.

The price of the solution is expensive compared to other database solutions. We are on an annual subscription.

I would recommend this solution to others.

I rate Oracle Database a nine out of ten.

On-premises

We use this RDBMS for OLTP, OLAP, and Data Warehousing.

This solution is easy to use, provides good tuning options, backup & recovery, and overall a professional network.

The most valuable features of this solution are the cost optimizer and partition exchanges.

The cost of this solution needs to be improved.

We have been using this solution for twenty years.