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-02080: database link is in use

1 Answers  


ORA-13509: error encountered during updates to a SWRF table

1 Answers  


ORA-02246: missing EVENTS text

1 Answers  


ORA-07205: slgtd: time error, unable to obtain time.

1 Answers  


NNL-00900: NO SUCH NAME responses sent: number

1 Answers  






TNS-12666: Dedicated server: outbound transport protocol different from inbound

1 Answers  


ORA-12619: TNS:unable to grant requested service

1 Answers  


ORA-34487: (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.

1 Answers  


ORA-23396: database link "string" does not exist or has not been scheduled

1 Answers  


ORA-21614: constraint violation for attribute number [string]

1 Answers  


QSM-01124: set operator materialized view, string, doesn't have a marker column

1 Answers  


ORA-36280: (XSCGMDLAGG08) The dimension of valueset workspace object is not in the dimension list of the current compiling model.

1 Answers  


Categories