Making the Most of Metrics and Statistics Collection
If your databases have weekly workload cycles, like major batch jobs during the weekend, you can use the default AWR retention period of seven days.
Your database should have enough data to provide accurate and valid results with Automatic Database Diagnostic Monitor, SQL Tuning Advisor, SQL Access Advisor, Undo Advisor, and Segment Advisor. So Oracle recommends that you set a larger AWR retention period to capture at least one complete workload cycle, which could be over a month for most companies.
You can also manually gather statistics depending on your application needs. For a read-only database with incremental table updates, you may elect to gather new statistics every week or fortnight ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
