RE: System statistics
Date: Mon, 19 Aug 2013 08:54:59 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E887A61A2AA2_at_NADCWPMSGCMS10.hca.corpad.net>
You need to make sure you gather system statistics with both NOWORKLOAD and then with a representative workload, otherwise you can get some screwy behavior.
As to your question about making a difference, YES they can definitely make difference as the COSTS (cost based optimizer) uses several of these values to come up with the cost calculations of any execution plan.
See below URL for a good write up about it. http://karenmorton.blogspot.com/2008/06/optimizer-noworkload-statistics.html
Chris
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber
Sent: Saturday, August 17, 2013 11:36 AM
To: tony_at_aberdour.demon.co.uk
Cc: ORACLE-L
Subject: Re: System statistics
Valid points. I have gathered system statistics on several different systems. They have yet to make any significant different in performance, good or bad. Has anyone seen a case where the system stats do make a significant difference?
On Sat, Aug 17, 2013 at 11:31 AM, Tony Hasler <tony_at_aberdour.demon.co.uk>wrote:
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 19 2013 - 15:54:59 CEST