Re: *Very* high 'Fetch/elapse' cell in TKPROF report: cause ?

On 26 Aug 2004 04:59:05 -0700, spendius_at_muchomail.com (Spendius) wrote:

>Where do these pretty high fetch durations come from ? Where
>should we look ?
>
>Thanks.
>
>
>SQL> show sga
>Total System Global Area 1079217616 bytes
>Fixed Size 732624 bytes
>Variable Size 889192448 bytes
>Database Buffers 188743680 bytes
>Redo Buffers 548864 bytes
>
>Optimizer-related params values (the SAME as on the 8i version
>except for the block size):

The last line in what I quoted basically says it all. A different block size will be a *MAJOR* factor in performance differences, *especially* if all the other parms are identical, *including* the parameters where the unit is a *block*

--
Sybrand Bakker, Senior Oracle DBA