If you know what session you're looking for, what's wrong with what Paul suggested? select sql_text from v$sqltext t1, v$session t2 where t2.sid = &sid and t1.address = t2.sql_address order by t1.piece; If you don't know what session may be doing it, try select hash_value, sql_text from v$sqltext where upper(sql_text) like upper('%create%table%'); Then look at v$session for the session with the corresponding sql_hash_value. --Terry Hi, Please let me know how to identify that a session is executing a Create Table As Select from v$ tables Thanks Joseph Amalraj For errors in "da vinci code" http://www.davincierrors.net/