Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback segments confusion ?

RE: Rollback segments confusion ?

From: Bhatia, Mandeep (CAP, CEF) <Mandeep.Bhatia_at_gecapital.com>
Date: Thu, 16 Nov 2000 13:51:03 -0500
Message-Id: <10682.122284@fatcity.com>


Gaja thanks,
which process is responsible for these Rollback segments maintenance ? is it DBW0 or ??

 	Regards,
 	Mandeep
 


-----Original Message-----
From: Gaja Krishna Vaidyanatha [mailto:gajav_at_yahoo.com] Sent: Thursday, November 16, 2000 12:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: Rollback segments confusion ?

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


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
Received on Thu Nov 16 2000 - 12:51:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US