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^

Taidot: Oracle, SQL, Tietokantaohjelmointi, Tietokannan hallinto

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Minneapolis, United States

Projektin tunnus: #20448443

Myönnetty käyttäjälle:


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 5 päivässä
(0 Arvostelua)

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

$50 USD 1 päivässä
(2 arvostelua)

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 1 päivässä
(2 arvostelua)