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.
05-14-2004, 05:50 PM
And then, whats the difference between sum(sharable_mem) from v$sqlarea and "free memory" from v$sgastat where pool='shared pool' ??
05-18-2004, 03:40 PM
Any inputs on this ?? Please...
05-19-2004, 02:53 AM
Do not think so i.e sum(sharable_mem) is not an ideal indicator of shared_pool usage - use "free memory" from v$sgastat.