-
sum(sharable_mem)
Hello DBAs,
Is sum(sharable_mem) from v$sqlarea any indication of how full shared pool is ? Can it indicate how close things are to getting ORA-04031 error ? Can it be used as an indication to do "alter system flush shared_pool" until there is an opportunity to bounce the dba and increase the shared pool ?
BTW, this is 32-bit 806 db.
Thanks
Last edited by svk; 05-12-2004 at 11:24 AM.
svk
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
|