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
 Forgot your password?
           Forgot your password?
         
             
             
                    
                    
                 
                    
                    
                 Hacker Rangers - Gamification for CyberSecurity
                Hacker Rangers - Gamification for CyberSecurity