Re: ORA-04031: Please help

Thanks alot for your help..
Now Oracle is working fine.

Is there any way to check for possible ( future) errors in this parameter settings?

Shafeek Khalidh
ICQ#81191628 "Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:augupt$p65$1_at_babylon.agtel.net...
> 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_at_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 - 03:23:31 CST