Re: Shared memory problem

Hi,

I have got the same problem on different databases (one linux, one dec) they are both on version 8.1.7.0.

I searched the web for a very long time to find the following:

"You may be encountering bug 1397603 if you are on 8.1.7.0. The fix is in 8.1.7.2 and AFAIK is available on Solaris. To verify run the following query perodically. If the result is gradually increasing, you're encountering 1397603. This query must be run as SYS.

select count(*) from x$ksmsp where ksmchcls = 'perm';"

I set the _db_handles_cahce to zero and now have to wait for a few weeks to see if this "solves" anything.

Regards, pollux

"Fredrik Lorén" <frl_at_nbit.se> 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
Received on Sun Aug 18 2002 - 15:01:25 CEST