Re: Question regarding read consistency in Tom Kyte's Expert 10g book

georgejzh..._at_gmail.com wrote:
> Hi,
>
> I am reading Chapter one (still beta) of Tom Kyte's new Expert 10g
> book (http://oracle.apress.com/), and it is really a good read.
>
> However, I have some questions about the read consistency example
(page
> 20 - 22) - getting the total balance of accounts table (I would have
> tested it if I could). On page 22, table 1-2, what if T7 and T6
> interchange their position? If the transaction updates row4 and
> commits before the query reads row4, the query would not know that
row4
> has been updated, thus getting the total of 1650? That of course
does
> not sound right. Can you explain how that happens?
>
> And another question, the same example on page 20, why do we assume
> that the table stores one row per block? What if all 4 row are
stored
> in one block?
>
> Thanks
>
> George

I am pretty sure it's a good read but don't expect that everyone here owns this book. Post the code from the example so we may know what you are talking about.

Regards
/Rauf Received on Thu May 05 2005 - 12:29:12 CDT