Re: DBMS output limmits
Date: Mon, 16 Nov 1998 00:52:55 GMT
Message-ID: <72npgj$s25$2_at_kraken.itc.gu.edu.au>
HiYa
Thanks :-)
In article <72hdmc$j6e$1_at_lore.csc.com>, "Richard Hull"
<rich_at_work_at_bigfoot.com> wrote:
>Hi Chris,
>
>My understanding is that the 1M dbms_output limit is server imposed. The
>padding of lines on output is an SQL*Plus behaviour which I do not think
>contributes to the 1M limit. BTW, this SQL*Plus behaviour can be changed
>with the SET TRIMOUT ON (and SET TRIMSPOOL ON). If you use these commands,
>you will notice that your output is produced significantly faster.
See Ya
(when bandwidth gets better ;-)
Chris Eastwood
Photographer, Programmer email ua.ude.ug.cti_at_doowtsae.c Motorcyclist and dingbat WWW http://chrise.itc.gu.edu.au
please remove undies for reply
Ohhh ... you work all day, slave over a hot stove all night yet you *still* have time for sadomasochism ... how do you do it?
A little man hurts me.
<ding>
Oh Mister Mean ... Oh Mister Mean
15 Minutes with him and you'll be blue and green
Studded belts and leather whips
Bondage trousers on his hips
Wack and punish as you dust with Mister Mean
Ohhhh he whips me around the house in minutes ... lets get cracking ...
Received on Mon Nov 16 1998 - 01:52:55 CET