-
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?
PMS
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|