Archive

Posts Tagged ‘Performance measurement’

How to generate AWR report if no access to Enterprise Manager

October 26, 2011 Leave a comment

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

Categories: Oracle Tags: