Oracle objects deadlock problem

Budget $30 - $250 USD
Bids 14
Average Bid $1758
Status Closed


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.


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


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


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.


- The Oracle version is 10g

- The [url removed, login to view] version is ([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.

Get Free Quotes For A Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • MiTejTechn Profile Picture


    Pune,  India

    MiTej Technologies is a Software Development Company providing IT services to companies all across the globe. Our goal is to provide Excellent Offshore and Onsite Software Services to all our clients. We have been around for more than 6 years. Technological Expertise: • Microsoft .Net, C#, SQL Server • Java, PHP, MySQl • BI Tools - MS , Oracle, Informatica • Amazon APIs, Cloud computing. Services Offered By Us: • Customised Development of Software. • Studying and automating any processes within your company. • Integrating your existing databases and processes to Websites or Intranet. • Integrating your business with E-Commerce - Business-to-Business and/or Business-to- Customer. • Design and Developing Management Information Systems. • Design and Develop Decision Support Systems based on existing data. • Design and Develop Customised Systems. • Custom IT Solutions & Services. We also provide resources to other IT companies. Featured Benefits to customers: • Reduced costs of IT and other processes. • Successful execution of IT projects through experience. • Advantage of technical expertise - both onsite/offsite. • Maintenance of software systems and applications.

  • defeaterman Profile Picture


    cairo,  Egypt

    Organized Person

  • smshafiqulislam Profile Picture


    Dhaka,  Bangladesh

    Summary: # Information Technology graduate (CGPA 3.9/4.0) with overall 7+ years of experience in design/development of IT systems. # Oracle Certified Developer and Database Administrator having in depth knowledge in oracle with more than 8 years working experience. #Enterprise level solution provider #Experienced IT Project Manager for enterprise solution SKILLS SUMMARY =============== TECHNICAL SKILLS: 7+ years experience in Information Technology field #Languages: Oracle Developer 6i, Developer 2000, 9i Forms & Reports, 10g Forms & Reports, Jdeveloper, , Java,C#.Net # Database: Oracle 8i , Oracle 9i, Oracle 10g, Oracle 11g, Mysql, Sql Server # Business Process Re-engineering Expertise Field: # Database: Oracle databases (both in Windows and Linux) # Languages: Developer 6i,, D2K, J2EE # Server configuration in Linux environment WEB DEVELOPMENT SKILLS: # HTML, DHTML # J2EE, JSP, JSF, STURTS, HIBERNATE # PHP Project Management: #SMC (Scrum Master Certified) #PMP (course)

  • kamosion Profile Picture


    Moscow,  Russian Federation

    01.2007 - Freelance Experience 07.2006 - 12.2006 Insurance Company \"MAKS\" System Architect Formation of architectural requirements to development CIS on Oracle DB. Designing and support data model of CIS. Designing of interaction interfaces with external sources of data. Technical management of programmers. Modification of UNICUS system. 02.2006 - 06.2006 - Freelance Development by contract basis. 01.2006 - 02.2006 National Bank of Azerbaijan Analyst/Oracle Developer Realization of denomination in Azerbaijan by contract basis. 01.2005 - 12.2005 BANKING PRODUCTION CENTER Technical Analyst «Banking systems» (FNS) Interaction with solution developer  FNS (Financial Network Services), Australia. FNS BANCS system integration with external systems (processing system SmartVista) and ABS Colvir banking system. Works within ABS localization for Russia. Preparation of demo test benches using Virtual PC technologies for system work with MS SQL and ORACLE. Design and development of Russian language translating system Design of tasks of system profiling. 07.2003 - 12.2004 Info Industries Group Team Leader. Oracle,Delphi,C#. Team Leader of development group Development and support of Retail system Petrobank F for MDM bank Petrobank F system integration with processing system OpenWay Development of transport level for exchange messages system CarryLine2 Development of Oracle Reports 02.2003 - 07.2003 CORVUS INTERNATIONAL LLC Head of development group Team Leader of development group. Targets set up. Control of meeting deadlines. Participation in ABS Corvus-Bank design and development. 06.2002 - 02.2003 CORVUS INTERNATIONAL LLC Senior Programmer Design and development of modules Audit and event notifications for Oracle database, Currency Control , Salary Participated in development of other ABS Corvus Bank modules (Human Resourses, Cash operations etc.) Development of database Oracle Audit module and other changes users notification with the help of RPO (Remote Python Object) 05.1999 - 06.2002 CORVUS INTERNATIONAL LLC Programmer Development of clients forms and various component on Delphi Design and development of server part for Oracle database 7.i,8.i Edit Additional info citizenships Russia work tickets in: Russia Languages Russian : Native Language english: enough for interview Keywords: ORACLE 8i,9i, SQL, PL/SQL. Oracle Reports. Oracle Forms. MS SQL Server; Delphi,Python,C#, VB.NET, C/C++, MS Visual C++, Java, Assembler, Haskell, SML. Administration and work with Rational ClearCase. Case facilities: Erwin/BpWin; Design and development of Oracle database scheme. Big experience in optimization of SQL. Audit of changes/requests of Oracle database 8i/9i. Create system of automatic generation XML documents from any DB using ADO and XML document template. (DbData2Xml). Good knowledge of internal architecture Delphi. Realization of dynamic development of classes on Delphi. Development of components and experts in Delphi. Decompiling programs, extract information from executable files and secure db (for example Footbal Manager Database and etc), Extracting Flash (SWF) objects from executable SWF Studio files.

  • sorinteo Profile Picture


    Bucharest,  Romania

    With more than 16 years experience in the IT industry, 13 of which have been specifically working with Oracle databases, together with being 11g, 10g, 9i and 8i Oracle Certified Professional, RAC & Tuning Certified Expert and Oracle Certified Master, I can provide solutions to any RDBMS-related business requirements, troubleshooting, deployments and any short to long term solutions/workarounds, based on business needs.

  • gintaraske Profile Picture


    Bubiu sen.,  Lithuania

    I am ready to be hired by you for the post of Oracle Programmer. I have all the skills and experience that makes me a competitive candidate for this post. I have had an ideal prospect and am ready to accept any new challenges that may be put in front of me. If given an opportunity to work for your company I will fulfil the given work with utmost dedication and loyalty. I have many years experience working as a MySQL Developer and Oracle Programmer. I am ready to start working for you today.

  • erkapilkgupta007 Profile Picture


    Delhi,  India

    I am ready to start work on your Oracle Projects. I have earned many years experience working as a Oracle PL/SQL Developer. I am confident that my experience and my qualification will make your company to earn a sound customer base.

  • bmartynvw Profile Picture


    Chennai,  India

    Consultant with wide exposure. Domain exposure includes Banking, Retail, Manufacturing. Over 17 years of experience. Top client: Standard Chartered Bank Technologies Skilled in: OS: Windows Server, Linux(most flavors), Unix, Solaris & AS400 DB: Oracle, SQL Server, MySQL, Sybase & DB2 Scripting with Shell script, PowerShell, VBScript, AutoIt Development stacks: LAMP/WAMP J2EE .Net Win32 Oracle Fusion, Apex & PL/SQL Virtualization: Desktop: Citrix, Remote Desktop, X11SSH Server: VMware,Hyper-V, Para/Cloud: Azure, AWS,Xen,UML OS: Solaris Zones, Virtuzzo VOIP: Asterisk, Kamailio

  • lakhad Profile Picture


    Singapore,  Philippines

    I've been in I.T. industry more or less 19 years and more than 10 years in database administrator field. Skills set are in Oracle and experience/knowledgeable of sybase, db2 and adabas (mainframe). Environment is in different flavor of unix (e.g. aix, linux, hp, solaris) and windows.

  • fabiosantiago Profile Picture


    Fortaleza,  Brazil

    I'm a Python developer with experience.