Sapna Malik
What is a deadlock?
By Sapna Malik in Databases & DBA on Jun 03 2011
  • Ashish Srivastava
    Jul, 2016 8

    Deadlock is situation in which two process waiting for resources that is using by other process but any process not release it's resources

    • 1
  • RAHUL SHUKLA
    Jul, 2015 31

    A dead lock is a situation where an application looks up because two or more activities are waiting for each other to finish. This occur in multhithreading software where a shared resource is loked by one thread and another thread is waiting to access it and something occurs so that the thread holding the locked item is waiting fo the other thread to excute.

    • 1
  • Pankaj  Kumar Choudhary
    Jun, 2015 16

    Deadlock is situation in which two process waiting for resources that is using by other process but any process not release it's resources

    • 1
  • Rahul Prajapat
    May, 2015 27

    A deadlock is a situation in which two computer programs sharing the same resource are effectively preventing each other from accessing the resource, resulting

    • 1
  • Alok Gupta
    Dec, 2014 15

    A deadlock is a situation wherein two transactions wait for each other to give up their respective locks.

    • 1
  • Vinod Verma
    May, 2013 30

    Deadlock: A condition where two or more threads are waiting for an event that can only be generated by these same threads.

    • 1
  • Rajendra  Singh
    Sep, 2012 25

    A deadlock is a situation in which two computer programs sharing the same resource are effectively preventing each other from accessing the resource, resulting

    • 1
  • Abhinav Sood
    Jul, 2012 10

    DeadLock EgProgram P1 has holds resource R1 and requires resource R2 to finish the process. Program P2 has holds resource R2 and requires resource R1 to finish the process.

    • 1
  • Santosh Kumar
    Jun, 2011 9

    A deadlock is a situation in which two computer programs sharing the same resource are effectively preventing each other from accessing the resource, resulting in both programs ceasing to function. The earliest computer operating systems ran only one program at a time. All of the resources of the system were available to this one program. Later, operating systems ran multiple programs at once, interleaving them. Programs were required to specify in advance what resources they needed so thatthey could avoid conflicts with other programs running at the same time. Eventually some operating systems offered dynamic allocation of resources. Programs could request further allocations of resources after they had begun running. This led to the problem of the deadlock.

    • 1
  • Sapna Malik
    Jun, 2011 3

    Two processes waiting to update the rows of a table which are locked by the other process then deadlock arises. In a database environment this will often happen because of not issuing proper row lock commands. Poor design of front-end application may cause this situation and the performance of server will reduce drastically. These locks will be released automatically when a commit/rollback operation performed or any one of this processes being killed externally.

    • 1
  • Jignesh Kumar
    Jun, 2018 18

    Deadlock occurs when two or more processes are waiting for on the same resource and waiting to complete on the other process to complete before moving forward.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS