【12c新特性】12c中新加入的Enqueue Lock

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

Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *