RE: Index selectivity versus clustering factor

From: <Christopher.Taylor2_at_parallon.net>
Date: Tue, 23 Apr 2013 13:39:31 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8879D82B82A_at_NADCWPMSGCMS10.hca.corpad.net>

Wow - Oracle really recommended not gathering SYSTEM stats for an app? Did EBS run under rule based optimizer or something?

I apologize for assuming - hard to believe.

Chris

-----Original Message-----

On Tue, Apr 23, 2013 at 12:04 PM, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote: Thanks... I knew that you were referring to the GATHER_SYSTEM_STATS. Jonathan wrote on it back in 2007 (http://jonathanlewis.wordpress.com/2007/05/20/system-stats-strategy). I will look into running it.

Thanks
Amir
--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 23 2013 - 20:39:31 CEST