Re: set autotrace on -- execution plan wraps

<Christopher.Jones_at_oracle.comX> wrote in message news:uy9aqmoc2.fsf_at_oracle.comX...
> "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?
>
> 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

Wow, Chris, thanks for the useful reply. I really appreciate it.

--steve Received on Thu Aug 29 2002 - 19:07:55 CEST