Shared Memory Pool - Oraclegreenspun.com : LUSENET : DBAzine : One Thread
We are haveing problems with Shared Memory Pool errors...ie. cannot allocate 4200 bytes of memory.
Why is this?
Our procedures contains lots of dynamic sql, and research shows this can be a problem. Is it possible to just expand the shared memory pool size via dba studio? or is this unwise?
We are running oracle 8i.
-- Laurence Noton (firstname.lastname@example.org), July 14, 2003
instead of increasing the shared pool you can try increasing the java pool size,which will solve the problem, regs riju
-- (email@example.com), October 18, 2004.