How to generate an oracle AWR report

1. generate an AWR report

[Ractest @ Sun880 - 1   / U01 / App / Oracle / Orahome / RDBMS / Admin] $ cd $ ORACLE_HOME / RDBMS / Admin
[Ractest @ Sun880 - 1   / U01 / App / Oracle / Orahome / RDBMS / Admin] $ sqlplus / As sysdba
SQL * Plus : Release 10.2 . 0.4 . 0   - Production on Sun Jan 27   20 : 47 : 38   2008
Copyright (c) 1982 ,   2007 , Oracle . All Rights Reserved .
Connected :
Oracle Database 10g Enterprise Edition Release 10.2 . 0.4 . 0   - 64bit Production
With the partitioning , Real Application Clusters , OLAP , Data Mining
And real application testing options
SQL >   @ Awrrpt
......
// Generate Reports based on Oracle prompts ......

Note: The report is generated under the $ ORACLE_HOME/rdbms/admin/directory.

 

2. Modify AWR's default settings

// It is collected once every 30 minutes, and the collected information is saved for three days.
SQL > Exec Dbms_workload_repository . Modify_snapshot_settings (Interval => 30 , Retention => 3 * 24 * 60 );

3. Disable Automatic AWR collection

SQL > Exec Dbms_workload_repository . Modify_snapshot_settings (Interval => 0 , Retention => 24 * 60 );

Note: AWR information collection is automatically enabled for 10 Gb by default, which has a slight impact on the system. To disable AWR information collection, you only need to set the interval parameter to 0. However, when interval is set to 0, AWR reports cannot be generated.

1. generate an AWR report

[Ractest @ Sun880 - 1   / U01 / App / Oracle / Orahome / RDBMS / Admin] $ cd $ ORACLE_HOME / RDBMS / Admin
[Ractest @ Sun880 - 1   / U01 / App / Oracle / Orahome / RDBMS / Admin] $ sqlplus / As sysdba
SQL * Plus : Release 10.2 . 0.4 . 0   - Production on Sun Jan 27   20 : 47 : 38   2008
Copyright (c) 1982 ,   2007 , Oracle . All Rights Reserved .
Connected :
Oracle Database 10g Enterprise Edition Release 10.2 . 0.4 . 0   - 64bit Production
With the partitioning , Real Application Clusters , OLAP , Data Mining
And real application testing options
SQL >   @ Awrrpt
......
// Generate Reports based on Oracle prompts ......

Note: The report is generated under the $ ORACLE_HOME/rdbms/admin/directory.

 

2. Modify AWR's default settings

// It is collected once every 30 minutes, and the collected information is saved for three days.
SQL > Exec Dbms_workload_repository . Modify_snapshot_settings (Interval => 30 , Retention => 3 * 24 * 60 );

3. Disable Automatic AWR collection

SQL > Exec Dbms_workload_repository . Modify_snapshot_settings (Interval => 0 , Retention => 24 * 60 );

Note: AWR information collection is automatically enabled for 10 Gb by default, which has a slight impact on the system. To disable AWR information collection, you only need to set the interval parameter to 0. However, when interval is set to 0, AWR reports cannot be generated.