Shared lock or read lock, Database Management System

Shared lock or Read Lock

  • It is requested by a transaction that needs to just read the value of data item.
  • A shared lock on a data item does not permit an exclusive lock to be placed but allows any number of shared locks to be placed on that item.

 

Posted Date: 3/12/2013 2:37:42 AM | Location : United States







Related Discussions:- Shared lock or read lock, Assignment Help, Ask Question on Shared lock or read lock, Get Answer, Expert's Help, Shared lock or read lock Discussions

Write discussion on Shared lock or read lock
Your posts are moderated
Related Questions
Deadlock Prevention One of the easiest approaches for avoiding a deadlock would be to obtain all the locks at the begin of the transaction. Though, this approach restricts conc

example of embedded SQL query

Explain concept of inheritance with support of suitable example. Inheritance Inheritance is one of milestone of object-oriented programming language as it allows a creati

Preliminary entities and attributes of human resourse management database management system

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

what benefit can a company gain by managing its own infrasture and services

What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur

Parallelism of transaction execution: A transaction can be divided into various sub-queries that can operate on fragments in parallel. This enhances the degree of concurrency in t


What is SQL Profiler? SQL Profiler is a graphical tool that permits system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save dat