Oracle statspack and AWR generation scripts

 

 

Oracle statspack and AWR are two important tools for analyzing databases. The statspack used by Oracle 9i has released AWR for 10 Gb. The data they analyzed is almost the same.

Statspack installation and Report Analysis

Http://blog.csdn.net/tianlesoftware/archive/2009/10/17/4682329.aspx

 

Oracle AWR Introduction

Http://blog.csdn.net/tianlesoftware/archive/2009/10/17/4682300.aspx

 

With tools, it is important to understand the two reports. In Oracle 9i, we can view the statspack script to help us understand the report, but the 10 Gb AWR implements AWR through the dbms_workload_repository package. The package encapsulates all the code and we cannot view it. Therefore, you can only view the script generated by statspack.

 

Script location: $ ORACLE_HOME/rdbms/admin/sprepins. SQL

 

The code is long, but I understand it. It helps us understand the meaning of each data in statspack.

 

 

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

Blog: http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Chat group: 40132017 chat 2 group: 69087192

-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.