Question: how to check if block change tracking is enabled or not?
Answer: From SQL*Plus, we can query V$BLOCK_CHANGE_TRACKING to determine whether change tracking is enabled or not. SQL> select status from V$BLOCK_CHANGE_TRACKING; ENABLED => block change tracking is enabled. DISABLED => block change tracking is disabled.