Oracle Database Pros and Cons

Compared to other databases, Oracle Database is very simple to manage in terms of the database itself.

The feature I find most valuable about this solution is the reliability.

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 just remove it to improve performance. This is a really good feature. Also, the JDBC connection is quite good. Finally, the object types are really good, the types of tables you can use in PL/SQL are also really helpful.

Using the product, we make less mistakes, are more organized and faster than if we did it any another way.

It stores a lot of data in a short time.

It is flexible, scalable, and a true Enterprise RDBMS.

High availability using real application clusters.

This solution has the best performance, bar none.

Oracle Database is fast and easy to use.

Oracle enables us to handle more than a million daily transactions.

It has automatic memory management capability and large file capability.

The product is very expensive.

There are a lot of bugs in the Oracle Database, and it would be better if the bugs would be solved more quickly than they are today.

In general, the support is not good since most of the time the person whom you are given to is not so professional.

Integration with big data would be helpful since we are planning to load a lot of big data.

A lot of features have bugs or choose the wrong way to process data.

Auditing could be improved, especially granular auditing. The unified audit trail in 12c is great, however its extraction in a highly busy environment is quite a challenge.

The documentation needs improvement because as it is now, providing support is a headache.

Cheap and easy solutions for startups need to be made available.

The price tag is very high and most cannot afford it.

The Oracle Database could improve on integration with other infrastructure systems like Active Directory.

This product would be improved with Support Services for more production access.

The cost of this solution needs to be improved.