How to check the objecgt wise data bufferpool utilization
Data Buffer pool for individual Utilization
column c0 heading 'Owner' format a15
column c1 heading 'Object|Name' format a30
column c2 heading 'Number|of|Buffers' format 999,999
column c3 heading 'Percentage|of Data|Buffer' format 999,999,999
select
owner Owner,
object_name Object_Name,
count(1) Number_of_Buffers,
(count(1)/(select count(*) from v$bh)) *100 Percentage_of_Data_Buffer
from
dba_objects o,
v$bh bh
where
o.object_id = bh.objd
and
o.owner not in ('SYS','SYSTEM','AURORA$JIS$UTILITY$')
group by
owner,
object_name
order by
count(1) desc