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