Re: sane number of the table partitions in DWH

From: Kurt Franke <Kurt-Franke_at_web.de>
Date: Mon, 30 Mar 2009 21:30:21 +0200
Message-Id: <1200137823_at_web.de>


Milen,

> Developers want to partition a (fact) table(s) to the smallest slice possible.
> The number of calculated/estimated partitions is 200 000 - 300 000 (Yep, this is NOT a typing error !).

the oracle limit for the number of partitions per table is 64k - 1 in database version 10

> My questions:
> 1) What is the "manageable" number of partitions (from performance point of view == parse times) that I you have seen by clients.
> 2) Any parameters (also underscore ...) to reduce the hard-parse times (because of the enormous amount of partitions) ?
> 3) If I have so many partitions , what is the influence on the fragmentation of the shared pool? Any experiences ?
> 4) Is multi-column partitioning a save bet (bugs) ?
> Is is running stable ?
> Are any special one-off patches on top of 10.2.0.4 needed ?

the patch is named version 11g which then will allow 1024k - 1 partitions per table

regards

kf

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 30 2009 - 14:30:21 CDT

Original text of this message