RE: identify CTAS from v$ tables

From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
To: Christian.Antognini@xxxxxxxxxxxx
Date: Tue, 25 Apr 2006 09:31:39 -0700 (PDT)

Thanks for the quick reply.

  I need to know the sql being run by the session.

  Regards

  Joseph

Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote:
  Joseph

>Please let me know how to identify that a session is executing a
>Create Table As Select from v$ tables

If it's not a problem to get "regular" CREATE TABLE as well, you can use the 
following statement:

SELECT sid FROM v$session WHERE command = 1

HTH
Chris

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

References:
- RE: identify CTAS from v$ tables
  - From: Christian Antognini

RE: identify CTAS from v$ tables

Other related posts: