Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-4031 oracle 10G release 2 solaris

ORA-4031 oracle 10G release 2 solaris

From: <evoradba_at_yahoo.ca>
Date: 18 Oct 2005 17:22:28 -0700
Message-ID: <1129681348.178203.221240@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 Received on Tue Oct 18 2005 - 19:22:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US