Re: Who selects FOR UPDATE?

Volker Hauswurz wrote:
>
> Once I read that you can get the information which user has a lock on a row
> when he SELECTs FOR UPDATE.
> But I forgot it and I can't find the system view or routine which gives me
> the information. Can anybody help me?
>
> Thanks
> Volker

Try the following

SQL> SELECT * FROM SYS.DBA_DML_LOCKS; You may want to check out the file that creates this view. $ORACLE_HOME/rdbms/admin/catblock.sql

Cheers

-- 
Naren