V$LOCKS_WITH_COLLISIONS

This is an Oracle Parallel Server view. Use this view to find the locks that protect multiple buffers, each of which has been either force-written or force-read at least 10 times. It is very likely that those buffers are experiencing false pings due to being mapped to the same lock.

See Also: Oracle8i Parallel Server Concepts.

Column	Datatype	Description
LOCK_ELEMENT_ ADDR	RAW(4)	The address of the lock element that contains the PCM lock covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock