Re: set autotrace on -- execution plan wraps

[Quoted] "Steve Mitchell" <stevem_at_hdcsi.com> writes:

> When I examine the execution plan for a statement from SQL*Plus via "set
> autotrace on". SQL*Plus has the annoying habit of truncating or wrapping
> the output at 71 characters. It seems to ignore 'linewidth'. This makes it
> very difficult to read the execution plans for statements with many nested
> loops.
>
> Anybody know of a fix?

[Quoted] The SQL*Plus User's Guide and Reference gives the column names for the AUTOTRACE report. You can customize your own COLUMN commands to set widths within the upper limit of SET LINESIZE. See also glogin.sql which sets the default column widths.

The relevant documentation is at:

  http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a90842/ch9.htm#1006527

Chris

-- 
Christopher Jones, Oracle Corporation, Australia.