ora-04031 [message #217398] |
Fri, 02 February 2007 00:50 |
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 |
Frank Naude
Messages: 4587 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 |
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 |
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
|
|
|