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