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