see Normans answer for the parameter. If this is a 24/7 system and so you
don't immediately have a downtime window you *may* get away with issuing
alter system flush shared pool; from sqlplus connected with dba privileges.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Chris" <chris.lo_at_cyberwisdom.net> wrote in message
news:9q18rv$n9e$1_at_tenorhorn.hk.dyxnet.com...
> I read some articles and they said that the problem can solved by
modifying
> the initXXX.ORA . What parameter and value should I modify? The memory
size
> of the oracle server is 1024M. Thanks.
>
> Chris
>
>
> > I wrote an servlet application that use Oracle 8.1.6 as the database.
The
> > servlet works fine for servel months and the application is in the
> > production mode. However users get the following error when access one
of
> > the page:
> >
> > ORA-04031: unable to allocate 184 bytes of shared memory ("shared
> > pool","unknown object","sql area","qerixs : rixalo")
> >
> > Any idea is highly appreciated.
> > Chris
> >
> >
>
>
Received on Wed Oct 10 2001 - 06:31:30 CDT
