RE: identify CTAS from v$ tables
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: "Joseph Amalraj" <joseph@xxxxxxxxxxxxxx>
- Date: Tue, 25 Apr 2006 18:47:54 +0200
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
Other related posts:
