Re: Num of Partitions with Subpartitions - quick newbie question

From: Andy Klock <andy_at_oracledepot.com>
Date: Fri, 14 Dec 2012 10:21:16 -0500
Message-ID: <CADo_RaMVvjtxjaNyGNdPqNLwx05Pa8gEf13kcUHC8nb+XjXdVw_at_mail.gmail.com>

Depends on your version. It used to be 64K (total partition/sub partitions) but in versions 10g/11g it is 1024K (minus 1). So with 8000 you are only getting started :)
http://docs.oracle.com/cd/E11882_01/server.112/e17118/statements_3001.htm#i2085640

On Fri, Dec 14, 2012 at 9:59 AM, <Christopher.Taylor2_at_parallon.net> wrote:

> We're experimenting with partitioning a table into many partitions with
> many subpartitions because of the way we process by Organization IDs and
> Secure Profiles - related to parallel application server processing.
> Is there a MAXIMUM (or recommended value to keep under) for number of
> partitions and/or subpartitions?
>
> This table (if design works) would have approximately 8000 subpartitions
> and 1/4 of that in partitions I think. (I don't have the numbers off the
> top of my head)
>
> Regards,
>
>
> Chris Taylor
> Oracle DBA
> Parallon IT&S
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 14 2012 - 16:21:16 CET