| ORA-04031 [message #137234] |
Wed, 14 September 2005 01:03  |
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
|
Senior Member |
|
|
Hi All,
Wile connecting to the oracle server we are getting ORA -04031 ERROR.
What may be the cause.
And how to handle this.
Regds
Dinesh
|
|
|
|
| Re: ORA-04031 [message #137243 is a reply to message #137234] |
Wed, 14 September 2005 01:34  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| Quote: |
ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
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 initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.
|
i found this on google.
http://www.google.co.in/search?hl=en&q=ORA-04031&btnG=Google+Search&meta=
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
