Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

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;