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 -> Re: Annoying SQLPLUS Problem

Re: Annoying SQLPLUS Problem

From: Shafeek Khalidh <itsprobablyme_at_msn.com>
Date: Mon, 2 Dec 2002 15:10:36 +0530
Message-ID: <asf9nn$qkuu5$1@ID-137434.news.dfncis.de>


Hi

I tried LINESIZE and I'm getting the result in a formated way. But when I'm running large queries after this LINESIZE setting, I used to get a memory error and it will close the sqlplusw.

I feel formatting the colum will be another option

Shafeek Khalidh

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:sjujuucsrrhjs2fnsjq3snuj7ocq978voo_at_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 Mon Dec 02 2002 - 03:40:36 CST

Original text of this message

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