v$lock.type中的內容解釋

warehouse發表於2012-11-21

搜了一下,發現一個哥們的blog上列出來了,連線如下:

http://blog.csdn.net/binhe521/article/details/4509951

為了防止上面連線過期,內容直接複製了過來。

[@more@]
NameDescription
ADASM Disk AU Lock
AFAdvisor Framework
AGAnalytic Workspace Generation
AKGES Deadlock Test
AOMultiWriter Object Access
ASService Operations
ATAlter Tablespace
AWAnalytic Workspace
BRBackup/Restore
CFControlfile Transaction
CICross-Instance Call Invocation
CLLabel Security cache
CMASM Instance Enqueue
CTBlock Change Tracking
CUCursor
DBDbsDriver
DDASM Local Disk Group
DFDatafile Online in RAC
DGASM Disk Group Modification
DIGES Internal
DLDirect Loader Index Creation
DMDatabase Mount/Open
DNDiskgroup number generator
DPLDAP Parameter
DQASM RBAL doorbell
DRDistributed Recovery
DSDatabase Suspend
DTDefault Temporary Tablespace
DVDiana Versioning
DXDistributed Transaction
ELibrary Cache Lock 2
FAASM File Access Lock
FBFormat Block
FCDisk Group Chunk Mount
FDFlashback Database
FGACD Relocation Gate Enqueue
FLFlashback database log
FMFile Mapping
FRDisk Group Recovery
FSFile Set / Dictionary Check
FTDisk Group Redo Generation
FUDBFUS
GLibrary Cache Pin 2
HDASM Disk Header
HPQueue Page
HQHash Queue
HVDirect Loader High Water Mark
HWSegment High Water Mark
IAInternal
IDNID
ILLabel Security
IMKti blr lock
IRInstance Recovery
ISInstance State
ITIn-Mem Temp Table Meta Creation
IVLibrary Cache Invalidation
IZINSTANCE LOCK
JDJob Queue Date
JIMaterialized View
JQJob Queue
JSJob Scheduler
KKKick Instance to Switch Logs
KMScheduler
KPKupp Process Startup
KTScheduler Plan
LLibrary Cache Lock 1
MDMaterialized View Log DDL
MHAQ Notification Mail Host
MLAQ Notification Mail Port
MNLogMiner
MRMedia Recovery
MSMaterialized View Refresh Log
MWMWIN Schedule
NLibrary Cache Pin 1
OCOutline Cache
OLOutline Name
OQOLAPI Histories
PDProperty Lock
PEParameter
PFPassword File
PGGlobal Parameter
PHAQ Notification Proxy
PIRemote PX Process Spawn Status
PLTransportable Tablespace
PMASM PST Signalling
PRProcess Startup
PSPX Process Reservation
PTASM Partnership and Status Table
PVKSV slave startup
PWBuffer Cache PreWarm
QRow Cache
RBASM Rollback Recovery
RFData Guard Broker
RMGES Resource Remastering
RNRedo Log Nab Computation
ROMultiple Object Reuse
RPResilver / Repair
RSReclaimable Space
RTRedo Thread
SBLogicalStandby
SCSystem Change Number
SFAQ Notification Sender
SHActive Session History Flushing
SIStreams Table Instantiation
SKShrink Segment
SMSMON Serialization
SQSequence Cache
SRSynchronized Replication
SSSort Segment
STSpace Transaction
SUSaveUndo Segment
SVSequence Ordering
SWSuspend Writes
TAInstance Undo
TBSQL Tuning Base Existence Cache
TCTablespace Checkpoint
TDKTF map table enqueue
TEKTF broadcast
TFTemporary File
TLLog Lock
TMDML
TOTemp Object
TQQueue table enqueue
TSTemporary Segment
TTTablespace
TWCross-Instance Transaction
TXTransaction
ULUser-defined
UNUser Name
USUndo Segment
WAAQ Notification Watermark
WFAWR Flush
WLBeing Written Redo Log
WPAWR Purge
WSLogWriter Standby
XHAQ Notification No-Proxy
XRQuiesce / Force Logging
XYInternal Test
NameDescription
ADASM Disk AU Lock
AFAdvisor Framework
AGAnalytic Workspace Generation
AKGES Deadlock Test
AOMultiWriter Object Access
ASService Operations
ATAlter Tablespace
AWAnalytic Workspace
BRBackup/Restore
CFControlfile Transaction
CICross-Instance Call Invocation
CLLabel Security cache
CMASM Instance Enqueue
CTBlock Change Tracking
CUCursor
DBDbsDriver
DDASM Local Disk Group
DFDatafile Online in RAC
DGASM Disk Group Modification
DIGES Internal
DLDirect Loader Index Creation
DMDatabase Mount/Open
DNDiskgroup number generator
DPLDAP Parameter
DQASM RBAL doorbell
DRDistributed Recovery
DSDatabase Suspend
DTDefault Temporary Tablespace
DVDiana Versioning
DXDistributed Transaction
ELibrary Cache Lock 2
FAASM File Access Lock
FBFormat Block
FCDisk Group Chunk Mount
FDFlashback Database
FGACD Relocation Gate Enqueue
FLFlashback database log
FMFile Mapping
FRDisk Group Recovery
FSFile Set / Dictionary Check
FTDisk Group Redo Generation
FUDBFUS
GLibrary Cache Pin 2
HDASM Disk Header
HPQueue Page
HQHash Queue
HVDirect Loader High Water Mark
HWSegment High Water Mark
IAInternal
IDNID
ILLabel Security
IMKti blr lock
IRInstance Recovery
ISInstance State
ITIn-Mem Temp Table Meta Creation
IVLibrary Cache Invalidation

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/19602/viewspace-1059803/,如需轉載,請註明出處,否則將追究法律責任。

相關文章