Re: RMAN Backup timing question
From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Wed, 2 Jan 2008 14:52:06 -0800 (PST)
Message-ID: <9d448213-02dc-447f-a7e3-1702040bc92f@e25g2000prg.googlegroups.com>
Date: Wed, 2 Jan 2008 14:52:06 -0800 (PST)
Message-ID: <9d448213-02dc-447f-a7e3-1702040bc92f@e25g2000prg.googlegroups.com>
On Jan 2, 5:32 pm, zigzag..._at_yahoo.com wrote:
> I have a database, I did level 0 backup using RAMN, let us say it took
> t1 minutes.
> Now I deleted lot of data in database using delete staements (as part
> of some application archiving process). I do level 0 backup again.
> Will time taken now be roughly same as t1 or lot less because many
> blocks are "empty".
>
> Thanks.
What version of oracle?
If you just "delete rows" but haven't truncated tables releasing extents or dropped tables ... then the blocks aren't exactly empty are they? They may not contain rows but that's a different story. Received on Wed Jan 02 2008 - 16:52:06 CST