Detailed analysis of new Oracle 10g STATSPACK features

About Oracle 10 Gb performance, the most talked about is the new automatic workload repository (AWR) features and proactive performance monitoring through automatic database Diagnostic Monitoring (ADDM. They are widely reported as an alternative to STATPACK. Indeed, according to Mr. Niemiec, they can do more to represent the future of Oracle performance analysis.

However, he also said not to ignore STATSPACK, not only because it still exists in Oracle 10 Gb as a heritage, but also has made many updates, including a large number of new tools that can be used in AWR. To fully use AWR, You need to register the diagnostic package and analysis package, but STATSPACk is included in the Oracle price.

Here are some new features mentioned by Mr. Niemiec in Oracle 10g STATSPACK:

1. Time Model statistics: Oracle's time model includes db_time, the time required to process database requests, and various waiting times when a session waits for a certain resource. The time model statistics break down db_time into its components. Therefore, you can view the processing time spent by Oracle through the operation type.

2. Wait event bar chart: replaces all counters that record the number of waits for each type of occurrence, and the column chart continues to separate various counts based on the time. You can check how much wait time is less than 1 ms, how much less than 4 ms, and how much less than 8 MD wait time. If you want to check the wait time, this may not be a preferred analysis tool, but they are simple.

3. Read File bar chart: like the wait event column chart, it splits the disk block count according to the time required for reading. You can easily view which devices are not performing well.

4. Operating System statistics: it displays the ratio of CPU idle time to user time, the ratio of active time to idle time, and the number of incoming and outgoing bytes.

5. Withdrawal statistics: This is a detailed Measurement Method for withdrawal efficiency.