Re: identify CTAS from v$ tables

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/

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 25 2006 - 13:53:08 CDT