Oracle objects deadlock problem

IN PROGRESS
Bids
13
Avg Bid (USD)
$1886
Project Budget (USD)
$30 - $250

Project Description:
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 ODP.NET 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 ODP.NET 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 ODP.NET version is 11.2.0.2 (http://www.oracle.com/technetwork/topics/dotnet/index-085163.html)
- 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 required:
Database Administration, Oracle, SQL
Hire comercialsuati
Project posted by:
comercialsuati Brazil
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 255
in 5 days
$ 300
in 7 days
$ 247
in 12 days
Hire sorinteo
$ 20000
in 30 days
$ 250
in 3 days
Hire suraj99p
$ 200
in 3 days
$ 155
in 3 days
Hire MiTejTechn
$ 1833
in 15 days
$ 277
in 15 days
Hire erkapilkgupta007
$ 277
in 30 days