Capacity Command Center (CCC) supports Oracle database partitioning and compression to enhance database administration, management, availability, and performance for Oracle Enterprise databases.
For large enterprises with large amounts of data, the benefits include the following:
Benefits of partitioning include improving the performance of the following database activities:
The benefits of compression include a significant reduction in the amount of storage required by the tables. Depending on your environment, you might also see performance improvements for the rollup process.
The product supports partitioning all fact tables using Oracle Range Interval partitioning scheme. The tables including their partitioning key and partition size are shown in the following table.
Partitioning key and size
|Table Name||Partitioning Key||Partition Size|
The partitioning process scripts perform the following steps:
If a fact table is partitioned, the nightly purge process can optionally drop the old partitions based on the retention policy that you specify. Dropping is significantly faster than the delete process used on non-partitioned tables.
Oracle does not allow the very first partition in an interval partitioning scheme to be dropped. For this reason, CCC creates a first partition configured to contain data prior to 2011-01-01. In most cases, you do not have data that old and this partition is empty. If you have data that old, you can unable to drop it. Consider not including it in the partitioning process (see Prune unwanted data instead of partitioning it).
CCC creates partitions containing five days of data for raw and hour fact tables. It creates partitions containing a month of data for the daily data fact tables. The nightly purge process identifies the partitions that contain data past the retention period and drops them. If a partition contains some data past the retention window and some inside the retention window, that partition is not dropped.