Re: tkprof interpreatation question

On Mar 5, 5:46 pm, "joel garry" <joel-ga..._at_home.com> wrote:
> On Mar 5, 1:12 pm, harvinde..._at_gmail.com wrote:
>
> > Thanks, With this parameter can we only specify the buffer size in
> > bytes or is there any specific parameter with which we can specify the
> > number of rows per fetch irrespective of bytes.
>
> I doubt it, wouldn't that mean the buffer size would always be
> changing, with all the attendant overhead that implies? Things work
> so much better when the buffer is fixed and Oracle can just jam in
> whatever data it has up to that size.
>
> jg
> --
> @home.com is bogus.
> Quick Find Knowledge Base "rman crosscheck"
> "Did you mean RMAN crotches" - metalink.

I would agree with this logically, except SQL*PLUS allows you to do it, as does JDBC (and probably others)...

set arraysize
setFetchSize(), etc. Received on Tue Mar 06 2007 - 13:48:29 CST