OracleのSharedPoolSizeの空き状況(%)を取得するクエリ

    

OracleのSharedPoolSizeの空き状況(%)を取得するクエリ

select
     ROUND( ( select sum(bytes)  from v$sgastat where name = 'free memory' and POOL='shared pool' ) /  ( select sum(value)  from v$sga where name = 'Variable Size'  )* 100 , 2 ) as sharedPoolFreePer
from dual