Wednesday, June 12, 2013

APP-FND-01388: Cannot read value for profile option FND_MGR_STRTUP_THRES_TIME in routine &ROUTINE.

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.

No comments:

Post a Comment