Hi Friends,
Here is one more new thing that I found tonight. There is a new dynamic performance view named V$LOCK_TYPE from Oracle 10g Release 1. Here are some of the views differenciated by Oracle version release. I think this is a good information for all the DBA's and hope you will enjoy!!!
- Oracle 10g Rel 1 came with 138 Lock type
- Oracle 10g Rel 2 came with another 17 lock type
- Oracle 11g Rel 1 came with another 32 lock type but non of them is removed.
| Name | Description | Version From |
| AD | ASM Disk AU Lock | 10g Rel 1 |
| AF | Advisor Framework | 10g Rel 1 |
| AG | Analytic Workspace Generation | 10g Rel 1 |
| AK | GES Deadlock Test | 10g Rel 1 |
| AO | MultiWriter Object Access | 10g Rel 1 |
| AS | Service Operations | 10g Rel 1 |
| AT | Alter Tablespace | 10g Rel 1 |
| AW | Analytic Workspace | 10g Rel 1 |
| BR | Backup/Restore | 10g Rel 1 |
| CF | Controlfile Transaction | 10g Rel 1 |
| CI | Cross-Instance Call Invocation | 10g Rel 1 |
| CL | Label Security cache | 10g Rel 1 |
| CM | ASM Instance Enqueue | 10g Rel 1 |
| CT | Block Change Tracking | 10g Rel 1 |
| CU | Cursor | 10g Rel 1 |
| DB | DbsDriver | 10g Rel 1 |
| DD | ASM Local Disk Group | 10g Rel 1 |
| DF | Datafile Online in RAC | 10g Rel 1 |
| DG | ASM Disk Group Modification | 10g Rel 1 |
| DI | GES Internal | 10g Rel 1 |
| DL | Direct Loader Index Creation | 10g Rel 1 |
| DM | Database Mount/Open | 10g Rel 1 |
| DN | Diskgroup number generator | 10g Rel 1 |
| DP | LDAP Parameter | 10g Rel 1 |
| DQ | ASM RBAL doorbell | 10g Rel 1 |
| DR | Distributed Recovery | 10g Rel 1 |
| DS | Database Suspend | 10g Rel 1 |
| DT | Default Temporary Tablespace | 10g Rel 1 |
| DV | Diana Versioning | 10g Rel 1 |
| DX | Distributed Transaction | 10g Rel 1 |
| E | Library Cache Lock 2 | 10g Rel 1 |
| FA | ASM File Access Lock | 10g Rel 1 |
| FB | Format Block | 10g Rel 1 |
| FC | Disk Group Chunk Mount | 10g Rel 1 |
| FD | Flashback Database | 10g Rel 1 |
| FG | ACD Relocation Gate Enqueue | 10g Rel 1 |
| FL | Flashback database log | 10g Rel 1 |
| FM | File Mapping | 10g Rel 1 |
| FR | Disk Group Recovery | 10g Rel 1 |
| FS | File Set / Dictionary Check | 10g Rel 1 |
| FT | Disk Group Redo Generation | 10g Rel 1 |
| FU | DBFUS | 10g Rel 1 |
| G | Library Cache Pin 2 | 10g Rel 1 |
| HD | ASM Disk Header | 10g Rel 1 |
| HP | Queue Page | 10g Rel 1 |
| HQ | Hash Queue | 10g Rel 1 |
| HV | Direct Loader High Water Mark | 10g Rel 1 |
| HW | Segment High Water Mark | 10g Rel 1 |
| IA | Internal | 10g Rel 1 |
| ID | NID | 10g Rel 1 |
| IL | Label Security | 10g Rel 1 |
| IM | Kti blr lock | 10g Rel 1 |
| IR | Instance Recovery | 10g Rel 1 |
| IS | Instance State | 10g Rel 1 |
| IT | In-Mem Temp Table Meta Creation | 10g Rel 1 |
| IV | Library Cache Invalidation | 10g Rel 1 |
| IZ | INSTANCE LOCK | 10g Rel 1 |
| JD | Job Queue Date | 10g Rel 1 |
| JI | Materialized View | 10g Rel 1 |
| JQ | Job Queue | 10g Rel 1 |
| JS | Job Scheduler | 10g Rel 1 |
| KK | Kick Instance to Switch Logs | 10g Rel 1 |
| KM | Scheduler | 10g Rel 1 |
| KP | Kupp Process Startup | 10g Rel 1 |
| KT | Scheduler Plan | 10g Rel 1 |
| L | Library Cache Lock 1 | 10g Rel 1 |
| MD | Materialized View Log DDL | 10g Rel 1 |
| MH | AQ Notification Mail Host | 10g Rel 1 |
| ML | AQ Notification Mail Port | 10g Rel 1 |
| MN | LogMiner | 10g Rel 1 |
| MR | Media Recovery | 10g Rel 1 |
| MS | Materialized View Refresh Log | 10g Rel 1 |
| MW | MWIN Schedule | 10g Rel 1 |
| N | Library Cache Pin 1 | 10g Rel 1 |
| OC | Outline Cache | 10g Rel 1 |
| OL | Outline Name | 10g Rel 1 |
| OQ | OLAPI Histories | 10g Rel 1 |
| PD | Property Lock | 10g Rel 1 |
| PE | Parameter | 10g Rel 1 |
| PF | Password File | 10g Rel 1 |
| PG | Global Parameter | 10g Rel 1 |
| PH | AQ Notification Proxy | 10g Rel 1 |
| PI | Remote PX Process Spawn Status | 10g Rel 1 |
| PL | Transportable Tablespace | 10g Rel 1 |
| PM | ASM PST Signalling | 10g Rel 1 |
| PR | Process Startup | 10g Rel 1 |
| PS | PX Process Reservation | 10g Rel 1 |
| PT | ASM Partnership and Status Table | 10g Rel 1 |
| PV | KSV slave startup | 10g Rel 1 |
| PW | Buffer Cache PreWarm | 10g Rel 1 |
| Q | Row Cache | 10g Rel 1 |
| RB | ASM Rollback Recovery | 10g Rel 1 |
| RF | Data Guard Broker | 10g Rel 1 |
| RM | GES Resource Remastering | 10g Rel 1 |
| RN | Redo Log Nab Computation | 10g Rel 1 |
| RO | Multiple Object Reuse | 10g Rel 1 |
| RP | Resilver / Repair | 10g Rel 1 |
| RS | Reclaimable Space | 10g Rel 1 |
| RT | Redo Thread | 10g Rel 1 |
| SB | LogicalStandby | 10g Rel 1 |
| SC | System Change Number | 10g Rel 1 |
| SF | AQ Notification Sender | 10g Rel 1 |
| SH | Active Session History Flushing | 10g Rel 1 |
| SI | Streams Table Instantiation | 10g Rel 1 |
| SK | Shrink Segment | 10g Rel 1 |
| SM | SMON Serialization | 10g Rel 1 |
| SQ | Sequence Cache | 10g Rel 1 |
| SR | Synchronized Replication | 10g Rel 1 |
| SS | Sort Segment | 10g Rel 1 |
| ST | Space Transaction | 10g Rel 1 |
| SU | SaveUndo Segment | 10g Rel 1 |
| SV | Sequence Ordering | 10g Rel 1 |
| SW | Suspend Writes | 10g Rel 1 |
| TA | Instance Undo | 10g Rel 1 |
| TB | SQL Tuning Base Existence Cache | 10g Rel 1 |
| TC | Tablespace Checkpoint | 10g Rel 1 |
| TD | KTF map table enqueue | 10g Rel 1 |
| TE | KTF broadcast | 10g Rel 1 |
| TF | Temporary File | 10g Rel 1 |
| TL | Log Lock | 10g Rel 1 |
| TM | DML | 10g Rel 1 |
| TO | Temp Object | 10g Rel 1 |
| TQ | Queue table enqueue | 10g Rel 1 |
| TS | Temporary Segment | 10g Rel 1 |
| TT | Tablespace | 10g Rel 1 |
| TW | Cross-Instance Transaction | 10g Rel 1 |
| TX | Transaction | 10g Rel 1 |
| UL | User-defined | 10g Rel 1 |
| UN | User Name | 10g Rel 1 |
| US | Undo Segment | 10g Rel 1 |
| WA | AQ Notification Watermark | 10g Rel 1 |
| WF | AWR Flush | 10g Rel 1 |
| WL | Being Written Redo Log | 10g Rel 1 |
| WP | AWR Purge | 10g Rel 1 |
| WS | LogWriter Standby | 10g Rel 1 |
| XH | AQ Notification No-Proxy | 10g Rel 1 |
| XR | Quiesce / Force Logging | 10g Rel 1 |
| XY | Internal Test | 10g Rel 1 |
| AM | ASM Enqueue | New in 10g Rel 2 |
| AU | Audit Index File | New in 10g Rel 2 |
| BF | Bloom Filter | New in 10g Rel 2 |
| CN | LTCN REG enquere | New in 10g Rel 2 |
| FP | File Object | New in 10g Rel 2 |
| FW | Flashback Writer | New in 10g Rel 2 |
| KO | Multiple Object Checkpoint | New in 10g Rel 2 |
| MK | Master Key | New in 10g Rel 2 |
| OW | Encryption Wallet | New in 10g Rel 2 |
| RU | Rolling Upgrade | New in 10g Rel 2 |
| RW | Materialized View Flags | New in 10g Rel 2 |
| SE | Session Migration | New in 10g Rel 2 |
| V | Library Cache Lock 3 | New in 10g Rel 2 |
| WR | LNS archiving log | New in 10g Rel 2 |
| XQ | ASM Extent Relocation Enqueue | New in 10g Rel 2 |
| Y | Library Cache Pin 3 | New in 10g Rel 2 |
| ZG | File Group | New in 10g Rel 2 |
| AE | Edition Lock | New in 11g Rel 1 |
| AR | ASM Relocation Lock | New in 11g Rel 1 |
| AV | AVD DG Number Lock | New in 11g Rel 1 |
| AY | KSXA Test Affinity Dictionary | New in 11g Rel 1 |
| BB | Global Transaction Branch | New in 11g Rel 1 |
| CA | Calibration | New in 11g Rel 1 |
| CO | KTUCLO Master Slave enqueue | New in 11g Rel 1 |
| CQ | Cleanup querycache registrations | New in 11g Rel 1 |
| DO | ASM Disk Online Lock | New in 11g Rel 1 |
| DW | In memory Dispenser | New in 11g Rel 1 |
| FE | KTFA Recovery | New in 11g Rel 1 |
| FX | ACD Extent Info CIC | New in 11g Rel 1 |
| FZ | ASM Freezing Cache Lock | New in 11g Rel 1 |
| KE | ASM Cached Attributes | New in 11g Rel 1 |
| KL | LOB KSI Lock | New in 11g Rel 1 |
| KQ | ASM Attributes Enqueue | New in 11g Rel 1 |
| MO | MMON restricted session | New in 11g Rel 1 |
| MX | ksz synch | New in 11g Rel 1 |
| OD | Online DDLs | New in 11g Rel 1 |
| RC | Result Cache: Enqueue | New in 11g Rel 1 |
| RE | Block Repair/Resilvering | New in 11g Rel 1 |
| RR | Workload Capture and Replay | New in 11g Rel 1 |
| RX | ASM Extent Relocation Lock | New in 11g Rel 1 |
| SJ | KTSJ Slave Task Cancel | New in 11g Rel 1 |
| SL | Serialize Lock request | New in 11g Rel 1 |
| SO | Shared Object | New in 11g Rel 1 |
| TH | Threshold Chain | New in 11g Rel 1 |
| TK | Auto Task Serialization | New in 11g Rel 1 |
| WG | Write gather local enqueue | New in 11g Rel 1 |
| WM | WLM Plan Operations | New in 11g Rel 1 |
| XB | ASM Group Block Lock | New in 11g Rel 1 |
| XL | ASM Extent Fault Lock | New in 11g Rel 1 |
THANKS TO IMERGE FOR POSTING THIS GOOD INFORMATION...
ReplyDeleteI REALLY APPRECIATE!!!!