Re: Writer not stop Reader ?

From: Andrew Babb <andrewb_at_mail.com>
Date: Thu, 08 Apr 1999 14:23:17 +0800
Message-ID: <370C4B55.90F8D75D@mail.com>

Nikko,

Oracle's Rollback segment is used for maintaining read consistency within the database.

If a writer updates a record, but before the writer commits the transaction, another session reads the same data, they will see the original data, unless the SELECT statement includes the FOR UPDATE clause, in which case the reader will wait or fail (if NOWAIT specified) until the writer commits the transaction.

Hope this helps,
Andrew

nikko wrote:

> 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 - 01:23:17 CDT