Thursday, January 18, 2018

How to check the shared pool usage in oracle

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';

No comments:

Post a Comment