System Statistics and Calibrate IO
- From: Kellyn Pot'vin <kellyn.potvin@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Dec 2011 16:15:02 -0800 (PST)
I'm looking for some *extra* info before I pull my hair out on this one, folks!
I'm managing and performing an 11g upgrade project and today, there was concern
raised about me adding the dbms_resource_manager.calibrate_io run instead of
gather_system_stats in a database build process. Over the last couple years
reading here and there, I had come to believe that calibrate_IO was something
of a replacement for gather_system_stats, but after research today, I'm not so
sure about that!
I have the basics down and am quite comfortable with the technical specs of the
new calibrate IO feature, but still feel there may very well be some great
value to gathering system stats, (This is for a mart build, is run once with a
sufficient work load produced on the system at the initial build time, never
again for the life of the datamart...)
Can someone tell me why I would want to run one over the other, run both or
where I'm missing some data here?
Thanks!
Kellyn Pot'Vin
Sr. Database Administrator and Developer
DBAKevlar.com
--
http://www.freelists.org/webpage/oracle-l
Other related posts: