I gang

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.



The session that is running these procedures has been killed at the DB level


[login to view URL](

sid => 46,

serial => 6283);


ORA-00031: session marked for kill

ORA-06512: at "RDSADMIN.RDSADMIN_UTIL", line 91


The job hung again even after killing^

Evner: Oracle, SQL, Programmering af database, Database Administration

Se mere: sql stored procedure return table, sql xml stored procedure, return info stored procedure tsql, stored procedure dump phpmyadmin, windows applications create stored procedure page, sql database schema stored procedure, xml path stored procedure, sql stored procedure check expiry date, update stored procedure, t_sql stored procedure, stored procedure convert function, convert sql stored procedure oracle stored procedure, create stored procedure sap biztalk, convert stored procedure oracle procedure, stored procedure xml output net, stored procedure sql 2005, mssql stored procedure send mail

Om arbejdsgiveren:
( 0 bedømmelser ) Minneapolis, United States

Projekt ID: #20448443

Tildelt til:


Hi. I am read your description carefully. I have skills in MySQL, Oracle and etc. I think I can help you. Kind regards! ------------------------------------------------

$20 USD in 5 dage
(0 bedømmelser)

3 freelancere byder i gennemsnit $33 på dette job


Hi, nice to meet you. I am mathematician and database analysis expert. I have experience of similar your project. I used Python Pandas to analysis business. My skill is Python, Mysql, Postgresql, deep mathematician kn Flere

$50 USD på 1 dag
(2 bedømmelser)

Hi, I am a Senior DBA with more than 15 years experience in Oracle. I can help you in determine session lock. Regards.

$30 USD på 1 dag
(2 bedømmelser)