Re: LGWR, EMC or app cursors?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 11 Oct 2019 14:40:14 -0400
Message-ID: <ee356a34-45dc-11c7-23ec-e30fcc55f3b9_at_gmail.com>
Date: Fri, 11 Oct 2019 14:40:14 -0400
Message-ID: <ee356a34-45dc-11c7-23ec-e30fcc55f3b9_at_gmail.com>
And it is possible to set so called Haqqani factor by using "minimize records_per_block". That number can make a difference for the optimizer. Jonathan was writing about that long time ago.
On 10/11/19 10:55 AM, Mark W. Farnham wrote:
>
> Apart from any i/o issue, you CAN at least put the rows into different
> blocks and avoid the gcc block contention.
>
> You won’t miss the extra 2 blocks.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 11 2019 - 20:40:14 CEST