Home > Oracle > How to generate AWR report if no access to Enterprise Manager

How to generate AWR report if no access to Enterprise Manager

Here is how you can generate AWR report through backend if you have no access to Enterprise Manager or browser.

Login to DB server.
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
@awrrpt.sql

Example:
____________________________

$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 – Production on Wed Oct 26 16:00:29 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, Data Mining and Real Application Testing options

SQL> @awrrpt

Current Instance
~~~~~~~~~~~~~~~~

DB Id DB Name Inst Num Instance
———– ———— ——– ————
793887637DEVDB1 1 DEVDB1

Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter ‘html’ for an HTML report, or ‘text’ for plain text
Defaults to ‘html’
Enter value for report_type: text

Type Specified: text

Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DB Id Inst Num DB Name Instance Host
———— ——– ———— ———— ————
* 793887637 1 DEVDB1 DEVDB1 usamt75uxpro
d01

Using 793887637for database Id
Using 1 for instance number

Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing without
specifying a number lists all completed snapshots.

Enter value for num_days: 1

Listing the last day’s Completed Snapshots

Snap
Instance DB Name Snap Id Snap Started Level
———— ———— ——— —————— —–
DEVDB1 DEVDB1 24778 26 Oct 2011 00:00 1
24779 26 Oct 2011 01:00 1
24780 26 Oct 2011 02:00 1
24781 26 Oct 2011 03:01 1
24782 26 Oct 2011 04:00 1
24783 26 Oct 2011 05:00 1
24784 26 Oct 2011 06:00 1
24785 26 Oct 2011 07:00 1
24786 26 Oct 2011 08:00 1
24787 26 Oct 2011 09:00 1
24788 26 Oct 2011 10:00 1
24789 26 Oct 2011 11:00 1
24790 26 Oct 2011 12:00 1
24791 26 Oct 2011 13:00 1
24792 26 Oct 2011 14:00 1
24793 26 Oct 2011 15:00 1
24794 26 Oct 2011 16:00 1

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 24788
Begin Snapshot Id specified: 24788

Enter value for end_snap: 24789
End Snapshot Id specified: 24789

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_24788_24789.txt. To use this name,
press to continue, otherwise enter an alternative.

Enter value for report_name: oct_26_2011_10am_to_11am

Advertisements
Categories: Oracle Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: