Re: sane number of the table partitions in DWH
- From: Kurt Franke <Kurt-Franke@xxxxxx>
- To: makulev@xxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 30 Mar 2009 21:30:21 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
