My Oracle Support Banner

Regarding D1_INIT_MSRMT_DATA Partitioning (Doc ID 2761620.1)

Last updated on MARCH 22, 2021

Applies to:

Oracle Utilities Meter Data Management - Version 2.3.0.2.0 and later
Information in this document applies to any platform.

Goal

On : 2.3.0.2.0 version, Database

Regarding D1_INIT_MSRMT_DATA Partitioning

As per DBA Guide the partitioning strategy for D1_INIT_MSRMT_DATA table is as below when using ILM.

PARTITION BY RANGE (ILM_DT)
SUBPARTITION BY range (RETENTION_PERIOD)

The sub partitioning is based on RETENTION_PERIOD which is not the Primary Key .

What is the performance gain perspective of using RETENTION_PERIOD ? It would only help in retention and archiving isn't it ?
Where as using the Primary Key INIT_MSRMT_DATA_ID and having more sub partitions would help the thread pool worker scale up .
We would like to understand the performance gains with regards to using RETENTION_PERIOD as sub partitioning column.?

Please clarify this as we will have to go-live soon with this customer.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.