Re: How does orcale determine whether a row is committed.

Thanks Daniel, what i have understood is that, whenever oracle reads a row, it reads its lock byte, and using this lock byte eventually reads the ITE in ITL to get the status of the transaction (i.e committed or not)

Is my understanding right ? And also from where could i get these basic technical info?

Thanks
Pradeep
Daniel Fink wrote:
> Each row contains a lock byte. This lock byte points to an Interested
> Transaction Entry (ITE) in the Interested Transaction List (ITL) in the
> block header. Multiple rows within the block can point to a single ITE.
> >From this point, the ITE points to the additional Transaction
> information you have already described.
>
> Regards,
> Daniel Fink
Received on Fri Dec 30 2005 - 23:02:18 CST