V$LOCKS_WITH_COLLISIONS

This is an Oracle9i Real Application Clusters 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: Oracle9i Real Application Clusters 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.