Home > Oracle DBA > ALL About AWR reports.

ALL About AWR reports.

July 25, 2013

Verifying that AWR Has Been Installed

To verify that AWR has been installed: Enter the following command:
sqlplus system/<system password>

select snap_id, to_char(END_INTERVAL_TIME, ’DD-MON-YY HH24:MI’) from dba_hist_snapshot order by snap_id;

If AWR has been set up, you will see output similar to the following:

SNAP_ID TO_CHAR (END_INT
——– —————-
7393 29-FEB-07 16:00
7394 29-FEB-07 17:00
178 rows selected.
SQL> exit

If AWR has not been installed, you will see output similar to:
ERROR at line 2:
ORA-00942: table or view does not exist

Advertisements
Categories: Oracle DBA
%d bloggers like this: