System statistics - How often?

  • From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 29 Sep 2008 11:48:20 -0500

Anyone have any recommendations for the collection of system statistics?
Any recommendation on how long to run the capture?  I've heard 72 hours
before (ie, M-W during a business week, which should represent the bulk
of activity, shifting the window if you have more activity on X day).

Is there any reason to re-gather system statistics if hardware remains

Also, when you want to ensure you can go back to old system stats, do
you export, or use a stats table, or some other method?

Thanks - Chris


Other related posts: