Scribd
Upload
44 views2 pages

Purpose Scope Details Gathering An AWR Report For A Performance Issue References

Uploaded by

SuvashreePradhan

This document outlines the steps to generate an AWR report to collect diagnostic information for performance issues. It provides details on granting privileges to users to generate AWR snapshots and submit ADDM recommendation jobs. The document explains how to run the AWR report generation script and select snapshot IDs and report format and name.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt

Purpose Scope Details Gathering An AWR Report For A Performance Issue References

Uploaded by

SuvashreePradhan
44 views2 pages
This document outlines the steps to generate an AWR report to collect diagnostic information for performance issues. It provides details on granting privileges to users to generate AWR snapshots and submit ADDM recommendation jobs. The document explains how to run the AWR report generation script and select snapshot IDs and report format and name.

Original Description:

awr report oracle

Original Title

Awr Report

Copyright

© © All Rights Reserved

Available Formats

DOCX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

This document outlines the steps to generate an AWR report to collect diagnostic information for performance issues. It provides details on granting privileges to users to generate AWR snapshots and submit ADDM recommendation jobs. The document explains how to run the AWR report generation script and select snapshot IDs and report format and name.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
44 views2 pages

Purpose Scope Details Gathering An AWR Report For A Performance Issue References

Uploaded by

SuvashreePradhan
This document outlines the steps to generate an AWR report to collect diagnostic information for performance issues. It provides details on granting privileges to users to generate AWR snapshots and submit ADDM recommendation jobs. The document explains how to run the AWR report generation script and select snapshot IDs and report format and name.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1/ 2

In this Document

Purpose
Scope
Details
Gathering an AWR report for a Performance Issue
References

APPLIES TO:

Oracle Database - Enterprise Edition - Version 6.0.0.0 and later


Information in this document applies to any platform.

PURPOSE

This document outlines the steps requires to generate AWR reports in order to
collect standard diagnostic information for Performance issues. This document was
created as part of the standard Service Request Diagnostic Collection (SRDC)
information.

SCOPE

For Support Analyst and DBA's

DETAILS

Gathering an AWR report for a Performance Issue

To gather an AWR report using the AWR report generation script:


$ORACLE_HOME/rdbms/admin/awrrpt.sql. As with ADDM, you can run an AWR
report as any user as long as they have the following roles and privileges:

 ADVISOR , SELECT_CATALOG_ROLE and EXECUTE ON


dbms_workload_repository .

For example, to allow the SCOTT user to both generate AWR snapshots and submit
ADDM recommendation jobs, the user will need to be granted the following (you
may skip this if you have already granted the privileges for the ADDM section
above):

# sqlplus / as sysdba
GRANT ADVISOR TO scott;
GRANT SELECT_CATALOG_ROLE TO scott;
GRANT EXECUTE ON dbms_workload_repository TO scott;
Once this is done you can generate the report by changing to
$ORACLE_HOME/rdbms/admin/ , logging in and executing the awrrpt.sql script:

# cd $ORACLE_HOME/rdbms/admin/
# sqlplus SCOTT/TIGER
SQL> START awrrpt.sql

The report will prompt whether you want HTML or TXT (choose HTML), Begin and
End Snapshot Ids and a report name (if you do not wish to select the default). By
default the report is written to the current directory and will be called :
awrrpt_1_BEGIN_SNAP_END_SNAP.txt for example awrrpt_1_1531_1532.html

The report will output the location once it has completed.

NOTE: If you do not have permissions on the current folder, the report will not be
produced and you will receive a message similar to the following:
SP2-0606: Cannot create SPOOL file "awrrpt_1_1531_1532.html"

You might also like