Re: autotrace format right margin truncated
- From: Daniel Fink <Daniel.Fink@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 11 Jun 2004 10:51:09 -0600
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
-----------------------------------------------------------------
- Follow-Ups:
- Re: autotrace format right margin truncated
- From: Barbara Baker
- References:
- autotrace format right margin truncated
- From: Barbara Baker
Other related posts:
- » autotrace format right margin truncated
- » Re: autotrace format right margin truncated
- » Re: autotrace format right margin truncated
- » Re: autotrace format right margin truncated
- » Re: autotrace format right margin truncated
- » RE: autotrace format right margin truncated
- » Re: autotrace format right margin truncated
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 -----------------------------------------------------------------
- Re: autotrace format right margin truncated
- From: Barbara Baker
- autotrace format right margin truncated
- From: Barbara Baker