locking up inside a stored procedure- DBA/RDS

$10-30 USD

Ditutup

Dibuat

hampir 5 tahun yang lalu

$10-30 USD

Dibayar ketika dikirim

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

ID Proyek: 20449378

Tentang proyek

6 proposal

Proyek remot

Aktif 5 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

6 freelancer menawar dengan rata-rata $55 USD untuk pekerjaan ini

@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 dalam 2 hari

0,0

(0 ulasan)

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 dalam 2 hari