Comment embedded...
Alex Filonov wrote:
> "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.
>
Someone might have set a "column format" on the column somewhere (eg,
global sql ini file). Type "show all" or "column" to see if that column
is set for word-wrap.
>
>>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 - 15:04:00 CST