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

DRG-11817: Proxy Redirect

1 Answers  


ORA-25455: evaluation error for rule set: string.string, evaluation context: string.string

1 Answers  


TNS-00287: Min Connect Time (secs) : number

1 Answers  


RMAN-06436: enter DROP CATALOG command again to confirm catalog removal

1 Answers  


ORA-12915: Cannot alter dictionary managed tablespace to read write

1 Answers  






ORA-06268: NETNTT: cannot read /etc/oratab

1 Answers  


ORA-09714: Two Task interface: cannot obtain puname

1 Answers  


PCC-02426: Incompatible LOB types

1 Answers  


ORA-28515: cannot get external object definitions from string

1 Answers  


ORA-06707: TLI Driver: connection failed

1 Answers  


ORA-12169: TNS:Net service name given as connect identifier is too long

1 Answers   Reliance, Satyam,


QSM-02131: agg(expr) requires correspondng SUM(expr) function

1 Answers  


Categories