SQL>
SQL> SELECT b.username, b.serial#, d.id1, a.sql_text
2 FROM v$session b, v$lock d, v$sqltext a
3 WHERE b.lockwait = d.kaddr
4 and rownum < 2
5 AND a.address = b.sql_address
6 AND a.hash_value = b.sql_hash_value;
no rows selected
SQL>