Still no luck 1 select sid, sql_text 2 from v$session a, v$sql b 3 where a.sql_address = b.address 4* and command = 1 sys@clfypurg> / no rows selected Dennis Williams <oracledba.williams@xxxxxxxxx> wrote: Joseph, How about: select sid, sql_text from v$session a, v$sql b where a.sql_address = b.address and command = 1 Dennis Williams