Find Jobs
Hire Freelancers

locking up inside a stored procedure- DBA/RDS

$10-30 USD

Mbyllur
Postuar over 4 years ago

$10-30 USD

Paguhet në dorëzim
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^
ID e Projektit: 20449378

Rreth projektit

6 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
6 freelancers are bidding on average $55 USD for this job
Avatari i Përdoruesit
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 në 2 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
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 në 2 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hi, Can help you if you share the procedure definition. Your current sharing does not clear what is the problem. Regards,
$20 USD në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
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 në 1 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED STATES
Aurora, United States
5,0
1
Mënyra e pagesës u verifikua
Anëtar që nga korr 16, 2019

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.