Re: RMAN Backup timing question

On Jan 2, 5:52 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> 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.

Thanks. This was a general question. I have versions from 8.1.6 to 10.2 running on Widnows and HP UNIX. Received on Wed Jan 02 2008 - 18:15:49 CST