Latch Sleep breakdown for DB: ORA8Instance: ora8Snaps: 16 -19
-> ordered by misses desc
Get
Spin &
Latch Name
RequestsMissesSleeps Sleeps 1->4
-------------------------- -------------- ----------- ----------- ------------
library cache
4,927,613 4,884 5,115 2/4653/225/4
/0
shared pool
4,104,940 2,317 2,318 0/2316/1/0/0
cache buffers chains 29,710,997 405 1,127 0/0/284/121/
0
row cache objects
7,020,118 105 105 0/105/0/0/0
library cache pin
2,264,457
88
88 0/88/0/0/0
library cache pin allocati1,580,915
58
58 0/58/0/0/0
session idle bit
1,702,683
42 109 0/0/33/9/0
row cache enqueue latch 6,917,078
33
33 0/33/0/0/0
session allocation
494,304
29
29 0/29/0/0/0
cache buffers lru chain 462,845
23
23 0/23/0/0/0
enqueues
339,471
15
15 0/15/0/0/0
redo allocation
231,303 9 9 0/9/0/0/0
enqueue hash chains
230,491 8 8 0/8/0/0/0
cache buffer handles
316,856 5 5 0/5/0/0/0
post/wait queue
25,117 4 4 0/4/0/0/0
multiblock read objects 108,692 3 3 0/3/0/0/0
hash table column usage la
1,011 2 4 0/0/2/0/0
archive process latch
291 1 1 0/1/0/0/0
child cursor hash table 384,563 1 1 0/1/0/0/0
simulator lru latch
4,566 1 1 0/1/0/0/0
dml lock allocation
57,305 1 1 0/1/0/0/0
客户那里报数据库性能有些问题,
从TOP EVENT的报告来看主要是LATCH出了问题,这里是LATCH的明细。主要集中在library cache,shared pool ,cache buffers chains 这三项,cache buffers chains我知道,但前两项主要是由于什么原因引起的,是shared pool不够吗,谢谢。
|