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: Question regarding read consistency in Tom Kyte's Expert 10g book

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

From: Thomas Kyte <thomas.kyte_at_oracle.com>
Date: 5 May 2005 11:00:18 -0700
Message-ID: <125316018.0000b06a.033@drn.newsguy.com>


In article <20050505135352.221$ll_at_newsreader.com>, xhoster_at_gmail.com says...
>
>georgejzhang_at_gmail.com wrote:
>> Hi,

...
>
>> 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?
>
>From the users point of view, it wouldn't make any difference. I assume
>the one-per-block thing was to serve some pedagogical purpose in some other
>part of the chapter.

It was in order to make the "math" easier -- just for the example. "Assume a row per block, we read block 1, we read ...., we read last block"

>
>
>Xho
>

-- 
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle Corporation
Received on Thu May 05 2005 - 13:00:18 CDT

Original text of this message

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