We currently have approximately 130GB worth of AWR reports stuck in a database with only 40GB of actual data. Are there any best practices regarding the purging of old AWR reports? We have our production system set to create snapshots every 15 minutes, which works for production. In non-production, we don't need all those snapshots and they do not accurately reflect the workload for non-prod performance.
Oracle 11.2.0.4 on Solaris