Personal tools
You are here: Home Oracle How To's How to check the objecgt wise data bufferpool utilization
Navigation
Log in


Forgot your password?
 
Document Actions

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

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls