Hi List, Does anyone knows a method how to get the amount of unused blocks [1] per TableSpace? I try to compare the amount of data RMAN will backup in an incremental or full backup. I know how to use block change tracking [2] to count the changed blocks since the last full backup using X$KRCBIT as described by Alex Gorbachev in [3]. But until now I did not find any way to provide me the number of never used blocks of a TS. can anyone gives me a hint? thank you all in advance, Martin [1] http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/glossary.htm#i432341 [2] http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/glossary.htm#insertedID33 [3] http://www.pythian.com/documents/UKOUG06-10gBCT.ppt -- //www.freelists.org/webpage/oracle-l
