-- 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"
shared_latches.ctl
1 Comment »
RSS feed for comments on this post. TrackBack URI
Latch, mutex and beyond 
[…] 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 |