Re: Annoying SQLPLUS Problem

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 01 Dec 2002 13:03:45 +0100
Message-ID: <sjujuucsrrhjs2fnsjq3snuj7ocq978voo@4ax.com>

On Sun, 01 Dec 2002 11:59:25 GMT, "Buck Turgidson" <jc_va_at_hotmail.com> 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)
>

You could try
set linesize 132
On some platforms the linewidt of your tty session might be already 132

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Dec 01 2002 - 06:03:45 CST