Latch Contention Info
warning 99
alert 97
Level Name Gets Misses Hitratio
AQ Propagation Scheduling Proc Table 0 0 100
AQ Propagation Scheduling System Load 0 0 100
Active checkpoint queue latch 5534 0 100
Checkpoint queue latch 21972 0 100
Direct I/O Adaptor 2 0 100
GDS latch 0 0 100
KCL freelist latch 0 0 100
KCL instance latch 0 0 100
KCL lock element parent latch 0 0 100
KCL name table latch 0 0 100
KSFQ 0 0 100
NLS data objects 1 0 100
Token Manager 118 0 100
X$KSFQP 0 0 100
address list 1 0 100
archive control 0 0 100
archive process latch 0 0 100
batching SCNs 0 0 100
begin backup scn array 0 0 100
cache buffer handles 20 0 100
cache buffers chains 1675656 1 99.9999403218799
cache buffers lru chain 543587 0 100
cache protection latch 0 0 100
cached attr list 0 0 100
cas latch 0 0 100
channel handle pool latch 40 0 100
channel operations parent latch 118 0 100
constraint object allocation 0 0 100
cost function 0 0 100
device information 0 0 100
direct msg latch 0 0 100
dispatcher configuration 0 0 100
dlm ast latch 0 0 100
dlm cr bast queue latch 0 0 100
dlm cr info freelist latch 0 0 100
dlm deadlock list 0 0 100
dlm domain lock latch 0 0 100
dlm domain lock table latch 0 0 100
dlm domain table latch 0 0 100
dlm group lock latch 0 0 100
dlm group lock table latch 0 0 100
dlm group table freelist 0 0 100
dlm lock table freelist 0 0 100
dlm process hash list 0 0 100
dlm process table freelist 0 0 100
dlm recovery domain record latch 0 0 100
dlm recovery domain table latch 0 0 100
dlm resource hash list 0 0 100
dlm resource scan list 0 0 100
dlm resource table freelist 0 0 100
dlm shared communication latch 0 0 100
dlm statistic table latch 0 0 100
dlm synchronous data latch 0 0 100
dlm timeout list 0 0 100
dml lock allocation 5114 0 100
done queue latch 0 0 100
enqueue hash chains 12221 0 100
enqueues 19570 0 100
error message lists 0 0 100
event group latch 32 0 100
file number translation table 6 0 100
first spare latch 0 0 100
fixed table rows for x$hs_session 0 0 100
global transaction 0 0 100
global tx free list 0 0 100
global tx hash mapping 0 0 100
hash table modification latch 0 0 100
i/o slave adaptor 0 0 100
intra txn parallel recovery 0 0 100
job_queue_processes parameter latch 257 0 100
ksfv messages 0 0 100
ksfv subheap 0 0 100
ktm global data 51 0 100
kwqit: protect wakeup time 0 0 100
large memory latch 0 0 100
latch wait list 0 0 100
library cache 75001 0 100
library cache load lock 452 0 100
list of block allocation 1814 0 100
loader state object freelist 250 0 100
longop free list 22 0 100
message pool operations parent latch 3 0 100
messages 38678 0 100
mostly latch-free SCN 0 0 100
msg queue latch 0 0 100
multiblock read objects 70874 0 100
name-service entry 0 0 100
name-service memory objects 0 0 100
name-service namespace bucket 0 0 100
name-service pending queue 0 0 100
name-service request 0 0 100
name-service request queue 0 0 100
ncodef allocation latch 257 0 100
parallel query alloc buffer 0 0 100
parallel query stats 0 0 100
parallel txn reco latch 0 0 100
presentation list 0 0 100
process allocation 32 0 100
process group creation 546 0 100
process queue 0 0 100
process queue reference 0 0 100
query server freelists 0 0 100
query server process 0 0 100
redo allocation 9205 0 100
redo copy 12 0 100
redo writing 24791 1 99.9959662780848
resmgr group change latch 0 0 100
resmgr:actses active list 0 0 100
resmgr:actses change group 0 0 100
resmgr:actses change state 0 0 100
resmgr:gang list 0 0 100
resmgr:method mem alloc latch 0 0 100
resmgr:plan CPU method 0 0 100
resmgr:queued list 0 0 100
resmgr:resource group CPU method 0 0 100
resmgr:runnable lists 0 0 100
resmgr:running actses count 0 0 100
resmgr:schema config 0 0 100
resmgr:session queuing 0 0 100
row cache objects 14168 0 100
second spare latch 0 0 100
sequence cache 76 0 100
session allocation 7246 0 100
session idle bit 134810 0 100
session queue latch 0 0 100
session switching 257 0 100
session timer 0 0 100
shared java pool 0 0 100
shared pool 18173 0 100
sort extent pool 207 0 100
temp lob duration state obj allocation 0 0 100
temp table ageout allocation latch 0 0 100
temporary table state object allocation 0 0 100
trace latch 0 0 100
transaction allocation 5415 0 100
transaction branch allocation 257 0 100
undo global data 8005 0 100
user lock 92 0 100
vecio buf des 0 0 100
virtual circuit buffers 0 0 100
virtual circuit queues 0 0 100
virtual circuits 0 0 100
Info for BAMBARA Database last updated 07/07/2000 03:23