Re: identify CTAS from v$ tables - CTAS not among top SQL
- From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 28 Apr 2006 18:00:59 -0700 (PDT)
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@xxxxxxxxxxxx> 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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Re: identify CTAS from v$ tables - CTAS not among top SQL
