Hello Community, we have a stored procedure and scheduled every 15 mins. we are using Oracle scheduler "Scheduled Jobs" component to run the procedure.
The primary purpose for this procedure is just get the data from source tables (2 tables) & insert back to target table. The scheduler working fine from last 1 year and suddenly the scheduled job got halted means it running for ever and stuck at one single merge query.
I am new to this topics and how can I debug this type issues.