Level |
Name |
Gets |
Misses |
Hitratio |
|
AQ Propagation Scheduling Proc Table
|
0
|
0
|
100
|
|
AQ Propagation Scheduling System Load
|
0
|
0
|
100
|
|
ASM allocation
|
0
|
0
|
100
|
|
ASM db client latch
|
0
|
0
|
100
|
|
ASM file allocation latch
|
0
|
0
|
100
|
|
ASM file locked extent latch
|
0
|
0
|
100
|
|
ASM map headers
|
0
|
0
|
100
|
|
ASM map load waiting list
|
0
|
0
|
100
|
|
ASM map operation freelist
|
0
|
0
|
100
|
|
ASM map operation hash table
|
0
|
0
|
100
|
|
ASM network background latch
|
0
|
0
|
100
|
|
ASM rollback operations
|
0
|
0
|
100
|
|
AW SGA latch
|
0
|
0
|
100
|
|
AWR Alerted Metric Element list
|
2260
|
0
|
100
|
|
Bloom Filter SGA latch
|
0
|
0
|
100
|
|
Bloom filter list latch
|
0
|
0
|
100
|
|
Change Notification Hash table latch
|
0
|
0
|
100
|
|
Change Notification Latch
|
0
|
0
|
100
|
|
Consistent RBA
|
215
|
0
|
100
|
|
DMON Process Context Latch
|
0
|
0
|
100
|
|
DMON Work Queues Latch
|
0
|
0
|
100
|
|
FAL request queue
|
0
|
0
|
100
|
|
FAL subheap alocation
|
0
|
0
|
100
|
|
FIB s.o chain latch
|
24
|
0
|
100
|
|
FOB s.o list latch
|
87
|
0
|
100
|
|
Fast-Start Failover State Latch
|
0
|
0
|
100
|
|
In memory undo latch
|
1395
|
0
|
100
|
|
JOX SGA heap latch
|
0
|
0
|
100
|
|
JS Sh mem access
|
0
|
0
|
100
|
|
JS broadcast add buf latch
|
0
|
0
|
100
|
|
JS broadcast autostart latch
|
0
|
0
|
100
|
|
JS broadcast drop buf latch
|
0
|
0
|
100
|
|
JS broadcast kill buf latch
|
0
|
0
|
100
|
|
JS broadcast load blnc latch
|
0
|
0
|
100
|
|
JS event notify broadcast latch
|
0
|
0
|
100
|
|
JS mem alloc latch
|
54
|
0
|
100
|
|
JS queue access latch
|
54
|
0
|
100
|
|
JS queue state obj latch
|
22176
|
0
|
100
|
|
JS slv state obj latch
|
16
|
0
|
100
|
|
KCL gc element parent latch
|
0
|
0
|
100
|
|
KFA SGA latch
|
0
|
0
|
100
|
|
KFC FX Hash Latch
|
0
|
0
|
100
|
|
KFC Hash Latch
|
0
|
0
|
100
|
|
KFC LRU latch
|
0
|
0
|
100
|
|
KFC SGA latch
|
0
|
0
|
100
|
|
KFCL BX Freelist
|
0
|
0
|
100
|
|
KFCL Instance Latch
|
0
|
0
|
100
|
|
KFCL LE Freelist
|
0
|
0
|
100
|
|
KFK SGA context latch
|
0
|
0
|
100
|
|
KFM allocation
|
0
|
0
|
100
|
|
KFMD SGA
|
0
|
0
|
100
|
|
KFR redo allocation latch
|
0
|
0
|
100
|
|
KGX
|
0
|
0
|
100
|
|
KGX_diag
|
0
|
0
|
100
|
|
KJC destination ctx free list
|
0
|
0
|
100
|
|
KJC global post event buffer
|
0
|
0
|
100
|
|
KJC global resend message queue
|
0
|
0
|
100
|
|
KJC message pool free list
|
0
|
0
|
100
|
|
KJC receiver ctx free list
|
0
|
0
|
100
|
|
KJC receiver queue access list
|
0
|
0
|
100
|
|
KJC snd proxy ctx free list
|
0
|
0
|
100
|
|
KJC snd proxy queue access list
|
0
|
0
|
100
|
|
KJCT flow control latch
|
0
|
0
|
100
|
|
KJCT receiver queue access
|
0
|
0
|
100
|
|
KMG MMAN ready and startup request latch
|
1031
|
0
|
100
|
|
KMG resize request state object freelist
|
0
|
0
|
100
|
|
KPON ksr channel latch
|
0
|
0
|
100
|
|
KSFQ
|
0
|
0
|
100
|
|
KSXR large replies
|
0
|
0
|
100
|
|
KTF sga latch
|
7
|
0
|
100
|
|
KWQMN job cache list latch
|
13
|
0
|
100
|
|
KWQMN to-be-Stopped Buffer list Latch
|
0
|
0
|
100
|
|
KWQP Prop Status
|
0
|
0
|
100
|
|
LGWR NS Write
|
0
|
0
|
100
|
|
MQL Tracking Latch
|
0
|
0
|
100
|
|
Managed Standby Recovery State
|
0
|
0
|
100
|
|
Media rcv so alloc latch
|
0
|
0
|
100
|
|
Memory Management Latch
|
15
|
0
|
100
|
|
Memory Management Parameter Latch
|
0
|
0
|
100
|
|
Memory Queue
|
0
|
0
|
100
|
|
Memory Queue Message Subscriber #1
|
0
|
0
|
100
|
|
Memory Queue Message Subscriber #2
|
0
|
0
|
100
|
|
Memory Queue Message Subscriber #3
|
0
|
0
|
100
|
|
Memory Queue Message Subscriber #4
|
0
|
0
|
100
|
|
Memory Queue Subscriber
|
0
|
0
|
100
|
|
NLS data objects
|
2
|
0
|
100
|
|
OLS label cache
|
0
|
0
|
100
|
|
OS file lock latch
|
2
|
0
|
100
|
|
OS process
|
210
|
0
|
100
|
|
OS process allocation
|
1157
|
0
|
100
|
|
OS process: request allocation
|
45
|
0
|
100
|
|
PL/SQL warning settings
|
133
|
0
|
100
|
|
Policy Hash Table Latch
|
0
|
0
|
100
|
|
Policy Refresh Latch
|
0
|
0
|
100
|
|
QMT
|
0
|
0
|
100
|
|
QOL Name Generation Latch
|
0
|
0
|
100
|
|
RSM SQL latch
|
0
|
0
|
100
|
|
RSM process latch
|
0
|
0
|
100
|
|
Real time apply boundary
|
0
|
0
|
100
|
|
Request id generation latch
|
0
|
0
|
100
|
|
Reserved Space Latch
|
0
|
0
|
100
|
|
SGA IO buffer pool latch
|
1
|
0
|
100
|
|
SGA kcrrgap latch
|
0
|
0
|
100
|
|
SGA kcrrlatmscnl latch
|
0
|
0
|
100
|
|
SGA kcrrpinfo latch
|
0
|
0
|
100
|
|
SGA kcrrssncpl latch
|
0
|
0
|
100
|
|
SGA mapping latch
|
0
|
0
|
100
|
|
SQL memory manager latch
|
2
|
0
|
100
|
|
SQL memory manager workarea list latch
|
68967
|
0
|
100
|
|
STREAMS LCR
|
0
|
0
|
100
|
|
STREAMS Pool Advisor
|
0
|
0
|
100
|
|
Shared B-Tree
|
110
|
0
|
100
|
|
Streams Generic
|
0
|
0
|
100
|
|
TXN SGA
|
0
|
0
|
100
|
|
Testing
|
0
|
0
|
100
|
|
Token Manager
|
0
|
0
|
100
|
|
Transportable DB Context Latch
|
0
|
0
|
100
|
|
Undo Hint Latch
|
0
|
0
|
100
|
|
X$KSFQP
|
0
|
0
|
100
|
|
XDB Config
|
0
|
0
|
100
|
|
XDB unused session pool
|
0
|
0
|
100
|
|
XDB used session pool
|
0
|
0
|
100
|
|
active checkpoint queue latch
|
1049
|
0
|
100
|
|
active service list
|
6283
|
0
|
100
|
|
address list
|
4
|
0
|
100
|
|
alert log latch
|
0
|
0
|
100
|
|
alert memory latch
|
0
|
0
|
100
|
|
archive control
|
11
|
0
|
100
|
|
archive process latch
|
0
|
0
|
100
|
|
begin backup scn array
|
0
|
0
|
100
|
|
block media rcv so alloc latch
|
0
|
0
|
100
|
|
bq:time manger info latch
|
0
|
0
|
100
|
|
buffer pin latch
|
0
|
0
|
100
|
|
buffer pool
|
17
|
0
|
100
|
|
bufq statistics
|
0
|
0
|
100
|
|
business card
|
0
|
0
|
100
|
|
cache buffer handles
|
67
|
0
|
100
|
|
cache buffers chains
|
156473
|
0
|
100
|
|
cache buffers lru chain
|
7395
|
0
|
100
|
|
cache protection latch
|
0
|
0
|
100
|
|
cache table scan latch
|
68
|
0
|
100
|
|
cached attr list
|
0
|
0
|
100
|
|
cas latch
|
0
|
0
|
100
|
|
change tracking consistent SCN
|
0
|
0
|
100
|
|
change tracking optimization SCN
|
0
|
0
|
100
|
|
change tracking state change latch
|
0
|
0
|
100
|
|
channel anchor
|
1
|
0
|
100
|
|
channel handle pool latch
|
78
|
0
|
100
|
|
channel operations parent latch
|
14755
|
0
|
100
|
|
checkpoint queue latch
|
17679
|
0
|
100
|
|
client/application info
|
39
|
0
|
100
|
|
commit callback allocation
|
4
|
0
|
100
|
|
compile environment latch
|
79
|
0
|
100
|
|
constraint object allocation
|
0
|
0
|
100
|
|
cost function
|
0
|
0
|
100
|
|
database property service latch
|
0
|
0
|
100
|
|
datapump attach fixed tables latch
|
0
|
0
|
100
|
|
datapump job fixed tables latch
|
0
|
0
|
100
|
|
device information
|
0
|
0
|
100
|
|
dictionary lookup
|
0
|
0
|
100
|
|
direct msg latch
|
0
|
0
|
100
|
|
dispatcher info
|
0
|
0
|
100
|
|
dml lock allocation
|
828
|
0
|
100
|
|
done queue latch
|
0
|
0
|
100
|
|
dummy allocation
|
51
|
0
|
100
|
|
dynamic channels
|
0
|
0
|
100
|
|
end-point list
|
2
|
0
|
100
|
|
enqueue hash chains
|
54008
|
0
|
100
|
|
enqueue sob latch
|
0
|
0
|
100
|
|
enqueues
|
52124
|
0
|
100
|
|
error message lists
|
0
|
0
|
100
|
|
event group latch
|
33
|
0
|
100
|
|
event range base latch
|
0
|
0
|
100
|
|
file cache latch
|
77
|
0
|
100
|
|
file number translation table
|
5
|
0
|
100
|
|
first spare latch
|
0
|
0
|
100
|
|
fixed table rows for x$hs_session
|
0
|
0
|
100
|
|
flashback FBA barrier
|
0
|
0
|
100
|
|
flashback SCN barrier
|
0
|
0
|
100
|
|
flashback allocation
|
0
|
0
|
100
|
|
flashback copy
|
0
|
0
|
100
|
|
flashback hint SCN barrier
|
0
|
0
|
100
|
|
flashback mapping
|
0
|
0
|
100
|
|
flashback sync request
|
0
|
0
|
100
|
|
gcs commit scn state
|
0
|
0
|
100
|
|
gcs domain validate latch
|
0
|
0
|
100
|
|
gcs drop object freelist
|
0
|
0
|
100
|
|
gcs opaque info freelist
|
0
|
0
|
100
|
|
gcs partitioned table hash
|
0
|
0
|
100
|
|
gcs pcm hashed value bucket hash
|
0
|
0
|
100
|
|
gcs remaster request queue
|
0
|
0
|
100
|
|
gcs remastering latch
|
0
|
0
|
100
|
|
gcs resource freelist
|
0
|
0
|
100
|
|
gcs resource hash
|
0
|
0
|
100
|
|
gcs resource scan list
|
0
|
0
|
100
|
|
gcs resource validate list
|
0
|
0
|
100
|
|
gcs shadows freelist
|
0
|
0
|
100
|
|
generalized trace enabling latch
|
1
|
0
|
100
|
|
ges caches resource lists
|
0
|
0
|
100
|
|
ges deadlock list
|
0
|
0
|
100
|
|
ges domain table
|
0
|
0
|
100
|
|
ges enqueue table freelist
|
0
|
0
|
100
|
|
ges group table
|
0
|
0
|
100
|
|
ges process hash list
|
0
|
0
|
100
|
|
ges process parent latch
|
0
|
0
|
100
|
|
ges process table freelist
|
0
|
0
|
100
|
|
ges resource hash list
|
0
|
0
|
100
|
|
ges resource scan list
|
0
|
0
|
100
|
|
ges resource table freelist
|
0
|
0
|
100
|
|
ges s-lock bitvec freelist
|
0
|
0
|
100
|
|
ges statistic table
|
0
|
0
|
100
|
|
ges synchronous data
|
0
|
0
|
100
|
|
ges timeout list
|
0
|
0
|
100
|
|
global KZLD latch for mem in SGA
|
1
|
0
|
100
|
|
global ctx hash table latch
|
0
|
0
|
100
|
|
global hanganlyze operation
|
0
|
0
|
100
|
|
global tx hash mapping
|
0
|
0
|
100
|
|
granule operation
|
3
|
0
|
100
|
|
hash table column usage latch
|
321
|
0
|
100
|
|
hash table modification latch
|
75
|
0
|
100
|
|
hint flashback FBA barrier
|
0
|
0
|
100
|
|
hot latch diags
|
0
|
0
|
100
|
|
i/o slave adaptor
|
0
|
0
|
100
|
|
image handles of buffered messages latch
|
0
|
0
|
100
|
|
instance enqueue
|
1
|
0
|
100
|
|
instance information
|
0
|
0
|
100
|
|
internal temp table object number allocation latc
|
0
|
0
|
100
|
|
intra txn parallel recovery
|
0
|
0
|
100
|
|
job queue sob latch
|
0
|
0
|
100
|
|
job workq parent latch
|
0
|
0
|
100
|
|
job_queue_processes free list latch
|
3
|
0
|
100
|
|
job_queue_processes parameter latch
|
59
|
0
|
100
|
|
kks stats
|
1055
|
0
|
100
|
|
kmcptab latch
|
4
|
0
|
100
|
|
kmcpvec latch
|
0
|
0
|
100
|
|
kpon sga structure
|
0
|
0
|
100
|
|
krbmrosl
|
0
|
0
|
100
|
|
ksfv messages
|
0
|
0
|
100
|
|
ksfv subheap
|
0
|
0
|
100
|
|
ksir sga latch
|
0
|
0
|
100
|
|
ksuosstats global area
|
210
|
0
|
100
|
|
ksupkttest latch
|
0
|
0
|
100
|
|
ksv instance
|
2
|
0
|
100
|
|
ksxp tid allocation
|
0
|
0
|
100
|
|
ktm global data
|
13
|
0
|
100
|
|
kupp process latch
|
0
|
0
|
100
|
|
kwqbcco:cco
|
0
|
0
|
100
|
|
kwqbsgn:msghdr
|
0
|
0
|
100
|
|
kwqbsn:qsga
|
110
|
0
|
100
|
|
kwqbsn:qxl
|
0
|
0
|
100
|
|
kwqi:kchunk latch
|
0
|
0
|
100
|
|
lgwr LWN SCN
|
1206
|
0
|
100
|
|
library cache
|
77738
|
0
|
100
|
|
library cache hash chains
|
0
|
0
|
100
|
|
library cache load lock
|
2552
|
0
|
100
|
|
library cache lock
|
22337
|
0
|
100
|
|
library cache lock allocation
|
396
|
0
|
100
|
|
library cache pin
|
44377
|
0
|
100
|
|
library cache pin allocation
|
323
|
0
|
100
|
|
list of block allocation
|
31
|
0
|
100
|
|
loader state object freelist
|
48
|
0
|
100
|
|
logical standby cache
|
0
|
0
|
100
|
|
logical standby view
|
0
|
0
|
100
|
|
logminer context allocation
|
0
|
0
|
100
|
|
logminer work area
|
0
|
0
|
100
|
|
longop free list parent
|
0
|
0
|
100
|
|
managed standby latch
|
0
|
0
|
100
|
|
mapped buffers lru chain
|
0
|
0
|
100
|
|
media recovery process out of buffers
|
0
|
0
|
100
|
|
message enqueue sync latch
|
0
|
0
|
100
|
|
message pool operations parent latch
|
11
|
0
|
100
|
|
messages
|
20570
|
0
|
100
|
|
mostly latch-free SCN
|
1206
|
0
|
100
|
|
msg queue
|
0
|
0
|
100
|
|
msg queue latch
|
0
|
0
|
100
|
|
multiblock read objects
|
382
|
0
|
100
|
|
multiple dbwriter suspend
|
0
|
0
|
100
|
|
name-service entry
|
0
|
0
|
100
|
|
name-service memory objects
|
0
|
0
|
100
|
|
name-service namespace bucket
|
0
|
0
|
100
|
|
name-service namespace objects
|
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
|
52
|
0
|
100
|
|
numer of job queues for server notfn
|
0
|
0
|
100
|
|
object queue header heap
|
327
|
0
|
100
|
|
object queue header operation
|
7506
|
0
|
100
|
|
object stats modification
|
357
|
0
|
100
|
|
parallel query alloc buffer
|
400
|
0
|
100
|
|
parallel query stats
|
0
|
0
|
100
|
|
parallel recoverable recovery
|
0
|
0
|
100
|
|
parallel txn reco latch
|
0
|
0
|
100
|
|
parameter list
|
22
|
0
|
100
|
|
parameter table allocation management
|
23
|
0
|
100
|
|
pass worker exception to master
|
0
|
0
|
100
|
|
pebof_rrv
|
0
|
0
|
100
|
|
peplm
|
0
|
0
|
100
|
|
ping redo on-disk SCN
|
0
|
0
|
100
|
|
policy information
|
0
|
0
|
100
|
|
post/wait queue
|
29
|
0
|
100
|
|
presentation list
|
1
|
0
|
100
|
|
process
|
0
|
0
|
100
|
|
process allocation
|
45
|
0
|
100
|
|
process group creation
|
45
|
0
|
100
|
|
process queue
|
0
|
0
|
100
|
|
process queue reference
|
0
|
0
|
100
|
|
qm_init_sga
|
0
|
0
|
100
|
|
qmn state object latch
|
2
|
0
|
100
|
|
qmn task queue latch
|
442
|
0
|
100
|
|
query server freelists
|
0
|
0
|
100
|
|
query server process
|
0
|
0
|
100
|
|
queue sender's info. latch
|
0
|
0
|
100
|
|
queued dump request
|
0
|
0
|
100
|
|
recovery domain freelist
|
0
|
0
|
100
|
|
recovery domain hash list
|
0
|
0
|
100
|
|
redo allocation
|
4244
|
0
|
100
|
|
redo copy
|
10
|
0
|
100
|
|
redo on-disk SCN
|
0
|
0
|
100
|
|
redo writing
|
3740
|
0
|
100
|
|
reg$ timeout service time
|
1
|
0
|
100
|
|
reservation so alloc latch
|
0
|
0
|
100
|
|
resmgr group change latch
|
17
|
0
|
100
|
|
resmgr:actses active list
|
646
|
0
|
100
|
|
resmgr:actses change group
|
8
|
0
|
100
|
|
resmgr:actses change state
|
0
|
0
|
100
|
|
resmgr:free threads list
|
28
|
0
|
100
|
|
resmgr:gang list
|
0
|
0
|
100
|
|
resmgr:incr/decr stats
|
0
|
0
|
100
|
|
resmgr:method mem alloc latch
|
3
|
0
|
100
|
|
resmgr:plan CPU method
|
5
|
0
|
100
|
|
resmgr:queued list
|
0
|
0
|
100
|
|
resmgr:resource group CPU method
|
28
|
0
|
100
|
|
resmgr:runnable lists
|
0
|
0
|
100
|
|
resmgr:running actses count
|
0
|
0
|
100
|
|
resmgr:schema config
|
618
|
0
|
100
|
|
resmgr:session queuing
|
0
|
0
|
100
|
|
resmgr:vc list latch
|
0
|
0
|
100
|
|
resumable state object
|
0
|
0
|
100
|
|
rm cas latch
|
0
|
0
|
100
|
|
row cache objects
|
76314
|
0
|
100
|
|
rules engine aggregate statistics
|
3
|
0
|
100
|
|
rules engine evaluation context statistics
|
1
|
0
|
100
|
|
rules engine rule set statistics
|
10
|
0
|
100
|
|
rules engine rule statistics
|
3
|
0
|
100
|
|
second spare latch
|
0
|
0
|
100
|
|
segmented array pool
|
0
|
0
|
100
|
|
sequence cache
|
13
|
0
|
100
|
|
server alert latch
|
0
|
0
|
100
|
|
session allocation
|
233505
|
0
|
100
|
|
session idle bit
|
1149
|
0
|
100
|
|
session queue latch
|
0
|
0
|
100
|
|
session state list latch
|
77
|
0
|
100
|
|
session switching
|
52
|
0
|
100
|
|
session timer
|
1035
|
0
|
100
|
|
shared pool
|
62003
|
0
|
100
|
|
shared pool sim alloc
|
7
|
0
|
100
|
|
shared pool simulator
|
21591
|
0
|
100
|
|
shared server configuration
|
1
|
0
|
100
|
|
shared server info
|
0
|
0
|
100
|
|
shrink stat allocation latch
|
0
|
0
|
100
|
|
sim partition latch
|
0
|
0
|
100
|
|
simulator hash latch
|
6668
|
0
|
100
|
|
simulator lru latch
|
5698
|
0
|
100
|
|
slave class
|
4
|
0
|
100
|
|
slave class create
|
18
|
0
|
100
|
|
sort extent pool
|
95
|
0
|
100
|
|
spilled messages latch
|
0
|
0
|
100
|
|
state object free list
|
2
|
0
|
100
|
|
statistics aggregation
|
119
|
0
|
100
|
|
temp lob duration state obj allocation
|
0
|
0
|
100
|
|
temporary table state object allocation
|
0
|
0
|
100
|
|
threshold alerts latch
|
131
|
0
|
100
|
|
trace latch
|
22
|
0
|
100
|
|
transaction allocation
|
39
|
0
|
100
|
|
transaction branch allocation
|
52
|
0
|
100
|
|
undo global data
|
1695
|
0
|
100
|
|
user lock
|
14
|
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
|
|
xscalc freelist
|
0
|
0
|
100
|
|
xssinfo freelist
|
0
|
0
|
100
|