Re: ORA-4031 oracle 10G release 2 solaris

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Wed, 19 Oct 2005 22:32:02 +0200
Message-ID: <4356ad42$0$4321$ba620e4c@news.skynet.be>

<evoradba_at_yahoo.ca> wrote in message
news:1129681348.178203.221240_at_g49g2000cwa.googlegroups.com...
>
> Today I installed oracle 10g R2 on solaris 5.8, created the schema etc
> then when trying to import from a dmp, or even acessign the database I
> keep getting
> ORA-00604: error occurred at recursive SQL level 1
> ORA-04031: unable to allocate 4120 bytes of shared memory ("shared
> pool","select /*+ rule */ bucket_cn...","Typecheck","kgghteInit")
>
> This is the sga
>
> Total System Global Area 171966464 bytes
> Fixed Size 1977208 bytes
> Variable Size 113251464 bytes
> Database Buffers 50331648 bytes
> Redo Buffers 6406144 bytes
>
>
> I dont know what to do HELP
>

Have you tried increasing the shared pool size ? Received on Wed Oct 19 2005 - 15:32:02 CDT