Hi Gigiz,
Please post the following outputs:
#sar -b 3 33
#sar -v 3 33
And since this is Oracle:
select (bbc.total_waits*100/(cg.value+dbg.value)) "Buff busy ratio"
from v$system_event bbc,
v$sysstat cg, v$sysstat dbg
where bbc.event='buffer busy waits'
and cg.name ='consistent gets'
and dbg.name='db block gets';
select round(100 * sum(getmisses) / sum(gets), 2) "Misses Pct (%)"
from v$rowcache
having sum(gets) > 1000;
select (1-(sum(getmisses)/sum(gets))) * 100 "Hit Ratio"
from v$rowcache;
select round(((1-(sum(decode(name, 'physical reads', value,0)) /
(sum(decode(name,'db block gets', value,0))+
(sum(decode(name, 'consistent gets', value, 0))))))*100),2)
|| '%' "Buffer Cache Hit Ratio (%)"
from v$sysstat;
select round(100 * sum(reloads) / sum(pins), 2) "Reloads Pct (%)"
from v$librarycache
having sum(pins) > 1000;
select pool, name, bytes/1024/1024 "Free Size in MB"
from v$sgastat
where name='free memory';
Best Regards,
Eric Antunes
Each and every day is a good day to learn.
