Hi Joseph,

The cursor for CTAS cannot be shared, and last time I looked, it was
located in the PGA, where it is not visible to any other session. You
can however attach to that session using oradebug and get it to dump
what it is doing to a trace file.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all


Joseph Amalraj wrote:
> 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