Partitioning Strategies for P6 Reporting Database

Posted by Jeffrey McDaniel on Oracle Blogs See other posts from Oracle Blogs or by Jeffrey McDaniel
Published on Thu, 29 May 2014 12:55:57 +0000 Indexed on 2014/05/29 21:46 UTC
Read the original article Hit count: 266

Filed under:

Prior to P6 Reporting Database version 3.2 sp1 range partitioning was used. This was applied only to the history tables. The ranges were defined during installation and additional ranges would need to be added once your date range entered the final defined range.

As of P6 Reporting Database version 3.2 sp1, interval partitioning was implemented. Interval partitioning was applied to the existing History table as well as Slowly Changing Dimension tables. One of the major advantages of interval partitioning is there is no more manual addition of ranges. The interval partitioning will automatically create partitions for the defined interval when data is inserted into the table and it exceeds the existing partitions. In 3.2 sp1 there are steps on how to update your partitioning. For all versions after 3.2 sp1 interval partitioning is the only partitioning option used. When upgrading it is important to be aware of these changes. Here is a link with more information on partitioning -the types and the advantages.

http://docs.oracle.com/cd/E11882_01/server.112/e25523/partition.htm

© Oracle Blogs or respective owner

Related posts about /Oracle