Re: sane number of the table partitions in DWH
Date: Mon, 30 Mar 2009 21:30:21 +0200
> 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
kfReceived on Mon Mar 30 2009 - 14:30:21 CDT