Query sys.aux_stats$
SQL> select * from sys.aux_stats$;
SNAME PNAME PVAL1
------------------------------ ------------------------------ ----------
PVAL2
------------------------------------------------------------------------------------------------------------------------
SYSSTATS_INFO STATUS
COMPLETED
SYSSTATS_INFO DSTART
10-26-2009 08:42
SYSSTATS_INFO DSTOP
10-26-2009 08:42
SYSSTATS_INFO FLAGS 0
SYSSTATS_MAIN CPUSPEEDNW 1661.912
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
SQL> begin
2 dbms_stats.import_system_stats( stattab => 'SYSTEM_STATS', statid => 'DW', statown => user );
3 end;
4 /
Related examples in the same category