Re: Shared memory problem

frl_at_nbit.se (=?ISO-8859-1?Q?Fredrik_Lor=E9n?=) wrote in message news:<92321a1.0208090400.5a5cfc78_at_posting.google.com>...
> Hello!
>
> I return the following error in my webpage. We use Oracle 8.1.7.
> What's the problem? This problem first occured two months ago, then we
> restarted our IIS and our Oracle server and then it worked until now.
>
> ORA-00604: error occurred at recursive SQL level 2 ORA-04031: unable
> to allocate 4048 bytes of shared memory ("shared pool","TRIGGER$","sga
> heap","state objects") ORA-00604: error occurred at recursive SQL
> level 2 ORA-04031: unable to allocate 4048 bytes of shared memory
> ("shared pool","SEQ$","sga heap","state
> objects")NavigationGetTopMenuId Failed: NavigationId Not
> returnedORA-00604: error occurred at recursive SQL level 2 ORA-04031:
> unable to allocate 4048 bytes of shared memory ("shared
> pool","TRIGGER$","sga heap","state objects") ORA-00604: error occurred
> at recursive SQL level 2 ORA-04031: unable to allocate 4048 bytes of
> shared memory ("shared pool","SEQ$","sga heap","state objects")
>
> //Fredrik

ORA-04031 is associated with SHARED_POOL_SIZE parameter. Increase the size of shared_pool_size parameter in your databases's init.ora file and then bounce your database. Check to see if error still persists.

//Rauf Sarwar Received on Mon Aug 19 2002 - 00:00:57 CEST