ORACLE 中的Enqueue 種類

gaopengtttt發表於2009-11-12
OracleENQ
 
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章