Technical data

Partitioning Recommendations for Oracle Utilities Meter Data Management D-1
Appendix D
Partitioning Recommendations for Oracle
Utilities Meter Data Management
This section specifies the partitioning and compression strategies recommended for an initial
Oracle Utilities Meter Data Management database configuration on Exadata. It includes the
following topics:
• Partitioning Recommendations
• Compression Recommendations
Partitioning Recommendations
In general, the recommendation is for a minimum of 'n' partitions for selective database objects,
where 'n' is number of RAC nodes.
• The Table Partitioning scheme for Transaction tables is focused primarily on tables associated
with Measurement MO, Measurement Log MO and Initial-Measurement-Data MO.
• D1_MSRMT, D1_MSRMT_CHAR, D1_MSRMT_LOG, D1_MSRMT_LOG_PARM tables
can be partitioned by MSRMT_DTTM (smaller partition better performance). Begin with bi-
weekly partitions. Subpartition these tables by MEASR_COMP_ID (8 subpartitions should
be a good number to start with).
• D1_INIT_MSRMT_DATA table can be partitioned by D1_TO_DTTM (smaller partitions
lead to better performance). Bi-weekly partitions is a good start. Subpartition
D1_INIT_MSRMT_DATA table by MEASR_COMP_ID (8 subpartitions should be a good
number to start with).
• D1_INIT_MSRMT_DATA_CHAR,D1_INIT_MSRMT_DATA_K,D1_INIT_MSRMT_DATA
_LOG,D1_INIT_MSRMT_DATA_LOG_PARM tables can be partitioned by
INIT_MSRMT_DATA_ID (8 sub partitions should be a good number to start with).
• All secondary Indexes should be global.
The following sections gives partition recommendation and can be used as reference. It includes
the following:
• D1_MSRMT
• D1_MSRMT_CHAR
• D1_MSRMT_LOG
• D1_MSRMT_LOG_PARM
• D1_INIT_MSRMT_DATA