Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tkprof interpreatation question

Re: tkprof interpreatation question

From: joel garry <joel-garry_at_home.com>
Date: 5 Mar 2007 14:46:20 -0800
Message-ID: <1173134780.854141.89940@t69g2000cwt.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US