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

ORA-13154: invalid precision specified

1 Answers  


ORA-38103: Invalid column in the UPDATE SET Clause: string

1 Answers  


RMAN-08585: copying standby controlfile

1 Answers  


RMAN-06179: datafile number not processed because file is read-only

1 Answers  


NZE-29025: Error found in certificate check callback.

1 Answers  


ORA-14024: number of partitions of LOCAL index must equal that of the underlying table

1 Answers  


ORA-01919: role 'string' does not exist

1 Answers  


KUP-04066: error initializing access to external table source

1 Answers  


ORA-29552: verification warning: string

1 Answers  


ORA-00287: specified change number string not found in thread string

1 Answers  


ORA-39143: dump file "string" may be an original export dump file

1 Answers  


CLSR-00501: Error number encountered when connecting to EVM daemon

1 Answers  


Categories