[oracle@linux ~]$ sqlplus / as sysdba @?/rdbms/admin/awrsqrpt.sql

SQL*Plus: Release 11.2.0.1.0 Production on 星期一 11月 4 17:29:10 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


连接到: 
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Current Instance
~~~~~~~~~~~~~~~~

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 1301772781 ORCL                1 orcl


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'
输入 report_type 的值:  html

Type Specified:  html


Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id     Inst Num DB Name      Instance     Host
------------ -------- ------------ ------------ ------------
* 1301772781        1 ORCL         orcl         linux

Using 1301772781 for database Id
Using          1 for instance number


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.


输入 num_days 的值:  1

Listing the last day's Completed Snapshots

                                                        Snap
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
orcl         ORCL               686 04 11月 2013 15:37     1
                                687 04 11月 2013 16:01     1
                                688 04 11月 2013 16:30     1
                                689 04 11月 2013 17:00     1



Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
输入 begin_snap 的值:  686
Begin Snapshot Id specified: 686

输入 end_snap 的值:  689
End   Snapshot Id specified: 689




Specify the SQL Id
~~~~~~~~~~~~~~~~~~
输入 sql_id 的值:  7nr1kb47kw04j
SQL ID specified:  7nr1kb47kw04j
declare
*
第 1 行出现错误:
ORA-20025: SQL ID 7nr1kb47kw04j does not exist for this database/instance
ORA-06512: 在 line 22


从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开

Logo

更多推荐