RE: system stats and db_file_multi_block_read_count
- From: Neil Chandler <neil_chandler@xxxxxxxxxxx>
- To: <hrishys@xxxxxxxxxxx>, Oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 13 Aug 2011 15:44:23 +0100
That depends upon your requirements. I would start with it not set and
see if it fits your requirements. It will then implicitly set the value
to the highest possible for your I/O system - probably 128. However,
that is NOT the same as setting 128 explicitly. If reasonable for your
system, use the defaults.
Be careful when collecting system stats, given the global change that it
makes. You also need to think carefully about when to gather the stats
depending upon the workload going through the system - during OLTP?
Batch? Data Loading? They may all give different answers.
You should also consider gathering system stats with the same level of
change control that you apply to your application code, and test the
stats in UAT before applying to Production.
regards
Neil Chandler
Date: Sat, 13 Aug 2011 04:16:45 +0100
From: hrishys@xxxxxxxxxxx
Subject: system stats and db_file_multi_block_read_count
To: oracle-l@xxxxxxxxxxxxx
Hi
Do i need to set the value for db_file_multi_block_read_count explicitly if we
collect system stats manually on 10g ?
regards
Other related posts:
