Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Maximum number of partitions/subpartitions on a table?

user12048955May 8 2013 — edited May 13 2013

We are on 11.2 RAC. We have a very large table with tens of billions of records. We are considering to partition the table with range partitioning and list subpartitioning. With five year of data, the table will have 55K partitions plus 657K subpartitions. My question is that whether there is any potential/known side effects that will affect system and/or query performance and/or partition maintenance?

Thanks,

Jim

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2013

Added on May 8 2013

#general-database-discussions

8 comments

3,015 views