doc

    Name:    indexcnt.sql

    Author:  Mark Gurry

    The following query shows the index contention.

#

SELECT  usr.name, vp.name, vp.kind, SUM(vp.xnc), SUM(vp.lock_element_addr)
  FROM  sys.user$ usr, v$ping vp
WHERE  vp.owner# = usr.user#
GROUP  BY usr.name, vp.name, vp.kind;