Explain growing phase of locking, Database Management System

Explain Growing Phase of locking

Growing Phase: In this phase the transaction can only obtain locks, but cannot release any lock. The transaction enters the growing phase as soon as it obtains the first lock it wants. From now on it has no option but to keep acquiring all the locks it would require. Ultimately the transaction reaches a point where all the lock it may require has been acquired. This point is known as Lock Point.

 

Posted Date: 7/26/2013 7:09:24 AM | Location : United States







Related Discussions:- Explain growing phase of locking, Assignment Help, Ask Question on Explain growing phase of locking, Get Answer, Expert's Help, Explain growing phase of locking Discussions

Write discussion on Explain growing phase of locking
Your posts are moderated
Related Questions
, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created

FDs in Entities : Student entity :                                                Enrolment number →  Student name, Address Course Entity :

The C_Artist  application will be developed using the C language (C99 standards) and will be able to compile without warnings and link and run in the Swinburne computer laboratorie

The definition of the classes and operation can often be adjusted to increase the amount of inheritance". Justify the above statement.   Adjustment of Inheritance The def

Although how will the system recover The selection of REDO or UNDO for a transaction for the recovery is completed on the basis of the state of the transactions. This state is


Produce a set of relations (equivalent to the Finkelstein entity list) in third normal form (3NF) from the following un-normalised relation. You must use the Finkelstein methodolog

Durability : This property necessitates that once a transaction has committed, the changes made by it be never lost because of subsequent failure. Thus, a transaction is also a bas

what is the need of a log in dbms

What is the main difference between read-only and update methods? A read-only method does not affect the values of a variable in an object, whereas an update method may alter t