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#; |
Check if block change tracking file is being used
最新推荐文章于 2021-08-04 09:46:16 发布