amount of unused block compression per TS?
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Thu, 18 Jun 2009 08:01:52 +0200
Message-ID: <cd8f74560906172301g5a5cec4es55c6787c6050f5ec_at_mail.gmail.com>
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
Date: Thu, 18 Jun 2009 08:01:52 +0200
Message-ID: <cd8f74560906172301g5a5cec4es55c6787c6050f5ec_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 18 2009 - 01:01:52 CDT