15-SEP-2007 14:14:29

TESTDB1

Latch Gets and Misses
Latch Name	Gets	Misses	Gets / Misses % (1)	Immediate Gets	Immediate Misses
process allocation	267	0	100.00	267	0
session switching	16,711	0	100.00	0	0
session idle bit	324,587	0	100.00	0	0
cache buffer handles	1,049	0	100.00	0	0
loader state object freelist	478	0	100.00	0	0
list of block allocation	29,256	0	100.00	0	0
sort extent pool	5,535	0	100.00	0	0
sequence cache	5,524	0	100.00	0	0
global tx free list	12	0	100.00	0	0
user lock	912	0	100.00	0	0
parallel query alloc buffer	1	0	100.00	0	0
process queue	1	0	100.00	0	0
query server freelists	1	0	100.00	0	0
NLS data objects	1	0	100.00	0	0
virtual circuits	720	0	100.00	0	0
virtual circuit queues	389,762	0	100.00	0	0
global tx hash mapping	76	0	100.00	0	0
global transaction	779,382	0	100.00	0	0
ktm global data	3,519	0	100.00	0	0
modify parameter values	35,403	0	100.00	0	0
multiblock read objects	246,914	1	100.00	7	0
undo global data	227,441	1	100.00	0	0
enqueue hash chains	508,099	3	100.00	0	0
transaction allocation	124,023	1	100.00	0	0
enqueues	360,483	3	100.00	0	0
dml lock allocation	68,337	1	100.00	0	0
system commit number	576,352	43	99.99	0	0
library cache load lock	10,120	1	99.99	0	0
cache buffers chains	75,938,994	8,283	99.99	175,558,705	294
shared pool	579,649	162	99.97	0	0
messages	2,500,072	752	99.97	0	0
library cache	3,590,374	1,258	99.96	18,517	10
cache buffers lru chain	262,445	99	99.96	2,137,007	491
row cache objects	3,503,659	1,518	99.96	1,826	5
virtual circuit buffers	3,159	2	99.94	0	0
redo allocation	1,409,423	986	99.93	0	0
session allocation	2,527,862	24,775	99.02	0	0
latch wait list	73	1	98.63	0	0
redo copy	19	13	31.58	810,708	75