autotrace format right margin truncated

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Fri, 11 Jun 2004 09:34:53 -0700 (PDT)
Message-ID: <20040611163453.63881.qmail@web50607.mail.yahoo.com>

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.

(I'm not sure that the example will format, but in the "wrap off" example, the line truncates after 70 characters.)

Virtual beer to anyone who can help.
thanks!
Barb

oracle 9.2.0.4, solaris 9

10:20:08 SQL> SET ECHO ON
10:20:08 SQL> set array 1
10:20:08 SQL> set wrap off
10:20:08 SQL> set long 5000
10:20:08 SQL> set longchucksize 500
10:20:08 SQL> set linesize 200
10:20:08 SQL> SET AUTOTRACE TRACEONLY EXPLAIN

Execution Plan

0 SELECT STATEMENT Optimizer=CHOOSE (Cost=33 Card=1 Bytes=233)

1 0 SORT (ORDER BY) (Cost=33 Card=1 Bytes=233)

   2    1     NESTED LOOPS (Cost=30 Card=1 Bytes=233)
   3    2       NESTED LOOPS (Cost=29 Card=1
Bytes=206)
   4    3         NESTED LOOPS (Cost=28 Card=1
Bytes=199)
   5    4           VIEW OF 'VW_NSO_1' (Cost=27 Card=1
Bytes=26)
   6    5             MINUS
   7    6               SORT (UNIQUE)
   8    7                 INDEX (FULL SCAN) OF


'I_ADCHG1' (UNIQUE) (Co

   9    6               SORT (UNIQUE)
  10    9                 TABLE ACCESS (FULL) OF


'WFSTRACKER' (Cost=10

  11    4           TABLE ACCESS (BY INDEX ROWID) OF


'ADSCHANGED' (Cos

  12   11             INDEX (UNIQUE SCAN) OF


'I_ADCHG1' (UNIQUE) (Cost

  13    3         TABLE ACCESS (BY INDEX ROWID) OF


'SALESPERSON' (Cost

  14   13           INDEX (UNIQUE SCAN) OF 'I_SPE1'
(UNIQUE)
  15    2       TABLE ACCESS (BY INDEX ROWID) OF


'CUSTOMER' (Cost=2 Ca

  16   15         INDEX (UNIQUE SCAN) OF 'I_CUS1'

(UNIQUE) set wrap on

Execution Plan

0 SELECT STATEMENT Optimizer=CHOOSE (Cost=33 Card=1 Bytes=233)

1 0 SORT (ORDER BY) (Cost=33 Card=1 Bytes=233)

   2    1     NESTED LOOPS (Cost=30 Card=1 Bytes=233)
   3    2       NESTED LOOPS (Cost=29 Card=1
Bytes=206)
   4    3         NESTED LOOPS (Cost=28 Card=1
Bytes=199)
   5    4           VIEW OF 'VW_NSO_1' (Cost=27 Card=1
Bytes=26)
   6    5             MINUS
   7    6               SORT (UNIQUE)
   8    7                 INDEX (FULL SCAN) OF


'I_ADCHG1' (UNIQUE) (Co

          st=1 Card=1 Bytes=26)

   9    6               SORT (UNIQUE)
  10    9                 TABLE ACCESS (FULL) OF


'WFSTRACKER' (Cost=10

           Card=2015 Bytes=48360)

  11    4           TABLE ACCESS (BY INDEX ROWID) OF


'ADSCHANGED' (Cos

          t=2 Card=1 Bytes=173)

  12   11             INDEX (UNIQUE SCAN) OF


'I_ADCHG1' (UNIQUE) (Cost

          =1 Card=1)

  13    3         TABLE ACCESS (BY INDEX ROWID) OF


'SALESPERSON' (Cost

          =2 Card=1 Bytes=7)

  14   13           INDEX (UNIQUE SCAN) OF 'I_SPE1'
(UNIQUE)
  15    2       TABLE ACCESS (BY INDEX ROWID) OF


'CUSTOMER' (Cost=2 Ca

          rd=1 Bytes=27)

  16   15         INDEX (UNIQUE SCAN) OF 'I_CUS1'

(UNIQUE)

Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/

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:31:36 CDT