Re: Annoying SQLPLUS Problem

From: Svend Jensen <Svend_SPAMKILL_at_OracleCare.Com>
Date: Sun, 01 Dec 2002 13:14:17 +0100
Message-ID: <3DE9FD19.3090602@OracleCare.Com>

Buck Turgidson wrote:
> 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)
>
>

Try
set linesize 132.

modify/create a login.sql containing what is needed.

/svend Received on Sun Dec 01 2002 - 06:14:17 CST