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.
Course Features
- Lectures 2
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 5
- Assessments Yes
-
Tutorial Lessons