Hi sonia

My reply to your question

a) how oracle comes to know that it should go to rollback segment

From the Interested Transaction List (ITL) and the System Change Number (SCN)

From the SCN It will know if it needs to recreate the blocks.
From the ITL in the RBS it will know if the block is commited or not.


b)Where does oracle stores this info.

I answered it wrongly the first time my answer should have read..

The changed block has an ITL (interested transaction list) in the block header which records information about the change i.e which rows have changed in the block together with a pointer to the RBS header (transaction table).



(sorry hehe)


[Edited by hrishy on 07-25-2002 at 02:27 AM]