tag:blogger.com,1999:blog-6850817271941197798.post2469883367240250944..comments2009-12-21T06:34:15.781-08:00Satishbabu Gunukulahttp://www.blogger.com/profile/02630966486825083489noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-6850817271941197798.post-64557271204642514512009-12-21T06:34:15.781-08:002009-12-21T06:34:15.781-08:00One of the questions that I always come across as a DBA is what % of data is changing in the database on a daily basis. I often wonder if I can use v$block_change_tracking and v$backup_database views to get this details. I do take level 0 image copy backups over the weendend and then take a level 1 backup daily (which I then merge with level 0). What SQL statement can I use to get this info which shows % block changes. Thank you for the wonderful post.<br /><br /><a href="http://www.zoombits.de/speicherkarten/micro-sd-transflash/transcend-2gb-micro-sdhc-speicherkarte/17866" rel="nofollow">2gb micro sd karte</a>Sara Reidhttp://www.blogger.com/profile/18373862159812719999noreply@blogger.com