Online Presentation Creator | Create Survey | Create Quiz | Create Lead-form Get access to 1,00,000+ PowerPoint Templates (For SlideServe Users) - Browse Now
Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
DML Locks PowerPoint Presentation
share
play prev play next
play fullscreen
1 / 13

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