locking up inside a stored procedure- DBA

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^