Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: difference between block changes and consistent block changes

Re: difference between block changes and consistent block changes

From: Svend Jensen <svend.s.jensen_at_it.dk>
Date: Fri, 19 Sep 2003 19:30:19 +0200
Message-ID: <3f6b3d0e$0$32471$edfadb0f@dread16.news.tele.dk>


Ryan Gaffuri wrote:
> I know the difference between block gets and consistent gets, but how
> can there be a different on 'changes'. If Im running a big delete and
> Im the only user shouldnt all my changes be 'block changes', but the
> bulk of them are consistent changes? I thought they meant about the
> same as consistent gets(which means gets as of current SCN and
> including Rollback) and DB Block gets(as blocks are right now).
>
> what am I missing?

With massive delete - chances are you hit several rows in the same datablock - right?
Then it is a matter on how these things are counted. Delete a row from block A123 => block change Delete another row from A123 => consistent change

rgds
/SJ Received on Fri Sep 19 2003 - 12:30:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US