Sys Aux Statistics

From NazimWIKI
Jump to navigation Jump to search

Note to-self: Hardware Stats are stored in

SYS.AUX_STATS$

To gather the statistics:

exec dbms_stats.gather_system_stats('Start');
-- during peak times
exec dbms_stats.gather_system_stats('Stop');

To delete the statistics:

exec dbms_stats.delete_system_stats;