Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.2 Latches

In Oracle 10.1 there were 348 latches; in Oracle 10.2 there are 382 latches

The following table shows the 54 latches that were added in Oracle 10.2:

Name
ASM map headers
ASM map load waiting list
ASM map operation freelist
ASM map operation hash table
ASM rollback operations
AWR Alerted Metric Element list
Bloom filter list latch
Bloom Filter SGA latch
bq:time manger info latch
cache table scan latch
Change Notification Hash table latch
Change Notification Latch
Fast-Start Failover State Latch
gcs drop object freelist
gcs remastering latch
global hanganlyze operation
hot latch diags
job queue sob latch
JS event notify broadcast latch
JS Sh mem access
KGX
KGX_diag
KJC global resend message queue
kks stats
KPON ksr channel latch
kpon sga structure
ksir sga latch
KTF sga latch
KWQMN to-be-Stopped Buffer list Latch
Memory Queue Message Subscriber #1
Memory Queue Message Subscriber #2
Memory Queue Message Subscriber #3
Memory Queue Message Subscriber #4
OS process
OS process allocation
OS process: request allocation
pebof_rrv
queued dump request
reg$ timeout service time
rules engine aggregate statistics
rules engine evaluation context statistics
rules engine rule set statistics
rules engine rule statistics
session state list latch
SGA IO buffer pool latch
SGA kcrrgap latch
SGA kcrrlatmscnl latch
SGA kcrrpinfo latch
SGA kcrrssncpl latch
shared server configuration
STREAMS LCR
STREAMS Pool Advisor
Transportable DB Context Latch
Undo Hint Latch

The following table shows the 20 latches that were removed in Oracle 10.2:

Name
batching SCNs
child cursor hash table
cursor bind value capture
dispatcher configuration
foreground creation
gcs partitioned freelist
ges struct kjmddp
KCL instance latch
KTF sga enqueue
kwqit: protect wakeup time
KWQMN job instance list latch
latch wait list
OSM map headers
OSM map load waiting list
OSM map operation freelist
OSM map operation hash table
OSM rollback operations
rules engine statistics
spilled notification count
SWRF Alerted Metric Element list