数据库:Oracle 9.2.0.8 平台:HP-UX 11.110 r% ?1 ]7 J; i; \/ H7 S- C
在对客户的数据库进行健康搜检时发现:
7 e8 C5 z3 M& N5 [# l" r. b TOP 5期待事务中最高的是enqueue,其次是PX Deq: Execute Reply,这两个期待事务占了所有事务的65%以上。( o2 }# y' B: q0 `! D# X2 F
期待事务“enqueue”所占比例最高,一共期待了14,487s的时刻,但年夜后面的enqueue的统计信息来看,所统计的SQ enqueue和TX enqueue的期待时刻总和只有49s,其他统计的enqueue期待时刻根基为0s,所以还有其他未统计进statspack的enqueue存在,并占有了年夜高摒弃待时刻。
9 V" A9 @& n; B; X. Y6 n) l Top 5 Timed Events5 ? I: h, r$ }
~~~~~~~~~~~~~~~~~~ % Total4 g( g' [ ]- ~: b
Event Waits Time (s) Ela Time
- f$ s' q7 N8 d8 }9 Q -------------------------------------------- ------------ ----------- --------9 C* m2 r9 p; e) D
enqueue 6,339 14,487 44.02
# X# p4 a( C. g! Z PX Deq: Execute Reply 2,773 7,222 21.945 _$ C! x; p3 A- [, `. }) m1 p
CPU time 5,314 16.15
0 ~1 w0 S- p Y; O db file sequential read 982,418 3,574 10.86. L0 \0 h2 O2 E( l
row cache lock 80,167 691 2.10
; c* O) X. M7 Y- H* ] -------------------------------------------------------------
9 }* o/ t9 c$ ^9 A Enqueue activity for DB: IBSS Instance: ibss2 Snaps: 311 -3124 b# ~, ^9 S6 \# e' `1 }
-> Enqueue stats gathered prior to 9i should not be compared with 9i data
) i1 D' S. O ?2 q* U1 L% O -> ordered by Wait Time desc, Waits desc$ q% t; r9 T! C
Avg Wt Wait
5 C+ ^& s. M$ b3 J2 C- F Eq Requests Succ Gets Failed Gets Waits Time (ms) Time (s)
]# r! s9 @0 ^2 S5 w -- ------------ ------------ ----------- ----------- ------------- ------------
, U \3 \ j+ H SQ 5,589 5,589 0 206 181.50 37
- ^, Z# m( X2 o$ U TX 189,789 189,398 391 163 76.10 123 |( v' Q% d9 D4 E# v5 \
HW 1,601 1,599 2 423 .55 04 v$ ~# _: \7 t, g! N
US 1,949 1,949 0 339 .67 0# I1 i3 S% S1 F3 T: Q4 R; ]1 N
TM 912,315 912,254 56 155 .36 0
& D6 ?8 Q+ t" N. w5 W' z4 J1 K3 B TT 638 638 0 48 .92 0; p( K" T; u g
FB 39 39 0 26 .31 06 o5 A, S* K8 l8 j, b
TD 16 16 0 16 .50 0
5 D$ d4 `$ y n, Y, w4 I IR 10 10 0 8 .63 0/ K5 {+ t/ l: d0 _6 w: {% Z, y0 N
WL 8 6 2 6 .67 05 f6 G4 Y/ _6 y2 r9 A, [
DR 4 4 0 4 .50 03 h" e+ _% V! H" ^1 ^
RO 3 3 0 3 .67 0
3 C2 f; W, Z" g/ t2 J% ^5 U TA 26 26 0 2 .50 0 I9 c* s0 }9 K* @" H
DL 123 123 0 1 1.00 02 S8 `0 N1 T2 s: u/ A! R8 F
TS 6 6 0 5 .00 0
/ k2 k4 v1 J$ r3 ] CF 12,113 12,113 0 1 .00 0
, y( f8 L2 |! A: S$ |0 I1 V" S* G* C5 r4 o8 d' A8 U
------------------------------------------------------------- |