RE: Index selectivity versus clustering factor
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <Amir.Hameed@xxxxxxxxx>, <Mark.Bobak@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Apr 2013 11:55:28 -0500
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@xxxxxxxxx]
Sent: Tuesday, April 23, 2013 11:52 AM
To: Taylor Christopher - Nashville; Mark.Bobak@xxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
