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

Advertisement