hussasha

 Profile Answers by hussasha 

• Mar 17th, 2009

 

Locking protect table when several users are accessing the same table.
Locking is a concurrency control technique in Oracle. It helps in data integrity
while allowing maximum concurrency access to data. Oracle offers automatic
locking whenever situation requires. This is called implicit locking.

Types of Locking

Shared Lock: This type is placed on a record when the record is being viewed.
Exclusive Lock: This is placed when Insert, Update or Delete command is
performed. There can be only one exclusive lock on a record at a time.

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

Exclusive Lock: This is placed when Insert, Update or Delete command is performed. There can be only one exclusive lock on a record at a time.