Oracle Internals
JulianDyke.com

Welcome

Consultancy

Presentations

Diagnostics

Internals

Acknowledgements

Oracle 10.1 Lock Types

The V$LOCK_TYPE dynamic performance view was introduced in Oracle 10.1

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
E Library 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
G Library 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
L Library Cache Lock 1
MDMaterialized View Log DDL
MHAQ Notification Mail Host
MLAQ Notification Mail Port
MNLogMiner
MRMedia Recovery
MSMaterialized View Refresh Log
MWMWIN Schedule
N Library 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
Q Row 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