oracle9i awrrpt,Oracle AWR 介绍及报告分析(1) final

. 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