Mandeep,
I am not sure what made you think rollback segments are not in
memory and only on disk. The rollback segment blocks (like all
other blocks except pure temporary tablespace blocks) are
modified in memory first, before written to disk. And when a
block gets modified it becomes dirty, goes on the dirty list and
then eventually gets down to disk. Just like the other blocks.
Hope that helps,
Gaja
- "Bhatia, Mandeep (CAP, CEF)" <Mandeep.Bhatia_at_gecapital.com>
wrote:
> Hi Listers,
> The rollback segment is not in physical memory , it is on the
> disk.
> for every changing row oracle moves its before image to rbs.
> does this not make query performance slow ?
> Kindly verify ?
> Mandeep
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bhatia, Mandeep (CAP, CEF)
> INET: Mandeep.Bhatia_at_gecapital.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail
> message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).
> You may
> also send the HELP command for other information (like
subscribing).
Gaja Krishna Vaidyanatha
Director, Storage Management Products, Quest Software Inc.
Office : (972)-304-1170, E-mail : gajav_at_yahoo.com
Author - Oracle Tuning 101 by Osborne McGraw-Hill
"Opinions and views expressed are my own and not of Quest"
Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays!
Received on Thu Nov 16 2000 - 11:20:35 CST
