db_file_multiblock_read_count parameter helps us controlling the numbers of blocks being brought up to the buffer cache in one I/O action. In older oracle releases, this parameter was usually set between 4 and 16 on OLTP environments and up to 64 on DWH environment.
Starting 10gR2, db_file_multiblock_read_count is being set automatically depends on your OS I/O size and buffer cache size.
What happens is that even when you tune your system by optimizing the multiblock parameter, when you then upgrade to 11g (Fresh installation) Oracle might set up the default to an irrelevant number. So, for instance, if you work on RAC OLTP based system, and your multiblock is set on 8 you should expect a change of this parameter with major performance degradation.
I recently visited a customer who suffered from some nasty waits on “gc buffer busy acquire” as well as other GC related wait events right after upgrading to 11g. Further investigation and a stress test validated the assumption that this is due to the change of the multiblock parameter (from 16 to 128).
The reason for this behavior is clear- since one node keeps a large amount of blocks in the buffer cache, and the second node tries to acquire access to the same blocks (intense OLTP operations) it will wait on cache fusion events.
So be conscious about it!
Ido
Principal Database Consultant
Here is a good example for REal Application Testing by recording the workload in the 10 Version (possible as of 10.2.0.4) and test run it on am 11g Testing system in oder to see what happens before you upgrade the life production system.
=;-)
BR,
Lutz
Hello! Please e-mail me your contacts. I have a question webmaster@bravto.ru” rel=”nofollow”>……
Thank you!!!…
Buy@Coral.Calcium.Online” rel=”nofollow”>……
Buygeneric pills…
Buy@Cheap.Coral.Calcium” rel=”nofollow”>……
Buywithout prescription…
Order@Coral.Calcium.Online” rel=”nofollow”>..…
Buygeneric pills…
Order@Cheap.Coral.Calcium” rel=”nofollow”>..…
Buygeneric pills…
Order@Discount.Coral.Calcium” rel=”nofollow”>..…
Buyno prescription…
Purchase@Coral.Calcium.Online” rel=”nofollow”>……
Buywithout prescription…
Purchase@Abana.Online” rel=”nofollow”>..…
Buydrugs without prescription…
Purchase@Cheap.Abana” rel=”nofollow”>……
Buygeneric pills…
Buy@Discount.Abilify” rel=”nofollow”>……
Buywithout prescription…
Order@Abilify.Online” rel=”nofollow”>.…
Buynow it…
Purchase@Cheap.Abilify” rel=”nofollow”>..…
Buynow it…
Purchase@Discount.Abilify” rel=”nofollow”>..…
Buyit now…
Cheap@Generic.Abilify” rel=”nofollow”>..…
Buygeneric drugs…
Order@Acai.Online” rel=”nofollow”>……
Buynow…
Order@Discount.Acai” rel=”nofollow”>……
Buywithout prescription…
Purchase@Acai.Online” rel=”nofollow”>……
Buynow…
Get@Acai.Online” rel=”nofollow”>……
Buygeneric drugs…
Buy@Generic.Acai” rel=”nofollow”>..…
Buywithout prescription…
Cheap@Acai.Without.Prescription” rel=”nofollow”>..…
Buygeneric meds…
Generic@Acai.500mg.Without.Prescription” rel=”nofollow”>..…
Buynow…
Buy@Coral.Calcium.Online” rel=”nofollow”>.…
Buygeneric drugs…
Order@Coral.Calcium.Online” rel=”nofollow”>..…
Buyno prescription…
Buy@Acai.Online” rel=”nofollow”>……
Buynow it…
Buy@Acai.Online” rel=”nofollow”>.…
Buyit now…
Buy@Discount.Coral.Calcium” rel=”nofollow”>.…
Buygeneric meds…
Cheap@Abilify.5mg.10mg.15mg.20mg.30mg” rel=”nofollow”>……
Buygeneric meds…
Cheap@Abilify.5mg.10mg.15mg.20mg.30mg” rel=”nofollow”>.…
Buygeneric drugs…
Buy@Acai.Online” rel=”nofollow”>..…
Buygeneric drugs…
Buy@Cheap.Acai” rel=”nofollow”>……
Buygeneric drugs…
where@can.i.purchase.max.acai” rel=”nofollow”>..…
Buynow it…
Buy@Cheap.Acai” rel=”nofollow”>……
Buygeneric drugs…
Buy@Cheap.Acai” rel=”nofollow”>..…
Buydrugs without prescription…
Buy@Discount.Acai” rel=”nofollow”>……
Buyit now…
Order@Cheap.Acai” rel=”nofollow”>……
Buyit now…
Cheap@Acai.Online” rel=”nofollow”>.…
Buygeneric meds…
Cheap@Acai.Online” rel=”nofollow”>..…
Buynow it…
Buy@Generic.Acai” rel=”nofollow”>..…
Buydrugs without prescription…
where@can.you.buy.acai.berry” rel=”nofollow”>..…
Buygeneric drugs…
Generic@Acai.500mg.Without.Prescription” rel=”nofollow”>.…
Buyno prescription…
Order@Discount.Energy.Boost” rel=”nofollow”>.…
Buynow it…
Purchase@Energy.Boost.Online” rel=”nofollow”>.…
Buygeneric drugs…
Cheap@Energy.Boost.Online” rel=”nofollow”>.…
Buynow it…
Get@Energy.Boost.Online” rel=”nofollow”>.…
Buygeneric pills…
Buy@Discount.Accupril” rel=”nofollow”>.…
Buyno prescription…
Order@Discount.Accutane” rel=”nofollow”>.…
Buyno prescription…
Get@Accutane.Online” rel=”nofollow”>.…
Buygeneric meds…
.…
Buygeneric drugs…
Buy@Generic.Aciphex” rel=”nofollow”>.…
Buygeneric meds…