Hmm... You've set the shared pool to about 17 megabytes with your
last setting (and I guess it was even lower than that before) - it's still
too low. Set it to at least 50 megabytes and 4031 will go away (and
check your code and ensure it's shareable, that is, that it uses bind
variables where appropriate.) Your java_pool_size is too low either -
it should be 35 megabytes or more. You can use nnM to specify
pool sizes in megabytes instead of bytes. For example,
shared_pool_size = 50M # 50 megabytes
java_pool_size = 35M # 35 megabytes
--
Vladimir Zakharychev (bob@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.
"Shafeek Khalidh" <itsprobablyme_at_msn.com> wrote in message
news:augu2g$765kg$1_at_ID-137434.news.dfncis.de...
> 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
>
>
>
>
Received on Fri Dec 27 2002 - 01:12:10 CST
