|
在statspack report中,在enqueue 部分,显示的队列enqueue是两个大写字符,即是euqueue的缩写,有时分析euqueue时,还要查手册;在awr report中,在enqueue 部分,不仅显示了缩写,还符带显示了euqueue的描述信息,使dba能够更容易看懂eneuque在等待什么,awr的用户体验比statspack好了很多。。。
statspack report: Avg Wt Eq Requests Succ Gets Failed Gets Waits Time (ms) -- ------------ ------------ ------- --------- ------------- TX 1,762,016 1,762,920 0 65,944 .21 CF 4,120 4,120 0 4 839.25 SQ 21,186 21,186 0 212 .27 awr report: Enqueue Type (Request Reason) Requests Succ Gets Failed ------------ ------------ ----------- ----------- ------------ CF-Controlfile Transaction 112,585 112,580 TC-Tablespace Checkpoint 24 24 UL-User-defined 130 130 TX-Transaction (row lock contention) 2 2 RO-Multiple Object Fast Reuse 666 666 FB-Format Block 19,586 19,586 SQ-Sequence Cache 493,776 493,776
|