13. Understanding the Locking System : How the Locking System Works : Lock Requests
 
Share this page                  
Lock Requests
When either a statement or a command is issued, implicit requests for locks are made. The locking system also determines what mode and level of lock to take by considering the following factors:
Are there any locks available in the system?
Does the query involve reading or updating data?
What resources are affected by the query?
Are any other locks held on the affected resources?