Shared Memory Pool - Oraclegreenspun.com : LUSENET : DBAzine : One Thread |
Hi all,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 (laurence.noton@logicacmg.com), July 14, 2003
instead of increasing the shared pool you can try increasing the java pool size,which will solve the problem, regs riju
-- (f.riju@teles.com), October 18, 2004.