Re: identify CTAS from v$ tables - CTAS not among top SQL

Hi All,    

  So this means, that in the statspack reports, CTAS is not listed among the top SQL statements even if it could have been one on the top sql statements !!!        

  Regards    

  Joseph

Steve Adams <steve.adams_at_ixora.com.au> wrote:   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




--
http://www.freelists.org/webpage/oracle-l