oracle v$lock.type

如下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:

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