Latch, mutex and beyond

shared_latches.ctl

--     This file is part of demos for "Contemporary Latch Internals" seminar v.05.02.2011     
--     Andrey S. Nikolaev (Andrey.Nikolaev@rdtex.ru) 
--     http://AndreyNikolaev.wordpress.com
-- The format for executing this file with SQL Loader is:
-- SQLLDR control=shared_latches.ctl 
LOAD DATA
INFILE *
BADFILE './SHARED_LATCHES.BAD'
DISCARDFILE './SHARED_LATCHES.DSC'
APPEND INTO TABLE SYS.SHARED_LATCHES
Fields terminated by ";" Optionally enclosed by '"'
(
  VERSION,
  LATCH# NULLIF (LATCH#="NULL"),
  NAME,
  SHARED
)
BEGINDATA
"11.2.0.3.0";6;"test shared non-parent l0";"Y"
"11.2.0.3.0";14;"session idle bit";"Y"
"11.2.0.3.0";15;"client/application info";"Y"
"11.2.0.3.0";21;"ksim group membership cache";"Y"
"11.2.0.3.0";24;"parameter table management";"Y"
"11.2.0.3.0";48;"resmgr group change latch";"Y"
"11.2.0.3.0";49;"channel handle pool latch";"Y"
"11.2.0.3.0";50;"channel operations parent latch";"Y"
"11.2.0.3.0";51;"message pool operations parent latch";"Y"
"11.2.0.3.0";62;"fourth spare latch";"Y"
"11.2.0.3.0";63;"fifth spare latch";"Y"
"11.2.0.3.0";71;"SGA mapping latch";"Y"
"11.2.0.3.0";72;"active service list";"Y"
"11.2.0.3.0";81;"storage server table manipulation latch";"Y"
"11.2.0.3.0";123;"name-service namespace bucket";"Y"
"11.2.0.3.0";128;"gcs remastering latch";"Y"
"11.2.0.3.0";129;"gcs partitioned table hash";"Y"
"11.2.0.3.0";130;"gcs pcm hashed value bucket hash";"Y"
"11.2.0.3.0";133;"recovery domain hash list";"Y"
"11.2.0.3.0";138;"gcr global ctx";"Y"
"11.2.0.3.0";142;"Memory Management Latch";"Y"
"11.2.0.3.0";149;"kcbtsemkid latch";"Y"
"11.2.0.3.0";151;"buffer pool";"Y"
"11.2.0.3.0";155;"cache buffers chains";"Y"
"11.2.0.3.0";161;"tablespace key chain";"Y"
"11.2.0.3.0";167;"object queue header operation";"Y"
"11.2.0.3.0";192;"gc element";"Y"
"11.2.0.3.0";246;"MinActiveScn Latch";"Y"
"11.2.0.3.0";251;"In memory undo latch";"Y"
"11.2.0.3.0";252;"KTF sga latch";"Y"
"11.2.0.3.0";254;"Change Notification Hash table latch";"Y"
"11.2.0.3.0";257;"change notification client cache latch";"Y"
"11.2.0.3.0";260;"lob segment hash table latch";"Y"
"11.2.0.3.0";261;"lob segment query latch";"Y"
"11.2.0.3.0";262;"lob segment dispenser latch";"Y"
"11.2.0.3.0";267;"space background SGA latch";"Y"
"11.2.0.3.0";272;"kssmov protection latch";"Y"
"11.2.0.3.0";276;"domain validation update latch";"Y"
"11.2.0.3.0";277;"kdlx hb parent latch";"Y"
"11.2.0.3.0";279;"Dedup Write Append Table Latch";"Y"
"11.2.0.3.0";288;"global KZLD latch for mem in SGA";"Y"
"11.2.0.3.0";289;"Read Only Database Account Status";"Y"
"11.2.0.3.0";291;"Policy Refresh Latch";"Y"
"11.2.0.3.0";292;"Policy Hash Table Latch";"Y"
"11.2.0.3.0";293;"OLS label cache";"Y"
"11.2.0.3.0";294;"instance information";"Y"
"11.2.0.3.0";295;"policy information";"Y"
"11.2.0.3.0";296;"global ctx hash table latch";"Y"
"11.2.0.3.0";297;"Role grants to users";"Y"
"11.2.0.3.0";298;"Role graph";"Y"
"11.2.0.3.0";299;"Security Class Hashtable";"Y"
"11.2.0.3.0";302;"third Audit Vault latch";"Y"
"11.2.0.3.0";303;"fourth Audit Vault latch";"Y"
"11.2.0.3.0";315;"resmgr:active threads";"Y"
"11.2.0.3.0";320;"resmgr:plan CPU method";"Y"
"11.2.0.3.0";326;"Shared B-Tree";"Y"
"11.2.0.3.0";327;"Memory Queue";"Y"
"11.2.0.3.0";328;"Memory Queue Subscriber";"Y"
"11.2.0.3.0";340;"ODM-NFS:Global file structure";"Y"
"11.2.0.3.0";344;"SGA heap creation lock";"Y"
"11.2.0.3.0";346;"SGA pool creation lock";"Y"
"11.2.0.3.0";349;"SGA blob lock";"Y"
"11.2.0.3.0";351;"kgb latch";"Y"
"11.2.0.3.0";353;"SGA table lock";"Y"
"11.2.0.3.0";354;"Event Group Locks";"Y"
"11.2.0.3.0";356;"Sage HT Latch";"Y"
"11.2.0.3.0";380;"JOX SGA heap latch";"Y"
"11.2.0.3.0";381;"JOX JIT latch";"Y"
"11.2.0.3.0";396;"hash table dml freq tracking latch";"Y"
"11.2.0.3.0";397;"hash table column usage latch";"Y"
"11.2.0.3.0";404;"compile environment latch";"Y"
"11.2.0.3.0";407;"Result Cache: RC Latch";"Y"
"11.2.0.3.0";435;"KWQP Prop Status";"Y"
"11.2.0.3.0";436;"KWQS pqueue ctx latch";"Y"
"11.2.0.3.0";437;"KWQS pqsubs latch";"Y"
"11.2.0.3.0";438;"AQ Propagation Scheduling Proc Table";"Y"
"11.2.0.3.0";439;"AQ Propagation Scheduling System Load";"Y"
"11.2.0.3.0";442;"rules engine rule set statistics";"Y"
"11.2.0.3.0";443;"rules engine rule statistics";"Y"
"11.2.0.3.0";448;"kwqbsn:qsga";"Y"
"11.2.0.3.0";450;"bufq statistics";"Y"
"11.2.0.3.0";452;"queue sender's info. latch";"Y"
"11.2.0.3.0";453;"bq:time manger info latch";"Y"
"11.2.0.3.0";457;"KWQMN job cache list latch";"Y"
"11.2.0.3.0";458;"KWQMN to-be-Stopped Buffer list Latch";"Y"
"11.2.0.3.0";475;"XDB NFS Stateful SGA Latch";"Y"
"11.2.0.3.0";476;"qmne Export Table Latch";"Y"
"11.2.0.3.0";478;"XDB Byte Lock SGA Latch";"Y"
"11.2.0.3.0";479;"XDB Mcache SGA Latch";"Y"
"11.2.0.3.0";536;"WCR: sync";"Y"
"11.2.0.3.0";537;"WCR: processes HT";"Y"
"11.2.0.3.0";549;"JS Sh mem access";"Y"
"11.2.0.3.0";550;"PL/SQL warning settings";"Y"
"11.2.0.2.0";7;"test shared non-parent l0";"Y"
"11.2.0.2.0";15;"session idle bit";"Y"
"11.2.0.2.0";16;"client/application info";"Y"
"11.2.0.2.0";22;"ksim group membership cache";"Y"
"11.2.0.2.0";25;"parameter table management";"Y"
"11.2.0.2.0";48;"resmgr group change latch";"Y"
"11.2.0.2.0";49;"channel handle pool latch";"Y"
"11.2.0.2.0";50;"channel operations parent latch";"Y"
"11.2.0.2.0";51;"message pool operations parent latch";"Y"
"11.2.0.2.0";62;"fourth spare latch";"Y"
"11.2.0.2.0";63;"fifth spare latch";"Y"
"11.2.0.2.0";71;"SGA mapping latch";"Y"
"11.2.0.2.0";72;"active service list";"Y"
"11.2.0.2.0";81;"storage server table manipulation latch";"Y"
"11.2.0.2.0";123;"name-service namespace bucket";"Y"
"11.2.0.2.0";128;"gcs remastering latch";"Y"
"11.2.0.2.0";129;"gcs partitioned table hash";"Y"
"11.2.0.2.0";130;"gcs pcm hashed value bucket hash";"Y"
"11.2.0.2.0";133;"recovery domain hash list";"Y"
"11.2.0.2.0";138;"gcr global ctx";"Y"
"11.2.0.2.0";142;"Memory Management Latch";"Y"
"11.2.0.2.0";149;"kcbtsemkid latch";"Y"
"11.2.0.2.0";151;"buffer pool";"Y"
"11.2.0.2.0";155;"cache buffers chains";"Y"
"11.2.0.2.0";161;"tablespace key chain";"Y"
"11.2.0.2.0";167;"object queue header operation";"Y"
"11.2.0.2.0";192;"gc element";"Y"
"11.2.0.2.0";246;"MinActiveScn Latch";"Y"
"11.2.0.2.0";251;"In memory undo latch";"Y"
"11.2.0.2.0";252;"KTF sga latch";"Y"
"11.2.0.2.0";254;"Change Notification Hash table latch";"Y"
"11.2.0.2.0";257;"change notification client cache latch";"Y"
"11.2.0.2.0";260;"lob segment hash table latch";"Y"
"11.2.0.2.0";261;"lob segment query latch";"Y"
"11.2.0.2.0";262;"lob segment dispenser latch";"Y"
"11.2.0.2.0";267;"space background SGA latch";"Y"
"11.2.0.2.0";272;"kssmov protection latch";"Y"
"11.2.0.2.0";276;"domain validation update latch";"Y"
"11.2.0.2.0";277;"kdlx hb parent latch";"Y"
"11.2.0.2.0";287;"global KZLD latch for mem in SGA";"Y"
"11.2.0.2.0";289;"Policy Refresh Latch";"Y"
"11.2.0.2.0";290;"Policy Hash Table Latch";"Y"
"11.2.0.2.0";291;"OLS label cache";"Y"
"11.2.0.2.0";292;"instance information";"Y"
"11.2.0.2.0";293;"policy information";"Y"
"11.2.0.2.0";294;"global ctx hash table latch";"Y"
"11.2.0.2.0";295;"Role grants to users";"Y"
"11.2.0.2.0";296;"Role graph";"Y"
"11.2.0.2.0";297;"Security Class Hashtable";"Y"
"11.2.0.2.0";300;"third Audit Vault latch";"Y"
"11.2.0.2.0";301;"fourth Audit Vault latch";"Y"
"11.2.0.2.0";313;"resmgr:active threads";"Y"
"11.2.0.2.0";318;"resmgr:plan CPU method";"Y"
"11.2.0.2.0";324;"Shared B-Tree";"Y"
"11.2.0.2.0";325;"Memory Queue";"Y"
"11.2.0.2.0";326;"Memory Queue Subscriber";"Y"
"11.2.0.2.0";338;"ODM-NFS:Global file structure";"Y"
"11.2.0.2.0";342;"SGA heap creation lock";"Y"
"11.2.0.2.0";344;"SGA pool creation lock";"Y"
"11.2.0.2.0";347;"SGA blob lock";"Y"
"11.2.0.2.0";349;"kgb latch";"Y"
"11.2.0.2.0";351;"SGA table lock";"Y"
"11.2.0.2.0";352;"Event Group Locks";"Y"
"11.2.0.2.0";354;"Sage HT Latch";"Y"
"11.2.0.2.0";378;"JOX SGA heap latch";"Y"
"11.2.0.2.0";379;"JOX JIT latch";"Y"
"11.2.0.2.0";394;"hash table dml freq tracking latch";"Y"
"11.2.0.2.0";395;"hash table column usage latch";"Y"
"11.2.0.2.0";402;"compile environment latch";"Y"
"11.2.0.2.0";405;"Result Cache: RC Latch";"Y"
"11.2.0.2.0";433;"KWQP Prop Status";"Y"
"11.2.0.2.0";434;"KWQS pqueue ctx latch";"Y"
"11.2.0.2.0";435;"KWQS pqsubs latch";"Y"
"11.2.0.2.0";436;"AQ Propagation Scheduling Proc Table";"Y"
"11.2.0.2.0";437;"AQ Propagation Scheduling System Load";"Y"
"11.2.0.2.0";440;"rules engine rule set statistics";"Y"
"11.2.0.2.0";441;"rules engine rule statistics";"Y"
"11.2.0.2.0";446;"kwqbsn:qsga";"Y"
"11.2.0.2.0";448;"bufq statistics";"Y"
"11.2.0.2.0";450;"queue sender's info. latch";"Y"
"11.2.0.2.0";451;"bq:time manger info latch";"Y"
"11.2.0.2.0";455;"KWQMN job cache list latch";"Y"
"11.2.0.2.0";456;"KWQMN to-be-Stopped Buffer list Latch";"Y"
"11.2.0.2.0";473;"XDB NFS Stateful SGA Latch";"Y"
"11.2.0.2.0";474;"qmne Export Table Latch";"Y"
"11.2.0.2.0";476;"XDB Byte Lock SGA Latch";"Y"
"11.2.0.2.0";477;"XDB Mcache SGA Latch";"Y"
"11.2.0.2.0";534;"WCR: sync";"Y"
"11.2.0.2.0";535;"WCR: processes HT";"Y"
"11.2.0.2.0";547;"JS Sh mem access";"Y"
"11.2.0.2.0";548;"PL/SQL warning settings";"Y"
"11.1.0.7.0";7;"test shared non-parent l0";"Y"
"11.1.0.7.0";13;"session idle bit";"Y"
"11.1.0.7.0";14;"client/application info";"Y"
"11.1.0.7.0";22;"parameter table management";"Y"
"11.1.0.7.0";45;"resmgr group change latch";"Y"
"11.1.0.7.0";46;"channel handle pool latch";"Y"
"11.1.0.7.0";47;"channel operations parent latch";"Y"
"11.1.0.7.0";48;"message pool operations parent latch";"Y"
"11.1.0.7.0";59;"fourth spare latch";"Y"
"11.1.0.7.0";60;"fifth spare latch";"Y"
"11.1.0.7.0";66;"SGA mapping latch";"Y"
"11.1.0.7.0";67;"active service list";"Y"
"11.1.0.7.0";76;"storage server table manipulation latch";"Y"
"11.1.0.7.0";116;"name-service namespace bucket";"Y"
"11.1.0.7.0";121;"gcs remastering latch";"Y"
"11.1.0.7.0";122;"gcs partitioned table hash";"Y"
"11.1.0.7.0";123;"gcs pcm hashed value bucket hash";"Y"
"11.1.0.7.0";126;"recovery domain hash list";"Y"
"11.1.0.7.0";132;"Memory Management Latch";"Y"
"11.1.0.7.0";140;"buffer pool";"Y"
"11.1.0.7.0";144;"cache buffers chains";"Y"
"11.1.0.7.0";150;"tablespace key chain";"Y"
"11.1.0.7.0";156;"object queue header operation";"Y"
"11.1.0.7.0";177;"gc element";"Y"
"11.1.0.7.0";226;"MinActiveScn Latch";"Y"
"11.1.0.7.0";231;"In memory undo latch";"Y"
"11.1.0.7.0";232;"KTF sga latch";"Y"
"11.1.0.7.0";234;"Change Notification Hash table latch";"Y"
"11.1.0.7.0";237;"change notification client cache latch";"Y"
"11.1.0.7.0";239;"lob segment hash table latch";"Y"
"11.1.0.7.0";240;"lob segment query latch";"Y"
"11.1.0.7.0";241;"lob segment dispenser latch";"Y"
"11.1.0.7.0";245;"space background SGA latch";"Y"
"11.1.0.7.0";250;"kssmov protection latch";"Y"
"11.1.0.7.0";254;"domain validation update latch";"Y"
"11.1.0.7.0";255;"kdlx hb parent latch";"Y"
"11.1.0.7.0";266;"global KZLD latch for mem in SGA";"Y"
"11.1.0.7.0";269;"Policy Refresh Latch";"Y"
"11.1.0.7.0";270;"Policy Hash Table Latch";"Y"
"11.1.0.7.0";271;"OLS label cache";"Y"
"11.1.0.7.0";272;"instance information";"Y"
"11.1.0.7.0";273;"policy information";"Y"
"11.1.0.7.0";274;"global ctx hash table latch";"Y"
"11.1.0.7.0";275;"Role grants to users";"Y"
"11.1.0.7.0";276;"Role graph";"Y"
"11.1.0.7.0";277;"Security Class Hashtable";"Y"
"11.1.0.7.0";289;"resmgr:active threads";"Y"
"11.1.0.7.0";294;"resmgr:plan CPU method";"Y"
"11.1.0.7.0";300;"Shared B-Tree";"Y"
"11.1.0.7.0";301;"Memory Queue";"Y"
"11.1.0.7.0";302;"Memory Queue Subscriber";"Y"
"11.1.0.7.0";314;"ODM-NFS:Global file structure";"Y"
"11.1.0.7.0";317;"SGA heap creation lock";"Y"
"11.1.0.7.0";319;"SGA pool creation lock";"Y"
"11.1.0.7.0";322;"SGA blob lock";"Y"
"11.1.0.7.0";324;"kgb latch";"Y"
"11.1.0.7.0";326;"SGA table lock";"Y"
"11.1.0.7.0";327;"Event Group Locks";"Y"
"11.1.0.7.0";329;"Sage HT Latch";"Y"
"11.1.0.7.0";353;"JOX SGA heap latch";"Y"
"11.1.0.7.0";354;"JOX JIT latch";"Y"
"11.1.0.7.0";367;"hash table column usage latch";"Y"
"11.1.0.7.0";374;"compile environment latch";"Y"
"11.1.0.7.0";377;"Result Cache: Latch";"Y"
"11.1.0.7.0";401;"KWQP Prop Status";"Y"
"11.1.0.7.0";402;"KWQS pqueue ctx latch";"Y"
"11.1.0.7.0";403;"KWQS pqsubs latch";"Y"
"11.1.0.7.0";404;"AQ Propagation Scheduling Proc Table";"Y"
"11.1.0.7.0";405;"AQ Propagation Scheduling System Load";"Y"
"11.1.0.7.0";408;"rules engine rule set statistics";"Y"
"11.1.0.7.0";409;"rules engine rule statistics";"Y"
"11.1.0.7.0";414;"kwqbsn:qsga";"Y"
"11.1.0.7.0";416;"bufq statistics";"Y"
"11.1.0.7.0";418;"queue sender's info. latch";"Y"
"11.1.0.7.0";419;"bq:time manger info latch";"Y"
"11.1.0.7.0";423;"KWQMN job cache list latch";"Y"
"11.1.0.7.0";424;"KWQMN to-be-Stopped Buffer list Latch";"Y"
"11.1.0.7.0";434;"XDB NFS Stateful SGA Latch";"Y"
"11.1.0.7.0";435;"qmne Export Table Latch";"Y"
"11.1.0.7.0";437;"XDB Byte Lock SGA Latch";"Y"
"11.1.0.7.0";438;"XDB Mcache SGA Latch";"Y"
"11.1.0.7.0";499;"JS Sh mem access";"Y"
"11.1.0.7.0";500;"PL/SQL warning settings";"Y"
"10.2.0.4.0";7;"session idle bit";"Y"
"10.2.0.4.0";8;"client/application info";"Y"
"10.2.0.4.0";15;"parameter table allocation management";"Y"
"10.2.0.4.0";35;"resmgr group change latch";"Y"
"10.2.0.4.0";36;"channel handle pool latch";"Y"
"10.2.0.4.0";37;"channel operations parent latch";"Y"
"10.2.0.4.0";38;"message pool operations parent latch";"Y"
"10.2.0.4.0";51;"SGA mapping latch";"Y"
"10.2.0.4.0";52;"active service list";"Y"
"10.2.0.4.0";97;"name-service namespace bucket";"Y"
"10.2.0.4.0";101;"gcs remastering latch";"Y"
"10.2.0.4.0";102;"gcs partitioned table hash";"Y"
"10.2.0.4.0";103;"gcs pcm hashed value bucket hash";"Y"
"10.2.0.4.0";106;"recovery domain hash list";"Y"
"10.2.0.4.0";109;"Memory Management Latch";"Y"
"10.2.0.4.0";118;"buffer pool";"Y"
"10.2.0.4.0";122;"cache buffers chains";"Y"
"10.2.0.4.0";131;"object queue header operation";"Y"
"10.2.0.4.0";150;"KCL gc element parent latch";"Y"
"10.2.0.4.0";193;"In memory undo latch";"Y"
"10.2.0.4.0";194;"KTF sga latch";"Y"
"10.2.0.4.0";196;"Change Notification Hash table latch";"Y"
"10.2.0.4.0";204;"global KZLD latch for mem in SGA";"Y"
"10.2.0.4.0";207;"Policy Refresh Latch";"Y"
"10.2.0.4.0";208;"Policy Hash Table Latch";"Y"
"10.2.0.4.0";209;"OLS label cache";"Y"
"10.2.0.4.0";210;"instance information";"Y"
"10.2.0.4.0";211;"policy information";"Y"
"10.2.0.4.0";212;"global ctx hash table latch";"Y"
"10.2.0.4.0";221;"library cache hash chains";"Y"
"10.2.0.4.0";229;"resmgr:active threads";"Y"
"10.2.0.4.0";238;"resmgr:plan CPU method";"Y"
"10.2.0.4.0";244;"Shared B-Tree";"Y"
"10.2.0.4.0";245;"Memory Queue";"Y"
"10.2.0.4.0";246;"Memory Queue Subscriber";"Y"
"10.2.0.4.0";271;"JOX SGA heap latch";"Y"
"10.2.0.4.0";284;"hash table column usage latch";"Y"
"10.2.0.4.0";291;"compile environment latch";"Y"
"10.2.0.4.0";314;"KWQP Prop Status";"Y"
"10.2.0.4.0";315;"AQ Propagation Scheduling Proc Table";"Y"
"10.2.0.4.0";316;"AQ Propagation Scheduling System Load";"Y"
"10.2.0.4.0";319;"rules engine rule set statistics";"Y"
"10.2.0.4.0";320;"rules engine rule statistics";"Y"
"10.2.0.4.0";325;"kwqbsn:qsga";"Y"
"10.2.0.4.0";327;"bufq statistics";"Y"
"10.2.0.4.0";329;"queue sender's info. latch";"Y"
"10.2.0.4.0";330;"bq:time manger info latch";"Y"
"10.2.0.4.0";333;"KWQMN job cache list latch";"Y"
"10.2.0.4.0";334;"KWQMN to-be-Stopped Buffer list Latch";"Y"
"10.2.0.4.0";392;"JS Sh mem access";"Y"
"10.2.0.4.0";393;"PL/SQL warning settings";"Y"
"10.2.0.3.0";7;"session idle bit";"Y"
"10.2.0.3.0";8;"client/application info";"Y"
"10.2.0.3.0";35;"resmgr group change latch";"Y"
"10.2.0.3.0";36;"channel handle pool latch";"Y"
"10.2.0.3.0";37;"channel operations parent latch";"Y"
"10.2.0.3.0";38;"message pool operations parent latch";"Y"
"10.2.0.3.0";51;"SGA mapping latch";"Y"
"10.2.0.3.0";52;"active service list";"Y"
"10.2.0.3.0";97;"name-service namespace bucket";"Y"
"10.2.0.3.0";101;"gcs remastering latch";"Y"
"10.2.0.3.0";102;"gcs partitioned table hash";"Y"
"10.2.0.3.0";103;"gcs pcm hashed value bucket hash";"Y"
"10.2.0.3.0";106;"recovery domain hash list";"Y"
"10.2.0.3.0";109;"Memory Management Latch";"Y"
"10.2.0.3.0";118;"buffer pool";"Y"
"10.2.0.3.0";122;"cache buffers chains";"Y"
"10.2.0.3.0";131;"object queue header operation";"Y"
"10.2.0.3.0";150;"KCL gc element parent latch";"Y"
"10.2.0.3.0";193;"KTF sga latch";"Y"
"10.2.0.3.0";195;"Change Notification Hash table latch";"Y"
"10.2.0.3.0";203;"global KZLD latch for mem in SGA";"Y"
"10.2.0.3.0";206;"Policy Refresh Latch";"Y"
"10.2.0.3.0";207;"Policy Hash Table Latch";"Y"
"10.2.0.3.0";208;"OLS label cache";"Y"
"10.2.0.3.0";209;"instance information";"Y"
"10.2.0.3.0";210;"policy information";"Y"
"10.2.0.3.0";211;"global ctx hash table latch";"Y"
"10.2.0.3.0";220;"library cache hash chains";"Y"
"10.2.0.3.0";237;"resmgr:plan CPU method";"Y"
"10.2.0.3.0";243;"Shared B-Tree";"Y"
"10.2.0.3.0";244;"Memory Queue";"Y"
"10.2.0.3.0";245;"Memory Queue Subscriber";"Y"
"10.2.0.3.0";270;"JOX SGA heap latch";"Y"
"10.2.0.3.0";283;"hash table column usage latch";"Y"
"10.2.0.3.0";290;"compile environment latch";"Y"
"10.2.0.3.0";312;"KWQP Prop Status";"Y"
"10.2.0.3.0";313;"AQ Propagation Scheduling Proc Table";"Y"
"10.2.0.3.0";314;"AQ Propagation Scheduling System Load";"Y"
"10.2.0.3.0";317;"rules engine rule set statistics";"Y"
"10.2.0.3.0";318;"rules engine rule statistics";"Y"
"10.2.0.3.0";323;"kwqbsn:qsga";"Y"
"10.2.0.3.0";325;"bufq statistics";"Y"
"10.2.0.3.0";327;"queue sender's info. latch";"Y"
"10.2.0.3.0";328;"bq:time manger info latch";"Y"
"10.2.0.3.0";331;"KWQMN job cache list latch";"Y"
"10.2.0.3.0";332;"KWQMN to-be-Stopped Buffer list Latch";"Y"
"10.2.0.3.0";386;"JS Sh mem access";"Y"
"10.2.0.3.0";387;"PL/SQL warning settings";"Y"
"10.1.0.5.0";7;"session idle bit";"Y"
"10.1.0.5.0";8;"client/application info";"Y"
"10.1.0.5.0";35;"resmgr group change latch";"Y"
"10.1.0.5.0";36;"channel handle pool latch";"Y"
"10.1.0.5.0";37;"channel operations parent latch";"Y"
"10.1.0.5.0";38;"message pool operations parent latch";"Y"
"10.1.0.5.0";51;"SGA mapping latch";"Y"
"10.1.0.5.0";52;"active service list";"Y"
"10.1.0.5.0";91;"name-service namespace bucket";"Y"
"10.1.0.5.0";96;"gcs partitioned table hash";"Y"
"10.1.0.5.0";97;"gcs pcm hashed value bucket hash";"Y"
"10.1.0.5.0";104;"Memory Management Latch";"Y"
"10.1.0.5.0";114;"buffer pool";"Y"
"10.1.0.5.0";118;"cache buffers chains";"Y"
"10.1.0.5.0";142;"KCL gc element parent latch";"Y"
"10.1.0.5.0";183;"KTF sga enqueue";"Y"
"10.1.0.5.0";190;"global KZLD latch for mem in SGA";"Y"
"10.1.0.5.0";193;"Policy Refresh Latch";"Y"
"10.1.0.5.0";194;"Policy Hash Table Latch";"Y"
"10.1.0.5.0";195;"OLS label cache";"Y"
"10.1.0.5.0";196;"instance information";"Y"
"10.1.0.5.0";197;"policy information";"Y"
"10.1.0.5.0";198;"global ctx hash table latch";"Y"
"10.1.0.5.0";207;"library cache hash chains";"Y"
"10.1.0.5.0";224;"resmgr:plan CPU method";"Y"
"10.1.0.5.0";228;"Shared B-Tree";"Y"
"10.1.0.5.0";229;"Memory Queue";"Y"
"10.1.0.5.0";230;"Memory Queue Subscriber";"Y"
"10.1.0.5.0";245;"JOX SGA heap latch";"Y"
"10.1.0.5.0";260;"hash table column usage latch";"Y"
"10.1.0.5.0";267;"compile environment latch";"Y"
"10.1.0.5.0";280;"KWQP Prop Status";"Y"
"10.1.0.5.0";281;"AQ Propagation Scheduling Proc Table";"Y"
"10.1.0.5.0";282;"AQ Propagation Scheduling System Load";"Y"
"10.1.0.5.0";287;"kwqbsn:qsga";"Y"
"10.1.0.5.0";289;"bufq statistics";"Y"
"10.1.0.5.0";291;"queue sender's info. latch";"Y"
"10.1.0.5.0";294;"KWQMN job instance list latch";"Y"
"10.1.0.5.0";295;"KWQMN job cache list latch";"Y"
"10.1.0.5.0";349;"PL/SQL warning settings";"Y"
"9.2.0.8.0";7;"session idle bit";"Y"
"9.2.0.8.0";33;"channel handle pool latch";"Y"
"9.2.0.8.0";34;"channel operations parent latch";"Y"
"9.2.0.8.0";35;"message pool operations parent latch";"Y"
"9.2.0.8.0";44;"SGA mapping latch";"Y"
"9.2.0.8.0";78;"name-service namespace bucket";"Y"
"9.2.0.8.0";83;"gcs partitioned table hash";"Y"
"9.2.0.8.0";84;"gcs pcm hashed value bucket hash";"Y"
"9.2.0.8.0";94;"buffer pool";"Y"
"9.2.0.8.0";98;"cache buffers chains";"Y"
"9.2.0.8.0";151;"global ctx hash table latch";"Y"
"9.2.0.8.0";177;"resmgr:plan CPU method";"Y"
"9.2.0.8.0";191;"JOX SGA heap latch";"Y"
"9.2.0.8.0";203;"hash table column usage latch";"Y"
"9.2.0.8.0";217;"browsers latch";"Y"
"9.2.0.8.0";221;"spilled msgs queues list latch";"Y"
"9.2.0.8.0";225;"KWQP Prop Status";"Y"
"9.2.0.8.0";226;"AQ Propagation Scheduling Proc Table";"Y"
"9.2.0.8.0";227;"AQ Propagation Scheduling System Load";"Y"
"9.0.1.3.0";0;"latch wait list";"Y"
"9.0.1.3.0";0;"latch wait list";"Y"
"9.0.1.3.0";7;"session idle bit";"Y"
"9.0.1.3.0";7;"session idle bit";"Y"
"9.0.1.3.0";32;"channel handle pool latch";"Y"
"9.0.1.3.0";32;"channel handle pool latch";"Y"
"9.0.1.3.0";33;"channel operations parent latch";"Y"
"9.0.1.3.0";33;"channel operations parent latch";"Y"
"9.0.1.3.0";34;"message pool operations parent latch";"Y"
"9.0.1.3.0";34;"message pool operations parent latch";"Y"
"9.0.1.3.0";72;"name-service namespace bucket";"Y"
"9.0.1.3.0";72;"name-service namespace bucket";"Y"
"9.0.1.3.0";84;"buffer pool";"Y"
"9.0.1.3.0";84;"buffer pool";"Y"
"9.0.1.3.0";88;"cache buffers chains";"Y"
"9.0.1.3.0";88;"cache buffers chains";"Y"
"9.0.1.3.0";124;"undo global data";"Y"
"9.0.1.3.0";124;"undo global data";"Y"
"9.0.1.3.0";135;"global ctx hash table latch";"Y"
"9.0.1.3.0";135;"global ctx hash table latch";"Y"
"9.0.1.3.0";159;"resmgr:plan CPU method";"Y"
"9.0.1.3.0";159;"resmgr:plan CPU method";"Y"
"9.0.1.3.0";172;"JOX SGA heap latch";"Y"
"9.0.1.3.0";172;"JOX SGA heap latch";"Y"
"9.0.1.3.0";185;"hash table column usage latch";"Y"
"9.0.1.3.0";185;"hash table column usage latch";"Y"
"9.0.1.3.0";196;"AQ Propagation Scheduling Proc Table";"Y"
"9.0.1.3.0";196;"AQ Propagation Scheduling Proc Table";"Y"
"9.0.1.3.0";197;"AQ Propagation Scheduling System Load";"Y"
"9.0.1.3.0";197;"AQ Propagation Scheduling System Load";"Y"
"8.1.7.4.0";5;"session idle bit";"Y"
"8.1.7.4.0";26;"channel handle pool latch";"Y"
"8.1.7.4.0";27;"channel operations parent latch";"Y"
"8.1.7.4.0";28;"message pool operations parent latch";"Y"
"8.1.7.4.0";55;"name-service namespace bucket";"Y"
"8.1.7.4.0";121;"resmgr:plan CPU method";"Y"
"8.1.7.4.0";134;"JOX SGA heap latch";"Y"
"8.1.7.4.0";149;"AQ Propagation Scheduling Proc Table";"Y"
"8.1.7.4.0";150;"AQ Propagation Scheduling System Load";"Y"
"8.0.6.3.0";4;"session idle bit";"Y"
"8.0.6.3.0";37;"redo copy";"Y"
"8.0.6.3.0";50;"undo global data";"Y"

1 Comment »

  1. [...] The results look 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


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 68 other followers

%d bloggers like this: