My Oracle Support Banner

Question on Application NO LOAD System Statistics (Doc ID 2453280.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal

Questions regarding application (NO LOAD) when generating system stats command dbms_stats.gather_system_stats.

Example of the application running (NO LOAD) sys.aux_stats$:

SQL> select sname, pname, pval1 from sys.aux_stats$;

SNAME PNAME PVAL1
------------------------------ ------------------------------ ----------
SYSSTATS_INFO STATUS
SYSSTATS_INFO DSTART
SYSSTATS_INFO DSTOP
SYSSTATS_INFO FLAGS 1
SYSSTATS_MAIN CPUSPEEDNW 1541
SYSSTATS_MAIN IOSEEKTIM 1
SYSSTATS_MAIN IOTFRSPEED 241635
SYSSTATS_MAIN SREADTIM
SYSSTATS_MAIN MREADTIM
SYSSTATS_MAIN CPUSPEED
SYSSTATS_MAIN MBRC
SYSSTATS_MAIN MAXTHR
SYSSTATS_MAIN SLAVETHR


NOTE…low IOSEEKTIM is due to flash storage.

When using the application (LOAD) and run the generate stats command,following values are shown:
SQL> select sname, pname, pval1 from sys.aux_stats$;

SNAME PNAME PVAL1
------------------------------ ------------------------------ ----------
SYSSTATS_INFO STATUS
SYSSTATS_INFO DSTART
SYSSTATS_INFO DSTOP
SYSSTATS_INFO FLAGS 1
SYSSTATS_MAIN CPUSPEEDNW 1604
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

When should I generate system statistics?

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.