Get Started with Performance Tuning Reactive Database Tuning Using Automatic Workload Repository Warehouse for Generating Performance Reports AWR Warehouse Best Practices Database Best Practices Stats Collection Stats Collection Gather statistics periodically, once a day at a minimum, for SYS schemas to ensure that the stats are accurate.