Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Annoying SQLPLUS Problem

Annoying SQLPLUS Problem

From: Buck Turgidson <jc_va_at_hotmail.com>
Date: Sun, 01 Dec 2002 11:59:25 GMT
Message-ID: <xQmG9.28236$oa.1238446@news1.east.cox.net>


How can I stop an explain plan from autotrace from wrapping? It doesn't on some platforms, but on my NT machine, it does:

Execution Plan


   0 SELECT STATEMENT Optimizer=CHOOSE (Cost=10 Card=1 Bytes=36)    1 0 PARTITION RANGE (ALL)
   2 1 TABLE ACCESS (BY LOCAL INDEX ROWID) OF 'M' (Cost=10 Card=1 Bytes=36)

   3 2 INDEX (RANGE SCAN) OF 'MOC_ANSWER_TIME_I' (NON-UNIQUE) (Cost=9
Card=1) Received on Sun Dec 01 2002 - 05:59:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US