1. Home
  2. Relational Databases
  3. Oracle Database Reviews
  4. User Review of Oracle Database
Oracle Rocks!!!
September 18, 2019

Oracle Rocks!!!

Subrat Mishra | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database

We are using Oracle Database for all of our critical applications for both OLTP and DW usage. It is used across the organization. It provides us a single platform to store all of our critical data and then extract it to use for analytics. It provides us an efficient OLTP database for managing high traffic processing applications
  • Nice SGA management
  • Easy to apply profiles on poorly performing SQLs
  • One platform for both OLTP and analytics
  • Auto SQL tuning
  • Better LOB management
  • XML Processing
  • Positive rate of transaction
  • Scalable
  • Fail over safe
We are mostly using Oracle, but in some applications, we do have Microsoft SQL Server. The RAC feature makes it high availability compared to SQL server with active/passive mode. Memory management is much better in Oracle and it's easy to scale up and down. Oracle is much better designed than any other database.
Oracle is mostly good for OLTP based transactions. I see it is limited for the micros service, but I am still exploring that area. Invisible column and identity columns are well used in my applications.

A little more effort on making SQL Developer a better tool could drive the usage a lot more.