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:

Note: The corresponding foreground process to ALTER TABLE...REORGANIZE is PARTITION_TABLE.