Hi
when we receive and IFS build spec it mentions that the SGA/PGA value should be set as a standard. We believe this is set in the Oracle template. One of our customers had an issue where IFS crashed out. After checking the Oracle logs I could see the below error:
</msg>
<msg time='2021-05-28T10:36:42.289+01:00' org_id='oracle' comp_id='rdbms'
client_id='DESKTOP-GN5SK69-WIA-CONSOLE-8040' type='UNKNOWN' level='16'
host_id='IFSPR0DDB' host_addr='fe80::e1e8:57d1:e76c:9814%7' module='DBMS_SCHEDULER'
pid='6528' con_uid='1' con_id='1'
con_name='CDB$ROOT'>
<txt>Errors in file E:\APP\ORACLE\diag\rdbms\ifspcdb\ifspcdb\trace\ifspcdb_j004_6528.trc:
ORA-04031: unable to allocate 32808 bytes of shared memory ("shared pool","FND_EVENT_ACTION_API","PLMCD^563f5f87","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called: "IFSAPP.FND_EVENT_ACTION_API"
ORA-06512: at "IFSAPP.EVENT_SYS", line 117
ORA-06512: at "IFSAPP.EVENT_SYS", line 117
ORA-06512: at "IFSAPP.BACKGROUND_JABS_FAIL_EVU", line 19
ORA-04088: error during execution of trigger 'IFSAPP.BACKGROUND_JABS_FAIL_EVU'
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 593
ORA-06512: at "IFSAPP.BATCH_SYS", line 1946
ORA-04031: unable to allocate 32792 bytes of shared memory ("shared pool","UPDATE TRANSACTION_SYS_LOCAL...","SQLA^5c7b331e","pdy3M63_Finish_Page_Table: Copy data seg")
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1093
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 921
ORA-04031: unable to allocate 32808 bytes of shared memory ("shared pool","FND_EVENT_ACTION_API","PLMCD^563f5f87","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called: "IFSAPP.FND_EVEN
</txt>
</msg>
I have spoken to our dba guys and they believe that the SGA/PGA was explicitly set to 4GB when the RAM allowed upto 40GB.
My question is should IFS provide this value for each customer instance that we build? Also how is this value calculated? Can it be added to the sizing guide?
Regards
Gary