DBMS_STATS.GATHER_SYSTEM_STATS - learned something new
From: <Christopher.Taylor2_at_parallon.net>
Date: Fri, 12 Oct 2012 10:37:41 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856253296C_at_NADCWPMSGCMS10.hca.corpad.net>
Version 10.2.0.4
I see that when you have _NOT_ executed DBMS_STATS.GATHER_SYSTEM_STATS(gathering_mode=>'NOWORKLOAD') at least once, and you run a regular dbms_Stats.gather_system_stats(gathering_mode=>'INTERVAL',interval=>&some_amount_of_minutes), that Oracle does not update some of the SYSTEM STATS such as IOTFRSPEED.
Date: Fri, 12 Oct 2012 10:37:41 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856253296C_at_NADCWPMSGCMS10.hca.corpad.net>
Version 10.2.0.4
I see that when you have _NOT_ executed DBMS_STATS.GATHER_SYSTEM_STATS(gathering_mode=>'NOWORKLOAD') at least once, and you run a regular dbms_Stats.gather_system_stats(gathering_mode=>'INTERVAL',interval=>&some_amount_of_minutes), that Oracle does not update some of the SYSTEM STATS such as IOTFRSPEED.
IOTFRSPEED stayed at 4096 when using the regular gather. After using NOWORKLOAD it went to 38883.222, and then regathering stats using interval, it stays at 38883.222.
Weird.
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 12 2012 - 17:37:41 CEST