curious about gather system stats, or I'm wrong

Hi.

exec DBMS_STATS.GATHER_SYSTEM_STATS(gathering_mode=>'INTERVAL'
interval=>1/24); 
 Or this is a wrong way to get system statistics?, and is better to gather
system statistics only in the moment.
 
I found this interesting 
interval is not set in minutes as documentation says, it is in days, 
but the interesting is I can get system after the period (note the dstart
and dstop)
 
 
SYSSTATS_TEMP CPUCYCLES 2014908 
SYSSTATS_MAIN CPUSPEED 473 
SYSSTATS_TEMP CPUTIM 4261758 
 
SYSSTATS_INFO DSTART 10-22-2004 19:07 
SYSSTATS_INFO DSTOP 10-22-2004 20:07 
 
SYSSTATS_INFO FLAGS 0 
SYSSTATS_TEMP JOB 5 
SYSSTATS_MAIN MAXTHR 49981440 
SYSSTATS_TEMP MBLKRDS 162946 
SYSSTATS_TEMP MBLKRDTIM 413960 
SYSSTATS_MAIN MBRC -1 
SYSSTATS_TEMP MBRTOTAL 1373868 
SYSSTATS_MAIN MREADTIM -1 
SYSSTATS_TEMP SBLKRDS 75538 
SYSSTATS_TEMP SBLKRDTIM 525740 
SYSSTATS_MAIN SLAVETHR -1 
SYSSTATS_MAIN SREADTIM -1 
SYSSTATS_INFO STATUS AUTOGATHERING 
 
 
Juan Carlos Reyes Pacheco
OCP
--
http://www.freelists.org/webpage/oracle-l

Other related posts: