Re: Bookish Questions need Ideas

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 30 Sep 2004 04:14:31 -0700
Message-ID: <ea01504d.0409300314.43ea03f7@posting.google.com>

Dear Faculties..
Again some basic question I am asking regarding Rolllback Segment and Redo Log.Yes this time after reading from many resources.But last time also I read that but why multiple files are using that was the main question.

Point1 : A rollback segment records the old values of data that was changed by each transaction (whether or not committed).

Point 2 : The redo log records all changes made to data, including both uncommitted and committed changes.

Q1.So any Transaction Rollback there are data duplication storage is happening.Means Rollback segment is storing the data as well as the rego log.Is it true?If true then why?

Q2.But I have a doubt on my question also.Is rollback segment stores data or refresh it after stipulated hours or after every load???

Regards
Arijit Chatterjee Received on Thu Sep 30 2004 - 06:14:31 CDT