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 |
|
|
|
|
|
|
Like this:
Like Loading...
[...] 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 |
Андрей,
1. а может знаешь, что за “dummy allocation latch” ? Для чего она нужна?
2. очень познавательный цикл статей, Спасибо!
Comment by Yuri Pudovchenko — January 31, 2011 @ 10:21 am |