In Progress

Oracle objects deadlock problem

INTRODUCTION

We are looking for a consultant who can help us on solving a problem we are having with an Oracle database that is the data repository of one of the systems we develop.

As part of the development lifecycle, we run a batch of integration tests that execute our system's read/write operations targeting an Oracle database. This step should be triggered automatically during our continuous integration process, but we haven't been able to do so yet because at some point the test batch freezes completely.

Although we believe the problem is related to database object deadlocking, unfortunately we haven't been able to diagnose its cause because it happens randomly. So every time we run the test batch, a different operation may lock an Oracle object and we need to manually kill its session in order to let the tests complete. Also, there are times when it runs successfully.

Lastly, we believe the problem may not be restricted to the Oracle object domain. Our system is a .NET application which employs the Oracle's official [url removed, login to view] API to handle the communication with the database and perhaps the way it is implemented may have a connection to the problem.

OBJECTIVES

We expect you to perform the following activities:

- Reproduce de error by running our system's integration test batch (we will provide guidance on how to do this)

- Analyse the Oracle objects and our system's [url removed, login to view] data layer source code

- Provide scripts and/or detailed instruction to solve the problem in a definite and scalable manner

- Test your solution beforehand

- Be easily available for communication and provide constant feedback

ACCEPTANCE CRITERIA

We will consider this project finished when:

- We understand and agree with the proposed solution

- Scripts and/or detailed information to implement the solution are provided

- We manage to run our integration test batch a couple successful times after the solution is implemented

SCHEDULE

We expect you to start working immediately and provide estimates of how long you will take. We understand there's still a lot of uncertainty, so you can provide an initial estimate and refine it when the problem becomes clearer.

When you finish implementing the solution, we will need 2 business days to run and monitor our tests.

ADDITIONAL INFORMATION

- The Oracle version is 10g

- The [url removed, login to view] version is 11.2.0.2 ([url removed, login to view])

- The OS is Windows 7 Enterprise SP1 x64

- The problem was diagnosed in multiple instances

- An instance is exclusively mounted for running the test batch

- We will provide remote access to a machine properly configured

- We will be constantly available to provide assistance when needed

If you need further information, please ask.

Skills: Database Administration, Oracle, SQL

See more: deadlock oracle, sql database consultant, sql code oracle, part problem, develop database access, dotnet x64, consultant business development, business object development, business object consultant, administration system business, access database consultant, working oracle, oracle data integration, business process consultant, write sql project, systems administration consultant, process consultant, oracle net, oracle data, oracle consultant, oracle business, oracle administration, enterprise solution, deadlock, database administration development

About the Employer:
( 4 reviews ) Recife, Brazil

Project ID: #5011267

13 freelancers are bidding on average $1886 for this job

nibiranijum

Hi, I am database expert. Did lots of projects like this. I can do your work properly. Please check my profile and let's talk on this. Rgds Shafiq

$255 USD in 5 days
(14 Reviews)
4.8
elboukharimu

Hi, I'm very interested helping you resolving your Oracle problem, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some More

$300 USD in 7 days
(18 Reviews)
4.7
bmartynvw

I'm an experienced Oracle/.Net developer, having worked with these technologies for 17 years. I can analyze this and give you a solution.

$247 USD in 12 days
(6 Reviews)
4.3
sorinteo

With more than 15 years experience in the IT industry, 13 of which I have spent particularly on Database Administration, together with being 8i, 9i, 10g, 11g Certified Professional and Tunning & RAC Certified Expert, More

$20000 USD in 30 days
(1 Review)
3.6
kamosion

Hello! I'm Oracle DB Admin and Programmer. I know a lot of tools for detect deadlocks etc. Also i had experience with huge banks DB system. (you can see that in my profile). Do not hesitate to ask any questions.

$250 USD in 3 days
(2 Reviews)
3.3
suraj99p

I am database expert and have been working with Oracle for last 4years. I am very good in diagnosing database bottlenecks.

$200 USD in 3 days
(3 Reviews)
2.8
fabiosantiago

I am an OCP professional with five years of experience with Oracle 10g. I don't have experience with .NET, but I worked with other languages and frameworks. This is not a problem to me. According with you wrote, it's More

$155 USD in 3 days
(2 Reviews)
1.4
simonlsk

My extensive knowledge and experience when associated with Oracle gives me an edge. Apart from my work experience i kind of associate to the deadlock problem as i have had issues on it with triggers and have raised se More

$205 USD in 3 days
(0 Reviews)
0.0
lakhad

Hi, I am a DBA by profession for 12 years and been in I.T. industry for 19 years. For your problem I can help you. If you provide all the necessary information and remote connection. Regards, Ana

$250 USD in 21 days
(0 Reviews)
0.0
erkapilkgupta007

I am having a good exposure in Oracle with Asp.Net and also having a vast experience in analysing the problem and providing the resolution with in time for which I have received number of awards.

$277 USD in 30 days
(0 Reviews)
0.0
gintaraske

I like solving this kind of puzzles. If it turns out I cannot handle it after connecting to your test environment I let you know in couple of hours.

$266 USD in 4 days
(0 Reviews)
0.0
defeaterman

I am very reliable in work i always finish my work on time with fast completion .My skills is convenient to this kind of job and i am ready to work immediately.

$277 USD in 15 days
(0 Reviews)
0.0
MiTejTechn

About the Company – Founded in 2007 • MiTej Technologies is founded by highly experienced software professionals. • It is an offshore IT design, development and service provider company based in India. • We have be More

$1833 USD in 15 days
(0 Reviews)
0.0