Re: ORA-4030 Out of Process Memory

You had me at:

NVL(F.PRC_END_DT, TO_DATE('01-01-2099',
'MM-DD-YYYY')) BETWEEN E.BEG_DT AND E.END_DT ) Perhaps you should go the route of pinning objects that aren't garbage and flush early, flush often. (alter system flush shared_pool)

check v$sgastat for shared pool - free memory.

-bdbafh Received on Thu Nov 17 2005 - 10:22:14 CST