The AWR (Automatic Workload Repository) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views.
> Please run your required process an hour before running the AWR report.
1. Login into the SQL Plus.
2. Run the following command to generate the report.
SQL > @$ORACLE_HOME/rdbms/admin/awrrpt.sql
3. You will be prompted to enter the report type. Enter report TYPE as HTML.
4. Next, you will be prompted for the number of days you want to see the snapshots. Enter a value of "1" to see snapshots created in today.
NOTE: By default, the Oracle Database generates snapshots once every hour and retains the statistics in the workload repository for 7 days.
5. After the list displays, you are prompted for the beginning and ending snapshot ID for
the workload repository report. Enter a starting ID that corresponds with the approximate time that your concurrent process was started. Enter the ending ID that corresponds with the approximate time that your process finished.
6. Next, accept the default report name or enter a the name as required.
7. Report will be created in the same directory :- $ORACLE_HOME/rdbms/admin
Ref: Metalink Doc ID 748642.1
> Please run your required process an hour before running the AWR report.
1. Login into the SQL Plus.
2. Run the following command to generate the report.
SQL > @$ORACLE_HOME/rdbms/admin/awrrpt.sql
3. You will be prompted to enter the report type. Enter report TYPE as HTML.
4. Next, you will be prompted for the number of days you want to see the snapshots. Enter a value of "1" to see snapshots created in today.
NOTE: By default, the Oracle Database generates snapshots once every hour and retains the statistics in the workload repository for 7 days.
5. After the list displays, you are prompted for the beginning and ending snapshot ID for
the workload repository report. Enter a starting ID that corresponds with the approximate time that your concurrent process was started. Enter the ending ID that corresponds with the approximate time that your process finished.
6. Next, accept the default report name or enter a the name as required.
7. Report will be created in the same directory :- $ORACLE_HOME/rdbms/admin
Ref: Metalink Doc ID 748642.1
No comments:
Post a Comment