My experience with 12C
December 20, 2017
My experience with 12C
Score 7 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Database 12c
Our products are built on 11g. Various departments across the organization are on 11g. Slowly we're migrating to 12c databases. While some products are migrated others are in the process of benchmarking. One of the cool features with significant impact to us is "storing historical context variables" in flashback archive (FBA).
- Pluggable DB & Temporary Undo
- Historcal Context variables tracking
- Adaptive plan management impacted the performance of a few SQLs. Resetting optimizer version to 11g mitigated risk.
- For one of the products we had issues with connection pooling and we had to back out the 12c upgrade within days. Later Oracle released patches though!
- We're in procecess of migration to 12c.