Why large pool if MTS is not used?
session_cached_cursors AFIAK uses memory in your session, i.e PGA, it stores pointers to shared pool
ORA-04031 means memory fragmentation, if you dont use binds you are allocating, deallocating all the time, you are fragmentating your shared pool




Reply With Quote