ORA-04031: unable to allocate string bytes of shared memory
("string","string","string","string")



ORA-04031: unable to allocate string bytes of shared memory ("string","string",..

Answer / guest

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".

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-01017: set|show current_listener [<listener_name>]: sets|shows current listener

1 Answers  


ORA-16191: Primary log shipping client not logged on standby

1 Answers  


PLS-00606: cursor subquery is not supported on client side in this release

1 Answers  


ORA-37003: (AWLISTALL01) number readers

1 Answers  


NNL-00002: request argument "string" is not allowed with this operation

1 Answers  






PLS-00390: undefined column 'string' in INSERT statement

1 Answers  


TNS-00136: Did not register product/facility for TNS error message

1 Answers  


LSX-00230: invalid integer "~S"

1 Answers  


ORA-22879: cannot use the LOB INDEX clause for partitioned tables

1 Answers  


LRM-00118: syntax error at 'string' at the end of input

1 Answers  


RMAN-08123: keep attributes for the datafile/controlfile copy are deleted

1 Answers  


ORA-25107: duplicate TABLESPACE option specification

1 Answers  


Categories