One of our jobs in ledger service that runs inside a stored procedure seems to be locked up, the job normally completes in 1/2hr and is still running for 6 1/2hrs. We need a DBA to look into what is causing the lock.
Begin PRC_UPDATE_LEDGER_BALANCE; End;
Begin PRC_CALC_LGR_ACCT_TOTAL; End;
The session that is running these procedures has been killed at the DB level
begin
[login to view URL](
sid => 46,
serial => 6283);
end;
ORA-00031: session marked for kill
ORA-06512: at "RDSADMIN.RDSADMIN_UTIL", line 91
___
The job hung again even after killing^
Hi.
I am read your description carefully.
I have skills in MySQL, Oracle and etc.
I think I can help you.
Kind regards!
------------------------------------------------