Home » RDBMS Server » Performance Tuning » oracle10g
oracle10g [message #65921] Tue, 01 February 2005 02:11 Go to next message
Messages: 86
Registered: August 2000
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 Go to previous message
Frank Naude
Messages: 4566
Registered: April 1998
Senior Member

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.

Previous Topic: Temporary tablespace growing very fast
Next Topic: please help me interpret this tkprof
Goto Forum:

Current Time: Sun Jan 17 12:56:53 CST 2021