Check if block change tracking file is being used

June 18, 2009 Gavin Soorma Database Administration, Scripts


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

Please follow and like us:

Last Update: June 18, 2009

June 18, 2009 246 Gavin Soorma

Total 0 Votes:

Tell us how can we improve this post?

Captcha: + = Verify Human or Spambot ?

Add A Knowledge Base Question !

Question Title:

Category:

Your Email: You will receive an email when your question will be answered.

Captcha: + = Verify Human or Spambot ?

Add A Knowledge Base Question !

Tell us how can we improve this post?

Related Knowledge Base Posts -

Add A Knowledge Base Question !

Leave a Comment Cancel reply

Add A Knowledge Base Question !