Calculate Number of Blocks Changed in a Database?
I need to be able to calculate or query the number of blocks that have changed in a given Oracle database in the last x hours or days. (v9i, 10g, and 11g)
We're in the process of rolling out an incremental backup strategy and we cannot use a one size fits all plan. I am performing comprehensive testing but I need to know the number of blocks that have changed since my last level 0 backup in order to properly understand the timings that I'm recording. Note I did not say number of block changes. For my purposes, changing the same block 3 times is still 1 block changed.
We're in the process of rolling out an incremental backup strategy and we cannot use a one size fits all plan. I am performing comprehensive testing but I need to know the number of blocks that have changed since my last level 0 backup in order to properly understand the timings that I'm recording. Note I did not say number of block changes. For my purposes, changing the same block 3 times is still 1 block changed.
0