ORA-04031: unable to allocate 4096 bytes of shared memory

[Shafeek Khalidh]

Hi all,

I'm getting error when I'm connecting to oracle.

The error message follows...............

ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","BEGIN
DBMS_OUTPUT.DISABLE; E...","PL/SQL MPCODE","BAMIMA: Bam Buffer")

Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","BEGIN
DBMS_APPLICATION_INFO....","PL/SQL MPCODE","BAMIMA: Bam Buffer")

Solutions I tried follows....................

1) When i execute ALTER SYSTEM FLUSH SHARED_POOL the problem is solved,
but
after some time i get the same error again.

2) I've modified the shared_pool_size, but it shows some memory error
when I'm trying to query
some huge sql statements. ( Error saying could not read memory location)
( shared_pool_size = 17000000 )

3) As per the previous records in this group, I've modified
"java_pool_size", but still I'm getting the error.
( Modified java_pool_size = 5971520)

4) Shutdown and restart the oracle server.

Please show me direction.....

Oracle version - 8.1.7.0.0
OS - Windows 2K / 512MB

Shafeek Khalidh
ICQ#81191628

[Vladimir M. Zakharychev]

See my answer in c.d.o.misc, and please do not crosspost.

--
Vladimir Zakharychev (b...@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.