Latch, mutex and beyond

Shared latches by Oracle version

SQL> SELECT *
  FROM (SELECT name, version  FROM shared_latches
  ) PIVOT ( max('X') FOR (version) IN
       ('8.0.6.3.0','8.1.7.4.0','9.2.0.8.0', '10.1.0.5.0','10.2.0.4.0','11.1.0.7.0','11.2.0.2.0'))
order by name;
NAME 8.0.6.3.0 8.1.7.4.0 9.2.0.8.0 10.1.0.5.0 10.2.0.4.0 11.1.0.7.0 11.2.0.2.0
AQ Propagation Scheduling Proc Table X X X X X X
AQ Propagation Scheduling System Load X X X X X X
Change Notification Hash table latch X X X
Event Group Locks X X
In memory undo latch X X X
JOX JIT latch X X
JOX SGA heap latch X X X X X X
JS Sh mem access X X X
KCL gc element parent latch X X
KTF sga enqueue X
KTF sga latch X X X
KWQMN job cache list latch X X X X
KWQMN job instance list latch X
KWQMN to-be-Stopped Buffer list Latch X X X
KWQP Prop Status X X X X X
KWQS pqsubs latch X X
KWQS pqueue ctx latch X X
Memory Management Latch X X X X
Memory Queue X X X X
Memory Queue Subscriber X X X X
MinActiveScn Latch X X
ODM-NFS:Global file structure X X
OLS label cache X X X X
PL/SQL warning settings X X X X
Policy Hash Table Latch X X X X
Policy Refresh Latch X X X X
Result Cache: Latch X
Result Cache: RC Latch X
Role grants to users X X
Role graph X X
SGA blob lock X X
SGA heap creation lock X X
SGA mapping latch X X X X X
SGA pool creation lock X X
SGA table lock X X
Sage HT Latch X X
Security Class Hashtable X X
Shared B-Tree X X X X
WCR: processes HT X
WCR: sync X
XDB Byte Lock SGA Latch X X
XDB Mcache SGA Latch X X
XDB NFS Stateful SGA Latch X X
active service list X X X X
bq:time manger info latch X X X
browsers latch X
buffer pool X X X X X
bufq statistics X X X X
cache buffers chains X X X X X
change notification client cache latch X X
channel handle pool latch X X X X X X
channel operations parent latch X X X X X X
client/application info X X X X
compile environment latch X X X X
domain validation update latch X X
fifth spare latch X X
fourth Audit Vault latch X
fourth spare latch X X
gc element X X
gcr global ctx X
gcs partitioned table hash X X X X X
gcs pcm hashed value bucket hash X X X X X
gcs remastering latch X X X
global KZLD latch for mem in SGA X X X X
global ctx hash table latch X X X X X
hash table column usage latch X X X X X
hash table dml freq tracking latch X
instance information X X X X
kcbtsemkid latch X
kdlx hb parent latch X X
kgb latch X X
ksim group membership cache X
kssmov protection latch X X
kwqbsn:qsga X X X X
library cache hash chains X X
lob segment dispenser latch X X
lob segment hash table latch X X
lob segment query latch X X
message pool operations parent latch X X X X X X
name-service namespace bucket X X X X X X
object queue header operation X X X
parameter table allocation management X
parameter table management X X
policy information X X X X
qmne Export Table Latch X X
queue sender’s info. latch X X X X
recovery domain hash list X X X
redo copy X
resmgr group change latch X X X X
resmgr:active threads X X X
resmgr:plan CPU method X X X X X X
rules engine rule set statistics X X X
rules engine rule statistics X X X
session idle bit X X X X X X X
space background SGA latch X X
spilled msgs queues list latch X
storage server table manipulation latch X X
tablespace key chain X X
test shared non-parent l0 X X
third Audit Vault latch X
undo global data X

2 Comments »

  1. […] interesting. I created separate page where you can download shared_latches table content.  And here you can find the comparison of shared latches by Oracle […]

    Pingback by Shared latches by Oracle version « Latch, mutex and beyond — November 27, 2010 @ 11:28 pm | Reply

  2. Андрей,

    1. а может знаешь, что за “dummy allocation latch” ? Для чего она нужна?
    2. очень познавательный цикл статей, Спасибо!

    Comment by Yuri Pudovchenko — January 31, 2011 @ 10:21 am | Reply


RSS feed for comments on this post. TrackBack URI

Leave a comment

Blog at WordPress.com.