Re: How does orcale determine whether a row is committed.
- From: "Pradeep" <agarwalp@xxxxxxxxx>
- Date: 30 Dec 2005 21:02:18 -0800
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
.
- References:
- How does orcale determine whether a row is committed.
- From: Pradeep
- Re: How does orcale determine whether a row is committed.
- From: Daniel Fink
- How does orcale determine whether a row is committed.
- Prev by Date: Re: ORCL NEWBIE.. INSTALLATION HELP!
- Next by Date: Re: Use of TEMP TS with INSERT
- Previous by thread: Re: How does orcale determine whether a row is committed.
- Next by thread: Regarding date formats
- Index(es):
Relevant Pages
|
