amount of unused block compression per TS?

From: Martin Berger <>
Date: Thu, 18 Jun 2009 08:01:52 +0200
Message-ID: <>

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,


Received on Thu Jun 18 2009 - 01:01:52 CDT

Original text of this message