Oracle 11.1 Lock Types
In Oracle 10.2 there were 155 lock types; in Oracle 11.1 there are 187 lock types
The following table shows the 32 lock types that were added in Oracle 11.1:
|
| Name | Description |
| AE | Edition Lock |
| AR | ASM Relocation Lock |
| AV | AVD DG Number Lock |
| AY | KSXA Test Affinity Dictionary |
| BB | Global Transaction Branch |
| CA | Calibration |
| CO | KTUCLO Master Slave enqueue |
| CQ | Cleanup querycache registrations |
| DO | ASM Disk Online Lock |
| DW | In memory Dispenser |
| FE | KTFA Recovery |
| FX | ACD Extent Info CIC |
| FZ | ASM Freezing Cache Lock |
| KE | ASM Cached Attributes |
| KL | LOB KSI Lock |
| KQ | ASM Attributes Enqueue |
| MO | MMON restricted session |
| MX | ksz synch |
| OD | Online DDLs |
| RC | Result Cache: Enqueue |
| RE | Block Repair/Resilvering |
| RR | Workload Capture and Replay |
| RX | ASM Extent Relocation Lock |
| SJ | KTSJ Slave Task Cancel |
| SL | Serialize Lock request |
| SO | Shared Object |
| TH | Threshold Chain |
| TK | Auto Task Serialization |
| WG | Write gather local enqueue |
| WM | WLM Plan Operations |
| XB | ASM Group Block Lock |
| XL | ASM Extent Fault Lock |
|
No lock types were removed from Oracle 11.1
| 
