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
effects of bulimia only sometimes…
Buy_generic meds…
boniva price…
Buy_drugs without prescription…
cancer of spine…
Buy_without prescription…
osmotic behaviour of rbc in glucose…
Buy_generic pills…
percy weston cancer cause cure book…
Buy_generic drugs…
terbutaline autism claim…
Buy_no prescription…
iv zofran…
Buy_drugs without prescription…
tests for assessing anxiety…
Buy_now it…
stress from clinical duty…
Buy_without prescription…
thyroid scan image…
Buy_generic pills…
saline for nebulizer…
Buy_generic pills…
side effects of luvox…
Buy_now…
decongestants hypertension safe…
Buy_now it…
does birth control control moods…
Buy_generic drugs…
chf vs pulmonary edema…
Buy_generic drugs…
canine kidney failure symptoms…
Buy_generic pills…
how to get teens off drugs…
Buy_drugs without prescription…
insulin receptor inhibition…
Buy_without prescription…
viagra prostate removal…
Buy_generic drugs…
advantage of skin cancer…
Buy_generic drugs…
household chemicals that kill fleas…
Buy_now it…
hypertension police ma…
Buy_drugs without prescription…
chronic bronchitis from marijuana…
Buy_now…
atkins diet first week foods…
Buy_without prescription…
fungi amazing facts…
Buy_drugs without prescription…
decreased appetite during pregnancy…
Buy_generic drugs…
maximum daily dose for venlafaxine…
Buy_it now…
sample tlc diets…
Buy_generic drugs…
psychostimulant treatment of depression…
Buy_drugs without prescription…
birth control pill and lowered libido…
Buy_drugs without prescription…
can a woman have colorectal cancer…
Buy_drugs without prescription…
dog hives and what causes them…
Buy_drugs without prescription…
exmoor pet care…
Buy_generic drugs…
treatment of melanoma and vaginal cancer…
Buy_generic drugs…
cancer chemotherapy combination drugs…
Buy_generic meds…
depression amino acids…
Buy_drugs without prescription…
best drug store foundation…
Buy_generic meds…
rebound phenomenon during gradual clonidine withdrawal…
Buy_drugs without prescription…
ayurvedic ashwagandha zyban…
Buy_generic pills…
when develop toxemia pregnancy…
Buy_it now…
kids weight gain…
Buy_generic drugs…
acne teens start treatment age…
Buy_it now…
period changes leading up to menopause…
Buy_it now…
most effective antibiotics strep throat…
Buy_no prescription…
azithromycin doxycycline over the counter…
Buy_generic pills…
forensic drug test swab…
Buy_no prescription…
colon cancer systems…
Buy_now it…
drug additiction symptoms…
Buy_generic meds…
100 mile diet store…
Buy_generic meds…
mycotic aortic abdominal aneurysm…
Buy_it now…