shared pool size
Ora_83Nov 29 2009 — edited Dec 2 2009Hi
How can I figure out wheter I need to resize shared pool ? (Oracle 9i)
When I issue:
/* Shared pool usage */
select 100-round(a.bytes/b.sm*100,2) pctused from
(select bytes from v$sgastat where name='free memory' AND pool='shared pool') a,
(select sum(bytes) sm from v$sgastat where pool = 'shared pool') b;
PCTUSED
----------------
95.74