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

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

RE: clarification on partitioned tables

From: Bernard Polarski <bpolarsk_at_yahoo.com>
Date: Thu, 15 Jun 2006 23:03:41 -0700 (PDT)
Message-ID: <20060616060341.82014.qmail@web36513.mail.mud.yahoo.com>


I don't see the parameter 'granularity' set. The default is 'ALL' and since cascaded is set to true it means that for event if you set partname you will be caluculating any global index again and again for each partitions, subpartition. Cheer !  

 Beside that, with so much indexes, I doubt your TEMP even set to something to 60 to 100GB will make it. You gonna get unable to extent tmp after 2 or 3 days.  

"

 exec dbms_stats.gather_table_stats (ownname=>'schema_owner',tabname=>'table_name',  partname=>'partition_name',estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,  method_opt=>'for all indexed columns', cascade=>TRUE);
"
   

 B. Polarski
 http://www.smenu.org

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 16 2006 - 01:03:41 CDT

Original text of this message

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