Oracle Performance Tuning and optimization (i)

Oracle Performance tuning is a broader and somewhat more complex topic, and the biggest problem for ordinary DBAs is where to start and what to do. All the information you know may be someone (a user) who reports a problem with the performance degradation of an application or query, and where do you start when faced with such a problem?

Oracle's tuning approach

For those who have already achieved the Oracle 8i Performance Tuning certification exam, there is a pilot area to experiment with Oracle's adjustment method, when Oracle 9i release Oracle emphasized this method changes, this method from 8i to 9i/10g some changes, two methods are not In exactly the same way, they all have their own advantages and disadvantages, and in Oracle 8i, the following steps consist of:

1. Adjust Business rules

2. Adjust data design

3. Adjust application design

4. Adjust the logical structure of database

5. Adjust database operation

6. Adjust Access Path

7. Adjust memory allocation

8. Adjust I/O and physical structure

9. Adjust Resource connection

10, adjust the basic platform

The basic principle approach to Oracle 9i, which is the order of precedence:

Priority description

First clearly define the problem and then specify an adjustment target

Second, check the host system and collect Oracle statistics

Third, compare the identified issues with the common Database performance method (version 1)/Database Performance plan (version 2) provided by Oracle 9i

Use the statistics collected in the second step to get a general idea of what might have happened on the system.

Mark the changes you made, and then implement those changes

(vi) Determine whether to meet the objectives set out in the first step, how to stop the adjustment, and if not, repeat steps fifth and sixth until the adjustment target has been met