Manually run SPREPORT, AWR, ADDM and ASH Oracle Reports

Manually run SPREPORT, AWR, ADDM and ASH Oracle Reports

1. Check the Oracle home location first

In Windows: Open the services.msc and right click on Oracle Services for know the location of Oracle Home.

E:\oracle\11.2.0\dbhome_1
In Linux: Open the oratab file and check the Oracle Home location
/u01/oracle/11.2.0/dbhome_1

2. Go to the location in CMD or terminal window:

Windows:
Cd E:\oracle\11.2.0.\dbhome_1\rdbms\admin
Linux:
cd /u01/oracle/11.2.0/dbhome_1/rdbms/admin

3. Connect with the database with sysdba privileges:

Sqlplus sys as sysdba

4. Run the following script to generate the AWR report

SQL>@awrrpt.sql;

5. Run the following to generate the ADDM Report:

SQL>@addmrpt.sql;

6. Run the following command to generate the ASH Report:

SQL>@ashrpt.sql

7. Run the following command for Statspack report:

SQL>@spreport.sql

Advertisements

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s