This content has been marked as final. Show 2 replies
32bit or 64bit??
What's your initialization parameter?
SGA_MAX_SIZE, SGA_TARGET, shared_pool_size etc..
Hi, how do you told that restarted your SO, I I would talk to you execute the command "ALTER SYSTEM FLUSH SHARED_POOL;" but this is not apply. I looked in the utility Oerr and he presentation;
oracle> 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
// *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
// If the large pool is out of memory, increase the INIT.ORA
// parameter "large_pool_size".
Kind regards, Bruno Reis.