Re: autotrace format right margin truncated

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Fri, 11 Jun 2004 10:51:09 -0600
Message-id: <40C9E2FD.8090906@sun.com>

Barb,

You need to adjust the column settings for plan_plus_exp. It is set to a60 by default. I have it set (in login.sql) to 100 along with a linesize of 132. BTW, you don't need to change the long* settings for autotrace. The output is not a long.

Regards,
Daniel

Barbara Baker wrote:
> Ok, this is more an annoyance than a "real" problem,
> but I sure would be delighted if someone knows how to
> fix this.
>
> When I turn autotrace on, I want my lines to NOT wrap.
> (Too difficult to read otherwise.) If I set wrap
> off, then indeed my lines do not wrap, but the cost,
> cardinality, etc. get chomped on the right-hand side.
> I did a "show all" in sqlplus, and cannot find
> anything to change. Examples below.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jun 11 2004 - 11:48:11 CDT