Re: Writer not stop Reader ?

It's a question of scale.

Technically you are correct, a writer can block a reader for a fraction of a second, and a reader can block a writer for a fraction of a second (events which are recorded as buffer busy waits usually).

However, the claim that 'writers don't block readers etc.' is a comparison with other database systems where a writer will stop a reader from reading a record (or block) for the entire duration of the transaction, and a reader will lock a writer for the entire duration of a transaction - a time period that could be measured in seconds, minutes or hours; rather than Oracle's sub-hundredth of a second 'pin'.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

nikko wrote in message <370C48F7.171155E_at_po.jaring.my>...
>In Oracle, the Oracle Writer wont' stop the Reader.
>
>If so, when the Data is written to the Database, and the same data is
>read from the database, won't it be accurate for the reader ?
>
Received on Thu Apr 08 1999 - 14:36:19 CDT