. AWR基本操作
ITPUB个人空间l;@(WY.[NF1Z]$K
C:\>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 5月 25 08:20:25 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
;vM'a ~n[#Rr*x0连接到:
,i;_,UWo7]0Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
I+z&u X$\TYt0With the Partitioning, OLAP and Data Mining Scoring Engine options
SQL> @D:\oracle\product\10.2.0\db_2\RDBMS\ADMIN\awrrpt.sql
Current Instance
.nrP VLx_0~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num InstanceITPUB个人空间5Z&E*Jz'D:X
----------- ------------ -------- ------------
V] f/?6X$]&`iD0 3556425887 TEST01 1 test01
u'd+Y%VQo!Y0Specify the Report TypeITPUB个人空间 Qq1b^B
~~~~~~~~~~~~~~~~~~~~~~~ITPUB个人空间&r4}c*XZ\
Would you like an HTML report, or a plain text report?ITPUB个人空间/bX/m9{B4CG
Enter 'html' for an HTML report, or 'text' for plain textITPUB个人空间1u]o!{V#j
Defaults to 'html'
4Ru5iU|'N0输入 report_type 的值:
Type Specified: html
mw.{ B5@]x1h4]!J0Instances in this Workload Repository schemaITPUB个人空间]^ l\$t)c
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance HostITPUB个人空间| s1Ju&s|?(kK
------------ -------- ------------ ------------ ------------ITPUB个人空间;Gk]Z-p1K2z0Yw
* 3556425887 1 TEST01 test01 PCE-TSG-036
Using 3556425887 for database IdITPUB个人空间Y"B0c({7E
Using 1 for instance number
ITPUB个人空间O[!T%hr0g6X*C
Specify the number of days of snapshots to choose fromITPUB个人空间? M(K4~7q2]"{b
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
&n)V o;m'lS#N[l0Entering the number of days (n) will result in the most recentITPUB个人空间,]:ls+P I-V] ddVX#O
(n) days of snapshots being listed. Pressing without
,S-WEF6m|0specifying a number lists all completed snapshots.
8v/hxW-AiqEQ0输入 num_days 的值: 2
Listing the last 2 days of Completed Snapshots
SnapITPUB个人空间 @'T9O;g@.^
Instance DB Name Snap Id Snap Started LevelITPUB个人空间,y4l,X A2\G
------------ ------------ --------- ------------------ -----
7tDWW!w7`7t.BW0test01 TEST01 214 24 5月 2011 07:53 1
@'i Y;B.a5Y7Y0 215 24 5月 2011 09:00 1
q.nq5fg5B.T L0 216 24 5月 2011 10:01 1
#V-HSb/PI.d4C0 217 24 5月 2011 11:00 1
;bZxu$a$W?R0 218 24 5月 2011 12:00 1
@*i|Nep0]0 219 24 5月 2011 13:01 1ITPUB个人空间|,bU6d{/dx
220 24 5月 2011 14:00 1ITPUB个人空间3o[j ` F\%a
221 24 5月 2011 15:00 1
l7Dn/[ N"j0 222 24 5月 2011 16:00 1
"q-d\ kY L1W0 223 24 5月 2011 17:00 1
224 25 5月 2011 07:51 1
#Wd/Un-X5E-hK0Specify the Begin and End Snapshot IdsITPUB个人空间ny2Yd3QP'_)a(B4q:a
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
k2p P\5i0输入 begin_snap 的值: 223ITPUB个人空间;y7J ] z8ZNT
Begin Snapshot Id specified: 223
输入 end_snap 的值: 224
HC{2R'Q B I[0End Snapshot Id specified: 224
:rNOWFP$?U0declare
y T;y~lHR.nS(bI0*ITPUB个人空间Y1j%j:qo} S\J
第 1 行出现错误:ITPUB个人空间 v.`b0d] I&Dw;vJ
ORA-20200: The instance was shutdown between snapshots 223 and 224ITPUB个人空间PH WU-^*V3O
ORA-06512: 在 line 42
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
g(k4RN!^TFSH0With the Partitioning, OLAP and Data Mining Scoring Engine options 断开
再来一次:
Specify the Begin and End Snapshot IdsITPUB个人空间)v"Ps8J:{&z
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
!]5kW6LCj0输入 begin_snap 的值: 214ITPUB个人空间i o-b9u#^(_h.w&q
Begin Snapshot Id specified: 214
输入 end_snap 的值: 215
7]'{T;cO)K6JU\0End Snapshot Id specified: 215
ITPUB个人空间bF ^k)Fi:?'}{
随后输入要生成的report名称 ....
......
ITPUB个人空间q8v ZdM9aC7|M+b,g]
9K)\)pu} s0End of Report
Ks/y \F0