Re: no exec

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 3 Jun 2001 22:20:07 +0100
Message-ID: <991689435.8046.0.nnrp-08.9e984b29@news.demon.co.uk>

If you type

columns
from SQL*Plus, you will see that there are several column definitions for the execution plan that have been set by your glogin.sql, e.g.

plan_plus_exp format a47

You can change these to suit your linewidth and preferences for display. For parallel and distributed queries it also helps to

set long 20000

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Yong Huang wrote in message ...


>I think he wants something like SET AUTOTRACE TRACEONLY EXPLAIN. Once

>you have the EXPLAIN appended, you get the execution plan without

>actually executing the query, just like you EXPLAIN PLAN FOR...

>followed by SELECT ... FROM PLAN_TABLE..CONNECT BY. The only annoyance

>is that the output after you SET AUTOTRACE TRACEONLY EXPLAIN is always

>70 characters wide even if you SET LINESIZE to a big number.

>

>Yong Huang

>yong321_at_yahoo.com

>

Received on Sun Jun 03 2001 - 16:20:07 CDT