Sys Aux Statistics

From NazimWIKI
Revision as of 22:57, 8 November 2019 by Admin (talk | contribs) (Created page with "Note to-self: Hardware Stats are stored in <blockquote><pre> SYS.AUX_STATS$ </pre></blockquote> To gather the statistics: <blockquote><pre> exec dbms_stats.gather_system_st...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;