Lock

From: "Paul Harrison" <cure@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Sat, 10 Mar 2012 10:56:49 -0600

Hello,
 

I have a table with four rows. I issue the sql statement: update table set
name = 'test';  this will update 4 rows. Will Oracle create 4 locks one for
each row or 1 lock for the 4 rows?

 

Thanks,

Paul



--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: Lock
  - From: Guillermo Alan Bort
- Re: Lock
  - From: Toon Koppelaars
- RE: Lock
  - From: Taylor, Chris David
- Re: Lock
  - From: Jonathan Lewis

Other related posts:

» Lock - Paul Harrison
» Re: Lock- Guillermo Alan Bort
» Re: Lock- Toon Koppelaars
» Re: Lock- Andy Klock
» RE: Lock- Mercadante, Thomas F (LABOR)
» RE: Lock- Taylor, Chris David
» RE: Lock- Taylor, Chris David
» Re: Lock- Jonathan Lewis