12c中新加入的Enqueue Lock列表如下：
其中值得注意的 ，为CDB加入了不少enqueue
BC ==》 Container lock held while creating/dropping a container
PB ==》 Enqueue used to synchronize PDB DDL operations
select A.* from ksqst_12cR1 A where A.KSQSTTYP not in (select B.KSQSTTYP from ksqst_11gR2@MACDBN B);
| AC | Synchronizes partition id |
| AQ | kwsptGetOrMapDqPtn |
| AQ | kwsptGetOrMapQPtn |
| BA | subscriber access to bitmap |
| BC | Container lock held while creating a container |
| BC | Container lock held while dropping a container |
| BC | Group lock held while creating a contained file |
| BC | Group lock held while creating a container |
| BC | Group lock held while dropping a container group |
| BI | Enqueue held while a contained file is cleaned up or deleted |
| BI | Enqueue held while a contained file is created |
| BI | Enqueue held while a contained file is identified |
| BV | Enqueue held while a container group is rebuilding |
| BZ | Enqueue held while a contained file is resized |
| CB | Synchronizes accesses to the CBAC roles cached in KGL |
| CC | decrypting and caching column key |
| CP | Synchronization |
| FH | Serializes flush of ILM stats to disk |
| FO | Synchronizes various Oracle File system operations |
| IC | Gets a unique client ID |
| IF | File Close |
| IF | File Open |
| IP | Enqueue used to synchronize instance state changes for PDBs |
| KI | Synchronizes Cross-Instance Calls |
| MC | Serializes log creation/destruction with log flushes |
| MF | Serializes flushes for a SGA log in bkgnd |
| MF | Serializes flushes for a single SGA log – client |
| MF | Serializes flushes for a single SGA log – destroy |
| MF | Serializes flushes for a single SGA log – error earlier |
| MF | Serializes flushes for a single SGA log – space lack |
| MF | Serializes multiple processes in creating the swap space |
| OP | Synchronizing access to ols$profile when deleting unused profiles |
| OP | Synchronizing access to ols$user when inserting user entries |
| PA | lock held for during modify a privilege capture |
| PA | lock held for during reading privilege captur status |
| PB | Enqueue used to synchronize PDB DDL operations |
| PQ | kwslbFreShadowShrd:LB syncronization with Truncate |
| PQ | kwsptChkTrncLst:Truncate |
| PQ | kwsptLoadDqCache: Add DQ Partitions. |
| PQ | kwsptLoadDqCache:Drop DQ Partitions. |
| PQ | kwsptLoadQCache: Add Q Partitions. |
| PQ | kwsptLoadQCache:Drop Q Partitions. |
| PQ | kwsptMapDqPtn:Drop DQ Partitions in foreground |
| PQ | kwsptMapQPtn: Add Q Partitions in foreground |
| PY | Database RTA info access on AVM |
| PY | Instance RTA info access on AVM |
| RA | Flood control in RAC. Acquired in no-wait. |
| RQ | AQ indexed cached commit |
| RQ | AQ uncached commit WM update |
| RQ | AQ uncached dequeue |
| RQ | Cross process updating disk |
| RQ | Cross(export) – truncate subshard |
| RQ | Cross(import) – free shadow shard |
| RQ | Dequeue updating scn |
| RQ | Enqueue commit rac cached |
| RQ | Enqueue commit uncached |
| RQ | Free shadow – Cross(import) shard |
| RQ | Parallel cross(update scn) – truncate subshard |
| RQ | Truncate – Cross(export) subshard |
| RZ | Synchronizes access to the foreign log cache while a structure is being inserted |
| RZ | Synchronizes access to the foreign log cache while a structure is being removed |
| SG | Synchronize access to ols$groups when creating a group |
| SG | Synchronize access to ols$groups when zlllabGroupTreeAddGroup does a read |
| SG | Synchronizing access to ols$groups when alter group parent |
| SG | Synchronizing access to ols$groups when dropping a group |
| ZS | lock held while writing to/renaming/deleting spillover audit file |
Leave a Reply