Re: Annoying SQLPLUS Problem

"Shafeek Khalidh" <itsprobablyme_at_msn.com> wrote in message news:<asf9nn$qkuu5$1_at_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.
>

Try to set ARRAYSIZE=1. There is a bug in some Windows sqlplus versions which causes it to fail with linesize > 80. ARRAYSIZE=1 sometimes helps. Or try to get a newer version of sqlplus.

> 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 - 14:22:03 CST