Technical data

Partitioning Recommendations for Oracle Utilities Meter Data Management D-11
(PARTITION PART1 values less than (12499999999999),
PARTITION PART2 values less than (24999999999999),
PARTITION PART3 values less than (37499999999999),
PARTITION PART4 values less than (49999999999999),
PARTITION PART5 values less than (62499999999999),
PARTITION PART6 values less than (74499999999999),
PARTITION PART7 values less than (87499999999999),
PARTITION PART8 values less than (maxvalue)) ;
CREATE UNIQUE INDEX D1T307P0 ON D1_INIT_MSRMT_DATA_LOG_PARM
( INIT_MSRMT_DATA_ID, SEQNO, PARM_SEQ) TABLESPACE <Tablespace_Name>
LOCAL COMPRESS 1;
ALTER TABLE D1_INIT_MSRMT_DATA_LOG_PARM ADD CONSTRAINT D1T307P0
PRIMARY KEY (INIT_MSRMT_DATA_ID, SEQNO, PARM_SEQ) USING INDEX
TABLESPACE <Tablespace_Name>;
Compression Recommendations
In general the recommendation is to do QUERY HIGH compression (a part of hybrid columnar
compression) on Exadata.
For Final Measurement table (D1_MSRMT) keep current table partition uncompressed. The rest
of the older partitions will be compressed based on QUERY HIGH compression.
For Initial Measurement Data table (D1_INIT_MSMRT_DATA) keep CLOBs always in
securefile and Medium Compressed. In addition, keep current table partition uncompressed. the
rest of the older partitions will be compressed based on QUERY HIGH compression.
All multi column Indexes (primary as well as secondary) will be compressed using the default
compression. HCC or OLTP compression is not applicable on the top of compressed Indexes.
Load data into the uncompressed table partitions using a conventional load and then when data is
loaded use CTAS operation to load into a temporary heap table. Then truncate the original
partition. Alter original partition into HCC compressed and then partition exchange this with the
temporary heap table.