Mandeep,
I am not sure what you mean by 'maintenance'. Each server
process that starts a transaction, gets assigned a rollback
segment and it is responsible to read the relevant rollback
segment blocks into the database buffer cache if they are not
already present there, for its use. When these rollback segment
blocks get modified by the tranaction (before image gets written
into it), they become dirty and move into the dirty list.
In due course, DBWR and/or a combination of DBWR I/O slaves
writes the blocks to disk. I don't mean to be rude, but you
might want to start reading the Oracle Concepts Manual, to get
answers for this and other questions that may arise from this.
If you can't find the answers to your questions in the manuals,
please post your questions and someone will be more than happy
to get you some answers.
Enjoy your bedtime reading...;-)
Gaja
- "Bhatia, Mandeep (CAP, CEF)" <Mandeep.Bhatia_at_gecapital.com>
wrote:
> Gaja thanks,
> which process is responsible for these Rollback segments
> maintenance ? is it
> DBW0 or ??
>
>
> Regards,
> Mandeep
>
>
>
> -----Original Message-----
> Sent: Thursday, November 16, 2000 12:21 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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!
> http://calendar.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gaja Krishna Vaidyanatha
> INET: gajav_at_yahoo.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).
> --
> 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"
Received on Fri Nov 17 2000 - 00:04:12 CST