Must for mission critical workloads where downtime will cost you money
September 18, 2019

Must for mission critical workloads where downtime will cost you money

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Database 12c

It's our main production database which is used company-wide by a number of applications.
  • Auditing and debugging compared to other databases and the ability to go to a point in time using the ASH and see what was going on in the database is very useful.
  • Oracle flashback, the ability to restore a table to a point in time without having to restore from a backup, is helpful. Also, the ability to see how a row has changed over time is great.
  • APEX, which comes free for developing front end user applications.
  • The ability to use online re-def for tables that have identity columns would be very useful.
  • Native support for CQN queries in APEX.
  • Being able to flashback a table to before a corruption has saved us thousands.
  • APEX has allowed us to create front end applications in under a day and have them live in production the next.
We currently use all of the above database technologies in different applications, but where the application is mission-critical we use Oracle. Microsoft SQL Server is good for canned applications such as back-office or HR. MySQL does not have the same level of logging or debugging that's available in Oracle Database 12c.
Well suited for large scale applications where auditing and high availability (if using RAC) are needed or where an outage could cost your company a lot of money. It's less appropriate in situations where availability is not so important and the cost associated with Oracle is not worth it.