RE: identify CTAS from v$ tables

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

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

Other related posts: