locking up inside a stored procedure- DBA/RDS

$10-30 USD

Closed

Posted

over 4 years ago

$10-30 USD

Paid on delivery

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^

SQL

Oracle

Database Administration

Database Programming

Amazon Web Services

Project ID: 20449378

About the project

6 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

6 freelancers are bidding on average $55 USD for this job

@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 DBA in Oracle, MySQL, SQLServer, PostgreSQL. -- 8 years of hands-on experience in Cloud Services - AWS (RDS, EC2, S3) and Azure. -- 3+ years of hands-on experience as DB Chief Architect in a SaaSOps organization. Skill Set : Oracle, MySQL, MSSQL, PostgreSQL, MongoDB, Aurora, RMAN, Streams, DataGuard, OSB, RAC, ASM, OCFS, GoldenGate, SSIS, AWS EC2, RDS, S3, Cloudfront, CloudWatch, Azure, SalesForce, Unix, Linux, Windows, VMWare, Bash Scripting, PL/SQL, TSQL, AlwaysOn, TDE, APEX, Bash Shell Scripting. ITIL-certified. 24x7 On-call support and issue-resolution. Please check out my profile for more information on my competencies and work experience. Thanks for your time, and I look forward to working with you. Have a good day! Regards, Christina

$25 USD in 2 days

0.0

(0 reviews)

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 you a solution. We will be happy to assist you with this bug.

$30 USD in 2 days