Oracle 11.1 Lock Types

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