News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Check if block change tracking file is being used

  • Posted by Gavin Soorma
  • On June 18, 2009
  • 0 Comments

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#;
 4

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *