Re: how to set up system stats on a new 10g box
From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Fri, 19 Dec 2008 01:25:17 +1100
Message-ID: <494A5D4D.2070001@iinet.net.au>
Date: Fri, 19 Dec 2008 01:25:17 +1100
Message-ID: <494A5D4D.2070001@iinet.net.au>
gathering_mode=>'NOWORKLOAD'
which happens to be the default value.
Does a half decent job, too.
-- Cheers Nuno Souto in rainy Sydney, Australia dbvision_at_iinet.net.au Michael McMullen wrote,on my timestamp of 19/12/2008 1:00 AM:Received on Thu Dec 18 2008 - 08:25:17 CST
> 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.
>
-- http://www.freelists.org/webpage/oracle-l