SQL> conn / as sysdba

Connected.

SQL>exec dbms_workload_repository.create_snapshot;

PL/SQL procedure successfully completed.

SQL>

SQL> conn / as sysdba

Connected.

SQL>exec dbms_workload_repository.create_snapshot;

PL/SQL procedure successfully completed.

SQL>

SQL>@ ?/rdbms/admin/awrrpt.sql【?会被解析为$ORACLE_HOME】

Current Instance

~~~~~~~~~~~~~~~~

  DB Id   DB Name     Inst Num Instance

----------- ------------ -------- ------------

 588460999 PTLDB              1 ptldb

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:【这里直接回车，输出默认的HTML文件】

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 <return> without

specifying a number lists all completed snapshots.

Enter value for num_days:1【系统列出1天内的报告列表】

Enter value for num_days: 1

Listing the last day's Completed Snapshots

                                                       Snap

Instance    DB Name       Snap Id   Snap Started   Level

------------ ------------ --------- ------------------ -----

ptldb       PTLDB            7236 28 Dec 2010 00:00     1

….

                              7258 28 Dec 2010 21:25     1

                              7259 28 Dec 2010 21:25     1

Specify the Begin and End Snapshot Ids

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Enter value for begin_snap:7258【输入起始的快照，性能测试之前产生的】

Enter value for end_snap:7259【输入结束的快照，性能测试之后产生的】

Specify the Report Name

~~~~~~~~~~~~~~~~~~~~~~~

The default report file name is awrrpt_1_7258_7259.html. To use this name,

press <return> to continue, otherwise enter an alternative.

Enter value for report_name:/home/oracle/awrrpt_1_7258_7259.html【输入报告文件名】

<p />

End of Report

</body></html>

Report written to /home/oracle/awrrpt_1_7258_7259.html

SQL>