select name, round(sum(mb),1) mb, round(sum(inuse),1) inuse from ( select case when name = 'buffer_cache' then 'db_cache_size' when name = 'log_buffer' then 'log_buffer' else pool end name, bytes/1024/1024 mb, case when name = 'buffer_cache' then (bytes - (select count(*) from v$bh where status = 'free') * (select value from v$parameter where name = 'db_block_size') )/1024/1024 when name <> 'free memory' then bytes/1024/1024 end inuse from v$sgastat ) group by name;
jeudi 28 novembre 2013
[Oracle] How to monitor real SGA memory usage
From something read on the net :