[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 断开