Re: Backup trends (2): HOT or COLD

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 07 May 2004 04:18:41 +1000
Message-ID: <409a8178$0$441$afc38c87@news.optusnet.com.au>

Norman Dunbar wrote:

> All I need now is Howard to tell me I'm wrong again :o)

No, you are spot on. It's a bugbear I've had ever since I first discovered the EMPTY_BLOCKS column in DBA_TABLES. That should have been called "NEVER_USED", not EMPTY. And it's because it's there that RMAN does precisely what you describe it doing.

VIRGIN_BLOCKS sounds a lot, er, sexier. But it would upset a large number of the user base, I think.

Regards
HJR
(Been missing you, actually, and was thinking about putting up a 'Where's Norman' post. Are you available for email??) Received on Thu May 06 2004 - 13:18:41 CDT