| oracle10g [message #65921] |
Tue, 01 February 2005 02:11  |
Vishal
Messages: 86
Registered: August 2000
|
Member |
|
|
Hi i have problem on oracle 10g.
My software is working very slow.
First we are using oracle 8i, and now we are shifted the database from 8i to 10g.
it gives me error
ORA-04031 unable to allocate nn bytes of shared memory.
Why this is happening.?
whats changes should i have to made from shifting database oracle 8i to 10g.
|
|
|
|
| Re: oracle10g [message #65922 is a reply to message #65921] |
Tue, 01 February 2005 03:56  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Please post the complete error message:
$ 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".
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
