buffers.sql
Download Script
col object_name for a30
SELECT object_name, count(obj)
FROM x$bh, dba_objects
WHERE obj = object_id
and owner not in ('SYS','SYSTEM')
GROUP BY object_name
order by 2 asc;
Download Script
col object_name for a30
SELECT object_name, count(obj)
FROM x$bh, dba_objects
WHERE obj = object_id
and owner not in ('SYS','SYSTEM')
GROUP BY object_name
order by 2 asc;