Re: identify CTAS from v$ tables

From: "Terry Sutton" <terrysutton@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 25 Apr 2006 11:53:08 -0700

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/

References:
- identify CTAS from v$ tables
  - From: Joseph Amalraj

Re: identify CTAS from v$ tables

Other related posts: