Re: Rollback Segment Trouble

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Tue, 16 Mar 1999 13:06:26 -0800
Message-ID: <Pine.OSF.4.02.9903161247160.25500-100000@gonzo.wolfenet.com>

On Tue, 16 Mar 1999 JohannesBavendiek_at_gmx.de wrote:
>
> That is wrong: A SELECT writes data into the rollback because in tnis way
> oracle guarantees consistent read (cursor stability).

Absolutely not. Selects construct consistent-read blocks in cache by reading information in the rollback segments, but unless a user is performing some kind of DML, a select does not write data into the rollback segments.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Tue Mar 16 1999 - 15:06:26 CST