RE: Index selectivity versus clustering factor
Date: Tue, 23 Apr 2013 11:55:28 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8879D82B538_at_NADCWPMSGCMS10.hca.corpad.net>
Sorry, you misunderstood. Not talking about statistics on SYS/SYSTEM tables. Talking about SYSTEM STATISTICS (statistics about the server - CPU speed, IO transfer speed, seek times).
These are gathered through DBMS_STATS.GATHER_SYSTEM_STATS:
Read more here (hat tip to Karen Morton if she's reading this!): http://karenmorton.blogspot.com/2008/06/optimizer-noworkload-statistics.html
Chris
-----Original Message-----
From: Hameed, Amir [mailto:Amir.Hameed_at_xerox.com]
Sent: Tuesday, April 23, 2013 11:52 AM
To: Taylor Christopher - Nashville; Mark.Bobak_at_proquest.com; oracle-l_at_freelists.org
Subject: RE: Index selectivity versus clustering factor
Chris,
In the past, Oracle did not used to support gathering of SYSTEM statistics for the eBiz suite and therefore, we do not collect them. I will have to check and see if Oracle supports it now. Based on note "EBPERF FAQ - Collecting Statistics in Oracle EBS 11i and R12 [ID 368252.1]", which seems to be a recent note, it seems that Oracle now suggests gathering SYSTEM statistics.
Amir
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 23 2013 - 18:55:28 CEST