ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle v$lock.type

oracle v$lock.type

原创 Linux操作系统 作者:Jun_San 时间:2011-12-30 15:05:31 0 删除 编辑
如下v$lock.type是10.1的,但大多数应该适应于10.1以下版本,特别是9.2版本。记录一下,以备后用了。

The following table shows the 138 lock types that are reported by V$LOCK_TYPE in Oracle 10.1:

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
摘自:http://hi.baidu.com/flying_hg/blog/item/6c443512152cfcc9c2fd7848.html

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

上一篇: 没有了~
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-09-09

  • 博文量
    1
  • 访问量
    2595