Re: LGWR, EMC or app cursors?
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 11 Oct 2019 14:40:14 -0400
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.
Other related posts:
- » LGWR, EMC or app cursors?- Herring, David
- » RE: LGWR, EMC or app cursors?- Noveljic Nenad
- » Re: LGWR, EMC or app cursors?- Chris Taylor
- » RE: LGWR, EMC or app cursors?- Noveljic Nenad
- » RE: LGWR, EMC or app cursors?- Herring, David
- » RE: LGWR, EMC or app cursors?- Noveljic Nenad
- » RE: LGWR, EMC or app cursors?- Herring, David
- » Re: LGWR, EMC or app cursors?- Harel Safra
- » Re: LGWR, EMC or app cursors?- Andy Sayer
- » Re: LGWR, EMC or app cursors?- Mladen Gogala
- » Re: LGWR, EMC or app cursors?- Martin Berger
- » RE: LGWR, EMC or app cursors?- Herring, David
- » RE: LGWR, EMC or app cursors?- Tiwari, Yogesh
- » Re: LGWR, EMC or app cursors?- Ls Cheng
- » RE: LGWR, EMC or app cursors?- Herring, David
- » RE: LGWR, EMC or app cursors?- Herring, David
- » Re: LGWR, EMC or app cursors?- Andy Sayer
- » RE: LGWR, EMC or app cursors?- Herring, David
- » RE: LGWR, EMC or app cursors?- Mark W. Farnham
- » Re: LGWR, EMC or app cursors? - Mladen Gogala
- » RE: LGWR, EMC or app cursors?- Mark W. Farnham
- » Re: LGWR, EMC or app cursors?- Ls Cheng
- » Re: LGWR, EMC or app cursors?- Andy Sayer
- » RE: LGWR, EMC or app cursors?- Noveljic Nenad
- » RE: LGWR, EMC or app cursors?- Herring, David
- » RE: LGWR, EMC or app cursors?- Herring, David
- » Re: LGWR, EMC or app cursors?- Jared Still