Query:
================
select sum(bytes/1024/1024) "Total_MB" from v$sgastat where pool = 'shared pool';
select sum(decode(name,'free memory',bytes))/1024/1024 "Free_MB" from v$sgastat where pool = 'shared pool';
================
select sum(bytes/1024/1024) "Total_MB" from v$sgastat where pool = 'shared pool';
select sum(decode(name,'free memory',bytes))/1024/1024 "Free_MB" from v$sgastat where pool = 'shared pool';

No comments:
Post a Comment