RE: identify CTAS from v$ tables
- From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
- To: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
- Date: Tue, 25 Apr 2006 09:56:44 -0700 (PDT)
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
Other related posts:
