Oracle Internals

Oracle 10.2 Lock Types

In Oracle 10.1 there were 138 lock types; in Oracle 10.2 there are 155 lock types

The following table shows the 17 lock types that were added in Oracle 10.2:

Name	Description
AM	ASM Enqueue
AU	Audit Index File
BF	Bloom Filter
CN	LTCN REG enquere
FP	File Object
FW	Flashback Writer
KO	Multiple Object Checkpoint
MK	Master Key
OW	Encryption Wallet
RU	Rolling Upgrade
RW	Materialized View Flags
SE	Session Migration
V	Library Cache Lock 3
WR	LNS archiving log
XQ	ASM Extent Relocation Enqueue
Y	Library Cache Pin 3
ZG	File Group

No lock types were removed from Oracle 10.2