主页 > 知识库 > 数据库 > Oracle >

Oracle 常见的33个等待事件(5)

来源:网络 作者:liyf0371 发表于:2012-09-04 10:04  点击:
Oracle的enqueue 有如下类型: Enqueue 缩写 缩写解释 BL Buffer Cache management BR Backup/Restore CF Controlfile transaction CI Cross-instance Call Invocation CU Bind Enqueue DF Datafile DL Direct Load
 
 
Oracle的enqueue 有如下类型:
Enqueue 缩写 缩写解释
BL Buffer Cache management
BR Backup/Restore
CF Controlfile transaction
CI Cross-instance Call Invocation
CU Bind Enqueue
DF Datafile
DL Direct Loader Index Creation
DM Database Mount
DR Distributed Recovery Process
DX Dirstributed Transaction
FP File Object
FS File Set
HW High-water Lock
IN Instance Number
IR Instance Recovery
IS Instance State
IV Library Cache Invalidation
JI Enqueue used during AJV snapshot refresh
JQ Job Queue
KK Redo Log “Kick”
KO Multiple Object Checkpoint
L[A-p] Library Cache Lock
LS Log start or switch
MM Mount Definition
MR Media recovery
N[A-Z] Library Cache bin
PE Alter system set parameter =value
PF Password file
PI Parallel slaves
PR Process startup
PS Parallel slave synchronization
Q[A-Z] Row Cache
RO Object Reuse
RT Redo Thread
RW Row Wait
SC System Commit Number
SM SMON
SN Sequence Number
SQ Sequence Number Enqueue
SR Synchronized replication
SS Sort segment
ST Space management transaction
SV Sequence number Value
TA Transaction recovery
TC Thread Checkpoint
TE Extend Table
TM DML enqueue
TO Temporary Table Object Enqueue
TS Temporary Segement(also TableSpace)
TT Temporary Table
TX Transaction
UL User-defined Locks
UN User name
US Undo segment, Serialization
WL Being Written Redo Log
XA Instance Attribute Log
XI           Instance Registration Lock

有帮助
(0)
0%
没帮助
(0)
0%