Scribd
Upload
41 views7 pages

Generate An AWR Report in Oracle Database

The document outlines the steps to generate an AWR report in an Oracle Database using SQL*Plus. It includes logging in, executing the report script, selecting report format and snapshot range, and saving the report. Finally, it describes how to locate the HTML output file and transfer it to a local system for analysis.

Uploaded by

D Pavan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
41 views7 pages

Generate An AWR Report in Oracle Database

The document outlines the steps to generate an AWR report in an Oracle Database using SQL*Plus. It includes logging in, executing the report script, selecting report format and snapshot range, and saving the report. Finally, it describes how to locate the HTML output file and transfer it to a local system for analysis.

Uploaded by

D Pavan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

>>Generate AWR Report in Oracle Database<<

-----------------------------------------------
Step-1: Log in to the database.

Connect to the Oracle database using SQL*Plus as a privileged user,

Step-2: Run the AWR Report Script.

Execute the built-in AWR report generation script,


Step-3: Choose Report Format.

When prompted, select the format of the report,


Step-4: Select Number of Days of Snapshots.

Enter how many days of snapshots you want to display,

Step-5: Choose Snapshot Range.

From the list of available snapshots, select the Begin Snap ID and End Snap ID,

Step-6: Specify Report Name (Optional).

You can accept the default file name or specify a custom name for the output
report,
Step-7: Report Generation Complete.

The AWR report is now generated and saved in the current working directory on
the database server,

Step-8: Locate the HTML Output File.

Look for the output HTML file in the directory from where you executed the
script.
Step-9: Copy the Report to Your Local System.

Use an SCP tool (e.g., WinSCP, FileZilla, or command-line scp) to copy the AWR
HTML file from the Linux server to your local machine:
Step-10: Open the AWR Report.

Open the HTML report in a web browser for analysis and performance review.

You might also like