Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.1 Latches

In Oracle 9.2 there were 241 latches; in Oracle 10.1 there are 348 latches

The following table shows the 126 latches that were added in Oracle 10.1:

Name
active service list
alert memory latch
ASM allocation
ASM db client latch
ASM file allocation latch
ASM file locked extent latch
ASM network background latch
buffer pin latch
bufq statistics
business card
change tracking consistent SCN
change tracking optimization SCN
change tracking state change latch
client/application info
compile environment latch
cursor bind value capture
database property service latch
datapump attach fixed tables latch
datapump job fixed tables latch
dispatcher info
enqueue sob latch
file cache latch
flashback allocation
flashback copy
flashback FBA barrier
flashback hint SCN barrier
flashback mapping
flashback SCN barrier
flashback sync request
foreground creation
gcs commit scn state
gcs domain validate latch
gcs resource validate list
generalized trace enabling latch
global KZLD latch for mem in SGA
hint flashback FBA barrier
In memory undo latch
internal temp table object number allocation latc
job_queue_processes free list latch
JS broadcast add buf latch
JS broadcast autostart latch
JS broadcast drop buf latch
JS broadcast kill buf latch
JS broadcast load blnc latch
JS mem alloc latch
JS queue access latch
JS queue state obj latch
JS slv state obj latch
KFA SGA latch
KFC FX Hash Latch
KFC Hash Latch
KFC LRU latch
KFC SGA latch
KFCL BX Freelist
KFCL Instance Latch
KFCL LE Freelist
KFK SGA context latch
KFM allocation
KFMD SGA
KFR redo allocation latch
KMG MMAN ready and startup request latch
KMG resize request state object freelist
krbmrosl
ksuosstats global area
ksupkttest latch
ksv instance
KTF sga enqueue
kupp process latch
kwqbcco:cco
kwqbsgn:msghdr
kwqbsn:qsga
kwqbsn:qxl
kwqi:kchunk latch
KWQMN job cache list latch
KWQMN job instance list latch
library cache hash chains
library cache lock
library cache lock allocation
logical standby view
logminer context allocation
logminer work area
media recovery process out of buffers
Memory Management Latch
Memory Management Parameter Latch
Memory Queue
Memory Queue Subscriber
MQL Tracking Latch
msg queue
object queue header heap
object queue header operation
OLS label cache
OSM map headers
OSM map load waiting list
OSM map operation freelist
OSM map operation hash table
OSM rollback operations
parameter table allocation management
pass worker exception to master
peplm
ping redo on-disk SCN
PL/SQL warning settings
Policy Hash Table Latch
Policy Refresh Latch
qmn state object latch
qmn task queue latch
QOL Name Generation Latch
Real time apply boundary
recovery domain freelist
recovery domain hash list
reservation so alloc latch
Reserved Space Latch
resmgr:free threads list
resmgr:incr/decr stats
rules engine statistics
server alert latch
Shared B-Tree
shared server info
shrink stat allocation latch
slave class
slave class create
spilled notification count
statistics aggregation
Streams Generic
SWRF Alerted Metric Element list
threshold alerts latch
TXN SGA

The following table shows the 19 latches that were removed in Oracle 10.1:

Name
browsers latch
bufq subscriber channel
comparison bit cache
dequeue sob latch
Direct I/O Adaptor
dynamic channels context latch
enqueue buffered messages latch
ges group parent
internal temp table object number allocation latch
KCL bast context freelist latch
KCL freelist parent latch
KCL name table parent latch
latch for background adjusted parameters
non-pers queues instances
row cache enqueue latch
shared java pool
spilled msgs queues list latch
TLCR context
TLCR meta context