Wednesday, August 4, 2010

create AWR report manually

*Create snapshot manually

exec DBMS_WORKLOAD_REPOSITORY.create_snapshot();

*Create AWR report

C:\>cd %ORACLE_HOME%
C:\>cd RDBMS
C:\>cd ADMIN
C:\>sqlplus / as sysdba
SQL>@awrrpt.sql
.
.
Enter value for report_type: html --or text
.
.
Enter value for num_days: --without specifying the number lists all completed snapshots.
.
.
Enter value for begin_snap:1
.
.
Enter value for end_snap:4
.
.
Enter value for report_name:awrrpt_1_4.html

No comments:

Post a Comment