Monitoring Partition Reorganization
When you use ALTER TABLE...REORGANIZE
, the operation reorganizes the data in the background.
You can monitor details of the reorganization process by polling the following system tables:
V_MONITOR.PARTITION_STATUS
displays the fraction of each table that is partitioned correctly.V_MONITOR.PARTITION_REORGANIZE_ERRORS
logs errors issued by the reorganize process.V_MONITOR.PARTITIONS
displaysNULL
in thepartition_key
column for any ROS that was not reorganized.
Note: The corresponding foreground process to ALTER TABLE...REORGANIZE
is PARTITION_TABLE
.