12.1. Oracle's Tuning Methodology
When tuning a newly developed database system or a system that has experienced major changes, you can follow Oracle's Tuning Methodology. This methodology prioritizes the steps to take when optimizing a database system:
Priority | Tuning Focus |
---|---|
1 | Data design |
2 | Application design |
3 | Memory allocation |
4 | I/O and physical structures |
5 | Resource contention |
6 | Underlying platform |
Oracle's Tuning Methodology
A tuning method recommended by Oracle Corporation that prioritizes areas in tuning database performance. The six areas, in order of priority, are data design, application design, memory allocation, I/O and physical structures, resource contention, and underlying platform.
The tuning focus areas are as follows:
Data design This step ...
Get Oracle Database Foundations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.