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 -- //www.freelists.org/webpage/oracle-l