Re: identify CTAS from v$ tables

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