Re: autotrace format right margin truncated

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@xxxxxxxxxxxxx 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 -----------------------------------------------------------------

Other related posts: