doc

    Name:    classavg.sql

    Author:  Mark Gurry

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

#

SELECT  class, avg(block_count)
  FROM  v$lock_element
 GROUP BY class;