I had run this query on my database and got the following


SQL> select to_number(v$parameter.value)value, v$sgastat.bytes,
2 (v$sgastat.bytes/v$parameter.value)*100 "Percent Free"
3 from v$sgastat,v$parameter
4 where v$sgastat.name = 'free memory'
5 and v$parameter.name = 'shared_pool_size';

Shared Pool Size Free Bytes Percent Free
---------------- ---------------- ------------
29,000,000 2,878,876 9.92715862

Can someone please assist me with this problem. i am made to believe that the shared pool is small. To what value should I set the shared pool?