Find buffer cache usage - Oracle Database Script col object_name format a30 col to_total format 999.99 SELECT OWNER, object_name, object_type, COUNT, (COUNT / value) * 100 to_total FROM (SELECT a.owner, a.object_name, a.object_type, count(*) COUNT FROM dba_objects a, x$bh b WHERE a.object_id = b.obj AND a.owner NOT IN ('SYS', 'SYSTEM') GROUP BY a.owner, a.object_name, a.object_type ORDER BY 4), v$parameter WHERE name = 'db_cache_size' AND (COUNT / value) * 100 .005 ORDER BY to_total DESC /
col object_name format a30 col to_total format 999.99 SELECT OWNER, object_name, object_type, COUNT, (COUNT / value) * 100 to_total FROM (SELECT a.owner, a.object_name, a.object_type, count(*) COUNT FROM dba_objects a, x$bh b WHERE a.object_id = b.obj AND a.owner NOT IN ('SYS', 'SYSTEM') GROUP BY a.owner, a.object_name, a.object_type ORDER BY 4), v$parameter WHERE name = 'db_cache_size' AND (COUNT / value) * 100 .005 ORDER BY to_total DESC /