Lukket

locking up inside a stored procedure- DBA/RDS

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^

Evner: SQL, Oracle, Database Administration, Programmering af database, Amazon Web Services

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: #20449378

7 freelancere byder i gennemsnit $51 på dette job

pinesucceed01

Dear Hiring Manager, Thank you for this wonderful opportunity. Today your job posting has caught my attention and I’m keenly considering your job post including these skills. I have excellent experience in Website De Flere

$20 USD in 7 dage
(1 bedømmelse)
3.2
inforafeesoft

Hi sir I'm a [login to view URL] Engineer and Database Administrator and System Administrator Also Network Administrator I'm expert in Database (Oracle,My SQL,MS SQL,Azure,AWS,Mongo Db,Postgre DB,MagentoSQlite ...etc), Java, Flere

$30 USD på 1 dag
(0 bedømmelser)
0.0
cvisperas

Hi, I'd like to work with you on this project. I am ready to start at once. I have been working for more than 15 years as an Oracle DBA. Below are some of my qualifications: -- 15+ years of hands-on experience as Flere

$25 USD in 2 dage
(0 bedømmelser)
0.0
ntaservices

Hi, Our team has a lot of experience with stored procedures. We have worked with fortune 200 companies to help solve locks like you are mentioning. We will be able to find the issue in a short amount of time and give Flere

$30 USD in 2 dage
(0 bedømmelser)
0.0
JBHassan1

Hi, Can help you if you share the procedure definition. Your current sharing does not clear what is the problem. Regards,

$20 USD på 1 dag
(0 bedømmelser)
0.0
DACUY

Hi, we need access to see the source of store procedure and run it over console. Our price is not by hour, is for the work.

$200 USD på 1 dag
(0 bedømmelser)
0.0
shahidyaseen

Hi, i am a certified oracle DBA with 10 years of experience in diployment administrators backup and recovery disaster recovery and performance tuning. I can work on your project. Please send me a message. Please see a Flere

$35 USD på 1 dag
(0 bedømmelser)
0.0