Hi, The query does not return any output. DB version is 9.2.0.7 SQL> select sid from v$session where command = 1 2 / SID ---------- 28 SQL> select sql_text from v$sql where command_type = 1; no rows selected SQL> Regards Joseph Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote: Joseph >I need to know the sql being run by the session. This is another question ;-) Then use the following query: select sql_text from v$sql where command_type = 1 Be careful that SQL_TEXT is a VARCHAR2(1000). If the statement is longer you should use SQL_FULLTEXT which is a LOB (10g only). HTH Chris