dbms_stats.gather_system_stats gathers system statistics. 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;
/
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');