Issue: APP-FND-01388: Cannot
read value for profile option FND_MGR_STRTUP_THRES_TIME in routine
&ROUTINE.
Routine FDPCRQ
encountered an ORACLE error. ORA-04031: unable to
allocate 32 bytes of
shared memory ("shared pool".
Review your error
messages for the cause of the error. (=<POINTER>)
Solution:
If
the database parameter named _memory_broker_stat_interval has not been
explicitely set to a value of 999 as per solution #3 of note 'Common Cause for
ORA-4031 in 10gR2, Excess "KGH: NO ACCESS" Memory Allocation [Video]'
(Doc ID 801787.1) then I would start with solution #3to see if that change
alone is enough to avoid further ORA-04031 errors (especially if the failed
allocation requests are for 32 bytes).
ALTER SYSTEM SET "_memory_broker_stat_interval"=999 SCOPE=SPFILE;
Then the instance would need to be restarted for the change to take effect.
ALTER SYSTEM SET "_memory_broker_stat_interval"=999 SCOPE=SPFILE;
Then the instance would need to be restarted for the change to take effect.
No comments:
Post a Comment