Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> clarification on partitioned tables

clarification on partitioned tables

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Thu, 15 Jun 2006 11:34:19 -0500
Message-ID: <BAY107-F10171C250862F23E450B5F97820@phx.gbl>


I have a partitioned table in my schema. The cron job runs an analyze command to collect statistics. Does the analyze command collect stats on the table partitions? Do I have to explicitly use the:

GRANULARITY => 'PARTITION' with dbms_stats to collect partition stats? I am reading Doc ID: Note:237538.1

any clarification or enlightment is appreciated.

thanks.



Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 15 2006 - 11:34:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US