mysql> select /*+ query_timeout(1000000000) */ * from __all_virtual_tablet_compaction_info where max_received_scn > finished_scn and max_received_scn > 0;
+-----------------+----------+-----------+-------+-----------+---------------------+---------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| svr_ip          | svr_port | tenant_id | ls_id | tablet_id | finished_scn        | wait_check_scn      | max_received_scn    | serialize_scn_list                                                                                                                                                                                                       |
+-----------------+----------+-----------+-------+-----------+---------------------+---------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 192.168.140.174 |     2982 |      1001 |     1 |       370 | 1693476747012845786 |                   0 | 1693480544981708870 | {size:1, last_compaction_type:0, wait_check_flag:0, last_medium_scn:1693476747012845786, info_list:{[0]:compaction_type:"MEDIUM_COMPACTION", medium_snapshot_:1693480544981708870, parallel_merge_info:{list_size:0, }}} |
| 192.168.140.175 |     2982 |      1001 |     1 |       370 | 1693476747012845786 | 1693476747012845786 | 1693480544981708870 | {size:1, last_compaction_type:0, wait_check_flag:1, last_medium_scn:1693476747012845786, info_list:{[0]:compaction_type:"MEDIUM_COMPACTION", medium_snapshot_:1693480544981708870, parallel_merge_info:{list_size:0, }}} |
| 192.168.140.177 |     2982 |      1001 |     1 |       370 | 1693476747012845786 | 1693476747012845786 | 1693480544981708870 | {size:1, last_compaction_type:0, wait_check_flag:1, last_medium_scn:1693476747012845786, info_list:{[0]:compaction_type:"MEDIUM_COMPACTION", medium_snapshot_:1693480544981708870, parallel_merge_info:{list_size:0, }}} |
+-----------------+----------+-----------+-------+-----------+---------------------+---------------------+---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.02 sec)


mysql> select* from oceanbase.CDB_OB_MAJOR_COMPACTION;
+-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+
| TENANT_ID | FROZEN_SCN          | FROZEN_TIME                | GLOBAL_BROADCAST_SCN | LAST_SCN            | LAST_FINISH_TIME           | START_TIME                 | STATUS | IS_ERROR | IS_SUSPENDED | INFO |
+-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+
|         1 | 1693418400883742799 | 2023-08-31 02:00:00.883743 |  1693418400883742799 | 1693418400883742799 | 2023-08-31 02:01:15.890161 | 2023-08-31 02:00:01.004329 | IDLE   | NO       | YES          |      |
|      1001 | 1693418401706628243 | 2023-08-31 02:00:01.706628 |  1693418401706628243 | 1693418401706628243 | 2023-08-31 02:00:55.955022 | 2023-08-31 02:00:01.820150 | IDLE   | NO       | YES          |      |
|      1002 | 1693418400634533452 | 2023-08-31 02:00:00.634533 |  1693418400634533452 | 1693418400634533452 | 2023-08-31 02:00:50.327629 | 2023-08-31 02:00:00.690944 | IDLE   | NO       | YES          |      |
+-----------+---------------------+----------------------------+----------------------+---------------------+----------------------------+----------------------------+--------+----------+--------------+------+
3 rows in set (0.01 sec)


mysql> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_PROGRESS where TABLET_ID='1693476747012845786';
Empty set (0.01 sec)

mysql> SELECT * FROM oceanbase.GV$OB_TABLET_COMPACTION_PROGRESS where TABLET_ID='370';
Empty set (0.00 sec)