doc

    Name:    classblk.sql

    Author:  Mark Gurry

    The following query shows the number of locks allocated to each
    class.

#

SELECT  class, count(*) 
  FROM  v$lock_element
 GROUP BY class;