krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 20th, 2008

 

When you are performing INSERT , DELETE , UPDATE operations on a table it implicity aquires row level locks.  If a transaction obtains a row lock for a row, the transaction also aquires a table lock for the corresponding table to prevent conflicting DDL operations.

Table level locks are  implicitly aquired when you perfoming DDL operations.

You may explicity aquire
row level lock using select for update of
and table level lock using lock table.