1. Home
  2. Knowledge Base
  3. Database Administration
  4. Check if block change tracking file is being used
  1. Home
  2. Knowledge Base
  3. Scripts
  4. Check if block change tracking file is being used

Check if block change tracking file is being used


select file#, avg(datafile_blocks), avg(blocks_read), avg(blocks_read/datafile_blocks) * 100
as "% read for backup"
from v$backup_datafile
where incremental_level > 0 and used_change_tracking = 'YES'
group by file# order by file#;
The following two tabs change content below.

Gavin Soorma

Latest posts by Gavin Soorma (see all)

Updated on June 2, 2021

Was this article helpful?

Related Articles

Leave a Comment