12c quick review
November 15, 2018
12c quick review
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database 12c
Oracle 12c is the only Oracle production database we are currently utilizing. The single pluggable database has so far worked very well for us and we are considering licensing multiple pluggables as we grow.
- Pluggable databases, as mentioned
- Temporary undo
- Invisible columns indexes
- PGA limit
- Identity columns
- Multiple indexes on a single column
- Cost
- Optimizer could be better. Many times generating stats on individual objects throws the optimizer off . Rather than utilizing the older better stats it uses the newer bad stats for specific queries
- Patching without taking down db.
- Ways to change parameters and force them to stay without taking down db
- OEM should be included in cost.
- Hard to learn as a newbie.
- Very expensive for startups
- Not on business side so cannot comment in honesty.
Currently I utilize SQL Server to support vendor code and do not go very much in there.