Oracle v $ lock. type

Source: Internet
Author: User
Below v $ lock. type is 10.1, but most of them should be applicable to versions earlier than 10.1, especially 9.2. Record it for later use.

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

Name Description
AD ASM Disk AU Lock
AF Advisor Framework
AG Analytic Workspace Generation
AK GES Deadlock Test
AO MultiWriter Object Access
AS Service Operations
AT Alter Tablespace
AW Analytic Workspace
BR Backup/Restore
CF Controlfile Transaction
CI Cross-Instance Call Invocation
CL Label Security cache
CM ASM Instance Enqueue
CT Block Change Tracking
CU Cursor
DB DbsDriver
DD ASM Local Disk Group
DF Datafile Online in RAC
DG ASM Disk Group Modification
DI GES Internal
DL Direct Loader Index Creation
DM Database Mount/Open
DN Diskgroup number generator
DP LDAP Parameter
DQ Asm rbal doorbell
DR Distributed Recovery
DS Database Suspend
DT Default Temporary Tablespace
DV Diana Versioning
DX Distributed Transaction
E Library Cache Lock 2
FA ASM File Access Lock
FB Format Block
FC Disk Group Chunk Mount
FD Flashback Database
FG ACD Relocation Gate Enqueue
FL Flashback database log
FM File Mapping
FR Disk Group Recovery
FS File Set/Dictionary Check
FT Disk Group Redo Generation
FU DBFUS
G Library Cache Pin 2
HD ASM Disk Header
HP Queue Page
HQ Hash Queue
HV Direct Loader High Water Mark
HW Segment High Water Mark
IA Internal
ID NID
IL Label Security
IM Kti blr lock
IR Instance Recovery
IS Instance State
IT In-Mem Temp Table Meta Creation
IV Library Cache Invalidation
IZ INSTANCE LOCK
JD Job Queue Date
JI Materialized View
JQ Job Queue
JS Job Scheduler
KK Kick Instance to Switch Logs
KM Scheduler
KP Kupp Process Startup
KT Scheduler Plan
L Library Cache Lock 1
MD Materialized View Log DDL
MH AQ Notification Mail Host
ML AQ Notification Mail Port
MN LogMiner
MR Media Recovery
MS Materialized View Refresh Log
MW MWIN Schedule
N Library Cache Pin 1
OC Outline Cache
OL Outline Name
OQ OLAPI Histories
PD Property Lock
PE Parameter
PF Password File
PG Global Parameter
PH AQ Notification Proxy
PI Remote PX Process Spawn Status
PL Transportable Tablespace
PM Asm pst Signalling
PR Process Startup
PS PX Process Reservation
PT ASM Partnership and Status Table
PV KSV slave startup
PW Buffer Cache PreWarm
Q Row Cache
RB ASM Rollback Recovery
RF Data Guard Broker
RM GES Resource Remastering
RN Redo Log Nab Computation
RO Multiple Object Reuse
RP Resilver/Repair
RS Reclaimable Space
RT Redo Thread
SB LogicalStandby
SC System Change Number
SF AQ Notification Sender
SH Active Session History Flushing
SI Streams Table Instantiation
SK Shrink Segment
SM SMON Serialization
SQ Sequence Cache
SR Synchronized Replication
SS Sort Segment
ST Space Transaction
SU SaveUndo Segment
SV Sequence Ordering
SW Suspend Writes
TA Instance Undo
TB SQL Tuning Base Existence Cache
TC Tablespace Checkpoint
TD KTF map table enqueue
TE KTF broadcast
TF Temporary File
TL Log Lock
TM DML
TO Temp Object
TQ Queue table enqueue
TS Temporary Segment
TT Tablespace
TW Cross-Instance Transaction
TX Transaction
UL User-defined
UN User Name
US Undo Segment
WA AQ Notification Watermark
WF AWR Flush
WL Being Written Redo Log
WP AWR Purge
WS LogWriter Standby
XH AQ Notification No-Proxy
XR Quiesce/Force Logging
XY Internal Test

Http://hi.baidu.com/flying_hg/blog/item/6c443512152cfcc9c2fd7848.html

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.