Re: Backup trends (2): HOT or COLD

Howard J. Rogers wrote:

> 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??)

Especially if you were inserting into them.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)