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 displays NULL in the partition_key column for any ROS that was not reorganized.