1. 首页
  2. IT资讯

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://www.cxybcw.com/183173.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code