Home » RDBMS Server » Server Administration » ora-04031
ora-04031 [message #217398] Fri, 02 February 2007 00:50 Go to next message
jayarago
Messages: 12
Registered: December 2006
Location: Chennai
Junior Member
hi,


i am using oracle9i and solaris 8 ..

if i connect to the DB i am receiving the error as

ora-04031

ui tried to increse the shared pool size to more than 8m.
but its not possible...

my shared_pool_size is 8m.


so how to resolve this issue...


please reply me the earliest...

Re: ora-04031 [message #217435 is a reply to message #217398] Fri, 02 February 2007 03:20 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Are you sure it's your SHARED_POOL that's too small? Also, why can't you increase it?

$ oerr ora 04031
04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\",\"%s\")"
// *Cause:  More shared memory is needed than was allocated in the shared
//          pool.
// *Action: If the shared pool is out of memory, either use the
//          dbms_shared_pool package to pin large packages,
//          reduce your use of shared memory, or increase the amount of
//          available shared memory by increasing the value of the
//          INIT.ORA parameters "shared_pool_reserved_size" and
//          "shared_pool_size".
//          If the large pool is out of memory, increase the INIT.ORA
//          parameter "large_pool_size".

Re: ora-04031 [message #217436 is a reply to message #217435] Fri, 02 February 2007 03:25 Go to previous messageGo to next message
jayarago
Messages: 12
Registered: December 2006
Location: Chennai
Junior Member
Hi,

If i give shared_pool_size=10m after shutdown the DB if i startup means it shows error as


out of memory

then i removed the shared_pool_size from the init file then give startup means its working..
but after sometime my user is getting error

as ora-04031


please tell me the solution along with the query...
Re: ora-04031 [message #217591 is a reply to message #217436] Fri, 02 February 2007 22:44 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
what is your RMAN size on your system.
ui tried to increse the shared pool size to more than 8m. ?

you have to increase shared pool size.


reagrds
Taj
Previous Topic: ORA-02049
Next Topic: applying patch
Goto Forum:
  


Current Time: Fri Sep 20 05:27:27 CDT 2024