Find oracle shared pool is usage
select
sum(a.bytes)/(1024*1024) shared_pool_used,
max(b.value)/(1024*1024) shared_pool_size,
(max(b.value)/(1024*1024))-(sum(a.bytes)/(1024*1024)) shared_pool_avail,
(sum(a.bytes)/max(b.value))*100 shared_pool_pct
from v$sgastat a, v$parameter b
where a.name in (
‘reserved stopper’,
‘table definiti’,
‘dictionary cache’,
‘library cache’,
‘sql area’,
‘PL/SQL DIANA’,
‘SEQ S.O.’) and
b.name=’shared_pool_size’;
