Stabilizing Oracle 12c Database Performance with Baselines
Learn how to prevent Oracle Database performance regression with baselines.
DBAs know that Oracle databases can have dreadful problems with stability ever since release 7 introduced the cost-based optimizer. A query runs well today and tomorrow it’s a disaster. Why does this happen? Because of dynamic parsing.
The problems of instability should be history for all new upgrades to 12c. SQL baselining is actually introduced in 11g but it’s greatly enhanced in 12c. It can give you a guarantee that performance will never degrade.
This free Oracle Baseline tutorial is segmented into the following lessons:
- Introduction (2:38) (click on video below) (click to read the Transcript)
- Baseline Demonstration (4:06)
Date: Mar 10, 2015
NOTE: Some corporate firewalls will not allow videos hosted by YouTube.