we have run a billing process ( generatePnR) which usually takes 1 to 1.5 hr, but same script which was run yesterday at around 16:40 and was still running next morning.
I have generated the AWR report but cannot find any issue. Do you suggest tuning at database level?
This is a custom script (java). I don't know what for it is coded to do and how it is coded to do that.
What I can suggest you is;
Trace the apps tier process in the apps server and trace the db session of this script in the db.
You need to investigate the issue by tracing your custom program and finding where it is waiting and for what it is waiting.
Check with a java developer. You can even use online java decompilers to see the code and understand the resources (both apps tier & db tier) that your program needs.
As for the db side, check the current wait of the db session and check the highest wait of the db session.
Locked
