Monday, March 18, 2019

EBS OPP Tunning



Select current value

select DEVELOPER_PARAMETERS from FND_CP_SERVICES
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');




Update OPP tunning

update FND_CP_SERVICES
set DEVELOPER_PARAMETERS = 'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');



Restart OPP Concurrent program

go to -> Concurrent Manager -> Search for Optput post processor -> Deactivate it (wait for 5 min) -> Activate it back

#Search for the OS Process and kill it if neded
ps -ef | grep OPP
ls -lrt $APPLCSF/$APPLLOG/FNDOPP*

Azure AKS - Diag Logs - KQL

AzureDiagnostics | where Category == "kube-audit" | summarize requests = count() by bin(TimeGenerated, 5m), userAgent_s | orde...