Re: how to set up system stats on a new 10g box

  • From: Nuno Souto <dbvision@xxxxxxxxxxxx>
  • To: ganstadba@xxxxxxxxxxx
  • Date: Fri, 19 Dec 2008 01:25:17 +1100

gathering_mode=>'NOWORKLOAD'
which happens to be the default value.
Does a half decent job, too.


--
Cheers
Nuno Souto
in rainy Sydney, Australia
dbvision@xxxxxxxxxxxx


Michael McMullen wrote,on my timestamp of 19/12/2008 1:00 AM:
How do you set up system stats on a brand new box with no workload? I’m always afraid to run it once prod is up and running smoothly. I seem to recall that there is an option to let oracle decide but I forget right now.



--
//www.freelists.org/webpage/oracle-l


Other related posts: