Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: difference between block changes and consistent block changes
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