RE: Index selectivity versus clustering factor

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Tue, 23 Apr 2013 17:04:19 +0000
Message-ID: <AF02C941134B1A4AB5F61A726D08DCED0AF62A9B_at_USA7109MB012.na.xerox.net>

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
-----Original Message-----

From: Christopher.Taylor2_at_parallon.net [mailto:Christopher.Taylor2_at_parallon.net] Sent: Tuesday, April 23, 2013 12:55 PM
To: Hameed, Amir; Mark.Bobak_at_proquest.com; oracle-l_at_freelists.org Subject: RE: Index selectivity versus clustering factor

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 - 19:04:19 CEST