ORACLE 中的Enqueue 种类

 

Client or User Enqueues

TM : DML enqueue

TX : Transaction enqueue

UL : User supplied

 

Managed or System Enqueues

BL : Buffer Cache Management

CF : Controlfile Transaction

CI : Cross-instance Call Invocation

CU : Bind Enqueue

DF : Datafile

DL : Direct Loader Index Creation

DM : Database Mount

DR : Distributed Recovery

DX : Distributed TX

FS : File Set

IN : Instance Number

IR : Instance Recovery

IS : Instance State

IV : Library Cache Invalidation

JQ : Job Queue

KK : Redo Log “ Kick ”

L[A–P] : Library Cache Lock

MR : Media Recovery

N[A–Z] : Library Cache Pin

PF : Password File

PI : Parallel Slaves

PR : Process Startup

PS : Parallel Execution Process Synchronization

Q[A–Z] : Row Cache

RT : Redo Thread

SC : System Commit Number

SM : SMON

SQ : Sequence Number Enqueue

SR : Synchronized Replication

SS : Sort Segment

ST : Space Management Transaction

SV : Sequence Number Value

TA : Transaction Recovery

TS : Temporary Segment (also TableSpace)

TT : Temporary Table

UN : User Name

US : Undo Segment, Serialization

WL : Being Written Redo Log

XA : Instance Attribute Lock

XI : Instance Registration Lock

Note: The names of enqueues and their definitions may change from release to release.

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7728585/viewspace-619463/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7728585/viewspace-619463/