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
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.
Pros
- 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.
Cons
- 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.
Comments
Please log in to join the conversation