| ora-04031 [message #64645] |
Thu, 17 February 2005 16:35  |
Rashmi
Messages: 20
Registered: April 2001
|
Junior Member |
|
|
Hi,
We are using oracle 9i server on windows nt and support development team.I often encounter this error-
javax.transaction.SystemException: ORA-04031: unable to allocate 2196 bytes of
hared memory ("shared pool","SEQ$SYS","KGLS heap","KGLS MEM BLOCK")
Can anyone tell me what could be the reason .
Thanks
Rashmi
|
|
|
|
| Re: ora-04031 [message #109322 is a reply to message #64645] |
Wed, 23 February 2005 16:36  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
This is due to the size of memory not being availabe. check it.
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".
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
