1 / 13

DML Locks

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. Oracle's Default Locking Strategy - Implicit Locking:.

alicecummings
Download Presentation

DML Locks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related