Oracle 10g AWR Report Generation Process

Oracle 10g AWR Report Generation Process

Oracle10g provides an AWR Report, which is automatically recorded every hour by default. This report is useful in both performance testing and real-time production environments, briefly describe the process of obtaining the AWR report:

You can use sys/Manager (as sysdba) to log on
SQL> Conn/As sysdba
SQL> var snap_id number
SQL> Exec: snap_id: = dbms_workload_repository.create_snapshot
SQL> Print snap_id
Snap_id
----------
182 // Number of the currently generated Snapshot
SQL> @? /Rdbms/admin/awrrpt. SQL
The rdbms/admin/awrrpt. SQL file is an Oracle system file. You can first find the specific directory location (find/-name RDBMS-type D) in securecrt)
If an error reading file is not found when executing the preceding statement in PLSQL, you can copy all the files in the rdbms/Admin directory to the local machine and then run awrrpt on the local machine. SQL file.
Enter the value of report_type: <enter is of the HTML type by default>
Enter the num_days value: 1 // view the number of days snapshots are saved for 7 days by default.
Enter the begin_snap value: 181 // The start Number of the snapshot.
Enter the value of end_snap: 182 // The end number of the snapshot
Enter the value of report_name: <enter uses the default file name>
Stopped spooling to D: \ uninstalled SOFTWARE \ PLSQL developer 7.0.1 Chinese Version \ PLSQL developer \ awrrpt_10918109182.html (path of snapshot file storage)
Report written to awrrpt_0000180000182.html
SQL> exit
Download awrrpt_000018.0182.html and open it.