Shared Memory Pool - Oracle

greenspun.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

Answers

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.

Moderation questions? read the FAQ