Search notes:

DBMS_STATS.GATHER_SYSTEM_STATS

begin
   dmbs_stats.gather_system_stats (
      gathering_mode   => '…',  -- Default is 'NOWORKLOAD',
      interval         =>  … ,  -- an integer whose default is 60
      stattab          => '…',  -- default is null
      statid           => '…',  -- default is null
      statown          => '…'   -- default is null
   );
end;
/

Getting «no workload» stats

set serveroutput on
declare
   t0 date;
begin
   t0 := sysdate;
   dbms_stats.gather_system_stats;
   dbms_output.put_line('gethering stats took ' || round((sysdate - t0) * 86400) || ' seconds.');
end;
/
--
-- gethering stats took 28 seconds.

select
   pname,
   pval1
from
   sys.aux_stats$
where
   sname =   'SYSSTATS_MAIN' and
   pname in ('CPUSPEEDNW', 'IOSEEKTIM', 'IOTFRSPEED');

See also

aux_stats$
dbms_stats

Index