System Stats

Hi All,

We have never generated System Stats.  I am wondering how important this is and how much of an impact this has on the performance of the database in general.

sys@lsilv1> SELECT /*+ NO_MERGE */

  2         *

  3    FROM sys.aux_stats$;

SNAME                          PNAME                               PVAL1

------------------------------ ------------------------------ ----------

PVAL2

----------------------------------------------------------------------------------------------------

SYSSTATS_INFO                  STATUS

COMPLETED

SYSSTATS_INFO                  DSTART

12-20-2012 15:05

SYSSTATS_INFO                  DSTOP

12-20-2012 15:05

SYSSTATS_INFO                  FLAGS                                   1

SYSSTATS_MAIN                  CPUSPEEDNW                     2257.77202

SYSSTATS_MAIN                  IOSEEKTIM                              10

SYSSTATS_MAIN                  IOTFRSPEED                           4096

SYSSTATS_MAIN                  SREADTIM

SYSSTATS_MAIN                  MREADTIM

SYSSTATS_MAIN                  CPUSPEED

SYSSTATS_MAIN                  MBRC

SYSSTATS_MAIN                  MAXTHR

SYSSTATS_MAIN                  SLAVETHR

I am interested in finding out if we need to generate stats using WORKLOAD (assume this is run during busy periods) and NOWORKLOAD (assume this can be run at quiet times) modes.