Re: Read-only tablespaces and the undo log

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 19 Feb 2005 15:26:35 GMT
Message-ID: <Xns96024BB76EFFBSunnySD@68.6.19.6>

"Peter" <peter.paton_at_transdim.com> wrote in news:1108824685.401993.144500_at_o13g2000cwo.googlegroups.com:

> Quick question here:
>
> If I perform a select from a table that resides in a read-only
> tablespace, will the undo log (or rollback segment in earlier versions)
> be used to ensure read-consistency. (I would suspect not, as the read
> should always be consistent from a read-only tablespace, but want to be
> sure.)
>

SELECTS never produce undo or redo because a SELECT does not change data. Only INSERT,UPDATE & DELETE produce undo & redo segments. Received on Sat Feb 19 2005 - 09:26:35 CST