Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: tkprof interpreatation question
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.Received on Mon Mar 05 2007 - 16:46:20 CST
![]() |
![]() |