Käynnissä

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^

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:

finaldragon123

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)
0.0

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

TopDesigner315

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)
2.3
adricabrelles

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)
1.4