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