APP-FND-01388

APP-FND-01388:
=============

Error:
=====
 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.
  • July 11, 2017 | 21 views
  • Comments