locking up inside a stored procedure- DBA/RDS

$10-30 USD

Avslutat

Publicerad

nästan fem år sedan

$10-30 USD

Betalning vid leverans

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

Om projektet

6 anbud

Distansprojekt

Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

6 frilansar lägger i genomsnitt anbud på $55 USD för detta uppdrag

@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 Om 2 dagar

0,0

(0 omdömen)

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 Om 2 dagar