Cause: More shared memory is needed than was allocated in the shared pool.

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

Question Posted / guest

1 Answers
5284 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

ORA-26028: index string.string initially in unusable state

3848

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2216

ORA-26082: load of overlapping segments on table string.string is not allowed

1753

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2706

NZE-28890: Entrust Login Failed

1861

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1605

ORA-26094: stream format error: input column overflow

2785

ORA-26084: direct path context already finished

1937

ORA-26029: index string.string partition string initially in unusable state

2140

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2719

ORA-26076: cannot set or reset value after direct path structure is allocated

1950

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3138

ORA-26079: file "string" is not part of table string.string

1932

ORA-26032: index string.string loading aborted after string keys

2087

ORA-16626: failed to enable specified object

2200