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