Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Fri Oct 22 2004 - 18:08:47 CDT
![]() |
![]() |