RE: identify CTAS from v$ tables

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

--
http://www.freelists.org/webpage/oracle-l


Other related posts: