System Statistics and Calibrate IO
From: Kellyn Pot'vin <kellyn.potvin_at_ymail.com>
Date: Fri, 2 Dec 2011 16:15:02 -0800 (PST)
Message-ID: <1322871302.94242.YahooMailNeo_at_web121020.mail.ne1.yahoo.com>
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!
Date: Fri, 2 Dec 2011 16:15:02 -0800 (PST)
Message-ID: <1322871302.94242.YahooMailNeo_at_web121020.mail.ne1.yahoo.com>
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-lReceived on Fri Dec 02 2011 - 18:15:02 CST