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
What is schema

Give the limitations of SQL authorization. The code for checking authorization becomes intermixed with the rest of the application code. Implementing authorization by applic

WHY SHOULD NULL IN A RELATION BE AVOID AS possible?

OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the

construct an er diagram for a hospital with a set of patients and a set of medical doctors. associate with each patient a log of various test and examination conducted.convert er d

Describe the term- State Diagram State Diagram: An object could receive a sequence of the input instructions. The state of the object can differ depending upon sequence of in

Hi there, Have an issue with my Database. I have: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit Whenever I add data into the Form, it will update the table as expect

Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c

Which product produces the relation that has attributes of R1 and R2 ? Cartesian product produce the relation which has attributes of R1 and R2

What is aggregate function? Briefly describe it? Aggregate functions are functions that take a collection of values as input and return a one value. SQL offers 5 built-in aggre