Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> tkprof registering CTAS Explain Plan on 9.2

tkprof registering CTAS Explain Plan on 9.2

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Tue, 18 Jun 2002 17:35:13 +0100
Message-ID: <5jJP8.2007$vB.13893@news.indigo.ie>


Just trying tkprof on 9.2
That new waits summary is excellent.

However a select will produce an explain plan in tkprof output but a CTAS on top of the same select won't

( I pushed it over to CTAS since I wanted to remove the effects of the SQL*NET waits )

Is this a known thing ? Received on Tue Jun 18 2002 - 11:35:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US