Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 11.1 Latches

In Oracle 10.2 there were 382 latches; in Oracle 11.1 there are 496 latches

The following table shows the 146 latches that were added in Oracle 11.1:

Name
ASM attribute latch
ASM network SGA latch
ASM scan context latch
ASM Volume process latch
ASM Volume SGA latch
block corruption recovery state
Block new check invariant rollback SCN latch
change notification client cache latch
connection pool sga data lock
corrupted undo seg lock
cp cmon array latch
cp cmon/server latch
cp cso latch
cp holder latch
cp pool array latch
cp pool latch
cp server array latch
cp server hash latch
cp sga latch
cv apply list lock
cv free list lock
dbkea msgq latch
deferred cleanup latch
DML lock allocation
DMON Network Error List Latch
domain validation update latch
EMON slave state object latch
Event Group Locks
fifth spare latch
file deallocation SCN cache
File IO Stats segmented array latch
File State Object Pool Parent Latch
flashback archiver latch
flashback marker cache
fourth spare latch
gc checkpoint
gc element
ges value block free list
internal temp table object number allocation latch
io pool granule list
io pool granule metadata list
IPC stats buffer allocation latch
JOX JIT latch
JS broadcast LW Job latch
k2q global data latch
k2q lock allocation
kdlx hb parent latch
KFK SGA Libload latch
kgb latch
kgb parent
KGNFS-NFS:SHM structure
KGNFS-NFS:SVR LIST
kkae edition name cache
KKCN grp data latch
KKCN grp reg latch
KKCN reg stat latch
kokc descriptor allocation latch
kpon job info latch
kpplsSyncStateListSga: lock
KQF runtime table column alloc
ksbxic instance latch
kse signature
ksim membership request latch
kspoltest latch
kss move lock
kssmov protection latch
ksv allocation latch
ksv class latch
ksv instance latch
ksv msg queue latch
ksv remote inst ops
ksxp shared latch
ksz_so allocation latch
KWQS pqsubs latch
KWQS pqueue ctx latch
lob segment dispenser latch
lob segment hash table latch
lob segment query latch
Locator state objects pool parent latch
lock DBA buffer during media recovery
lock new checkpoint scn during media recovery
MinActiveScn Latch
Minimum flashback SCN latch
Mutex
Mutex Stats
name-service memory recovery
NSV command ID generation latch
NSV creation/termination latch
ODM-NFS:Global file structure
OFS SGA Latch
parameter table management
PC and Classifier lists for WLM
peshm
pesom_free_list
pesom_hash_node
pesom_heap_alloc
qmn task context latch
qmne Export Table Latch
qmtmrcsg_init
readable standby influx scn
readable standby metadata redo cache
readredo stats and histogram
Real-time plan statistics latch
reid allocation latch
resmgr:active threads
Result Cache: Latch
Result Cache: SO Latch
Role grants to users
Role graph
Sage HT Latch
Security Class Hashtable
SGA blob lock
SGA blob parent
SGA bucket locks
SGA heap creation lock
SGA heap locks
SGA kcrrlac latch
SGA pool creation lock
SGA pool locks
SGA slab metadata lock
SGA table lock
shared pool sim alloc
shared pool simulator
space background SGA latch
space background state object latch
space background task latch
tablespace key chain
test excl. non-parent l0
test excl. non-parent lmax
test excl. parent l0
test excl. parent2 l0
test shared non-parent l0
third spare latch
virtual circuit holder
WCR: kecu cas mem
WCR: ticker cache
Write State Object Pool Parent Latch
XDB Byte Lock SGA Latch
XDB Config-1
XDB Config-2
XDB Config-3
XDB Mcache SGA Latch
XDB NFS Security Latch
XDB NFS Stateful SGA Latch
XDB PL/SQL Support
XML DB Events

The following table shows the 32 latches that were removed in Oracle 11.1:

Name
alert memory latch
DMON Process Context Latch
event group latch
gcs drop object freelist
internal temp table object number allocation latc
JS event notify broadcast latch
KCL gc element parent latch
KFK SGA context latch
KGX
KGX_diag
ksv instance
ksxp tid allocation
library cache
library cache hash chains
library cache lock
library cache lock allocation
library cache pin
library cache pin allocation
Memory Management Parameter Latch
msg queue
numer of job queues for server notfn
parameter table allocation management
peplm
resmgr:actses active list
resmgr:gang list
resmgr:queued list
resmgr:runnable lists
resmgr:running actses count
RSM SQL latch
slave class
slave class create
XDB Config