- Active Locks - The current number of active locks as determined by the value in the v$locks table. Database administrators should be aware of high numbers of locks present in a database instance.
Table A.58. Oracle::Locks settings
|Critical Maximum Active Locks|
|Warning Maximum Active Locks|