Join v$session, v$lock and v$sqltext : sqltext « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. sqltext

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>
SQL>