Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
DML Locks PowerPoint Presentation

DML Locks

3 Views Download Presentation
Download Presentation

DML Locks

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. DML Locks • DML locks are locks placed by Oracle to protect data in tables and indexes. • Whenever a DML statement seeks to modify data in a table, Oracle automatically places a row-level lock on the rows in the table that are being modified.

  2. Oracle's Default Locking Strategy - Implicit Locking: • Since the Oracle engine has a Fully automatic locking strategy, it has to decide on two issues: • Type of Lock to be applied • Level of Lock to be applied