Which user has obtained the Lock ???

Hi,
When I query using the command

select * from foo where id = 100 for update nowait;

Does this statement try to obtain a table level lock or row level lock.

Also If I am unable to obtain the lock using the above statement how do i find out which d/b user, o/s user and session has obtained the lock.

Thanks in Advance for your help

Anurag

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 09 2000 - 18:02:36 CST