*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