Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC define lock escalation
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Nagendran
define lock escalation
3 Answer(s)      2 years and 5 months ago
Posted in : JDBC


define lock escalation


Advertisement
View Answers

May 9, 2012 at 4:54 PM


A lock escalation occurs when the number of locks held on rows and tables in the database equals the percentage of the lock list specified by the maxlocks database configuration parameter. Lock escalation is the process of converting a lot of low level locks (like row locks, page locks) into higher level locks (like table locks) to reduce the number of locks.



May 9, 2012 at 7:16 PM


The title of your questions must be bit descriptive otherwise it's difficult for other user's to judge what your question is all about and that also reduce the chances to get answer quickly. So, please write a correct and descriptive title for your questions. ADMIN



September 11, 2013 at 2:50 AM


Lock escalation occurs when there are many locks at a particular level in the database and they are escalated to a higher level. Example: many locks at the row level, this is just escalated to one bigger lock on the entire table.



Related Tutorials/Questions & Answers:
Java lock
Java lock  Can a lock be acquired on a class
Java lock
Java lock  Can a lock be acquired on a class
Advertisements
lock on a class
lock on a class  hello, Can a lock be acquired on a class?   hiii,, Yes, a lock can be acquired on a class. This lock is acquired on the class's Class object
difference between lock and synchronization
difference between lock and synchronization  Hi, I am new in java please anyone tell me difference between lock and synchronization in java. its urgent. Thank in advance   Please visit the following link: Lock
Java lock file or folder.
Java lock file or folder.  Is it possible to create a desktop application to lock or encrypt file or folder in windows by using java code?? if possible can provide some reference?? because i can't find it... thanks
Java thread lock
Java thread lock  What happens when a thread cannot acquire a lock on an object
Java object's lock
Java object's lock  What is an object's lock and which object's have locks
Java file lock
Java file lock In this section, you will learn how to lock a file. The behavior of the file lock is platform-dependent. The file lock is advisory on some platforms, means unless an application checks for a file lock
Define HibernateTemplate?
Define HibernateTemplate?  Hi, Define HibernateTemplate? Thanks
Define stack
Define stack  hii, Explain stack
Define please!?!
Define please!?!  What is tree map sort
define a constant.
define a constant.  How do you define a constant?   Hi, With the help of define() directive, you can create constant in php. And here is how: <?php define('NAME', 'Bharat'); ?> Thanks
What is an object's lock and which object's have locks?
What is an object's lock and which object's have locks?   Hi, What is an object's lock and which object's have locks? Thanks
Define Simulation
Define Simulation  hello,, Explain Simulation?   hii, Simulation is the process of forming an abstract model from a real situation in order to understand the impact of modifications and the effect of introducing
Define stack
Define stack  hii, Explain stack?   hello, Stack is an ordered list in which all the insertions and deletions made at one end called top of the stack. It is referred as LIFO list. Last inserted item is deleted First
Define hiberanate
Define hiberanate  What is Hibernate?   Hibernate is a pure java ORM (object-relational mapping) and persistence framework that allows you to map POJO (Plain Old Java Obiect) to relational database tablea using(XML
php define variable
php define variable  How to define a simple and a global variable in PHP
php define array
php define array  How to define array in PHP
define string variable in php
define string variable in php  how to define string variable in PHP
define a constant in php
define a constant in php   hii, How do you define a constant in php?   hello, we can define a constant in php like this define ("CONST", 50
Lock while inserting/updating database in multithreaded.
Lock while inserting/updating database in multithreaded.  Hi, I am having a multithreaded process which replicates the data from many table to one table. My process runs on 4 threads and all are having different connection
Define computer software.
Define computer software.  How to define a computer software?   A computer software is a set of instruction that tell the computer what to do
user define exception programs
user define exception programs  user define exception programs   Please visit the following links: http://www.roseindia.net/java/java-exception/user-defined-exception.shtml http://www.roseindia.net/java/exceptions
Define float in Java
Define float in Java  Hi, What is the correct method to define... JavaFloatExample { /* Learn How to define and use float variable in Java...); } } Thanks  public class JavaFloatExample { /* Learn How to define
How to make one waiting thread for lock - Java Beginners
can i force or acquire another thread for lock . Finally how to know thread is released from lock. Explain types of lock(like method level and block level
objective c define float
objective c define float  Hi, How to define float variable in objective c? Thanks   Hi, Here is the example of defining float variable. float i; i=10; Thanks   Hi, Here is another example: // File
Define Tag:
Define Tag:       bean:define Tag - is used to define a scripting variable based on the value(s) of the specified bean... as null. bean:define Tag can't be used  to instantiate a DynaActionForm
When will you define a method as static?
When will you define a method as static?  Hi, When will you define a method as static? thanks
How do you define a constant?
How do you define a constant?  How do you define a constant in php
How to define a constant variable in Java?
How to define a constant variable in Java?   Hi, How to define a constant variable in Java? thanks   HI, The Constants variables are declared using the final keyword. The values of the constant can't be changed
Define the session factory interface in hibernate?
Define the session factory interface in hibernate?  Define the session factory interface in hibernate?   Session factory is used for manageing the session objects.public interface SessionFactory extends Referenceable
Advertisements
 

 

 

DMCA.com