GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Concepts and Architecture
Go To First  |  Previous Question  |  Next Question 
 Concepts and Architecture  |  Question 42 of 74    Print  

What are the uses of Rollback Segment ?

Rollback Segments are used :

To generate read-consistent database information during database recovery to rollback uncommitted transactions for users.




  
Total Answers and Comments: 3 Last Update: September 18, 2007   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 29, 2005 03:56:18   #1  
       

RE: What are the uses of Rollback Segment ?

Rollback segments are used to

  1. get data blocks to the original state when user issues a 'rollback' statement
  2. give consistent data to a user hiding uncommitted changes made by other users/sessions
  3. to undo uncommitted changes during database recovery. After applying all changes recorded in the redo logs Oracle uses rollback segments to undo uncommitted changes. Since rollback segments are stored in the database buffers they are automatically protected by the redo log.

 
Is this answer useful? Yes | No
June 15, 2007 07:15:16   #2  
vijay        

RE: What are the uses of Rollback Segment ?
Transaction rollback: Suppose if you are updating the data now you want to rollback so the old image will read from rollback segments. You are old image from rollback segment.

Transaction Recovery: Suppose you are updating the data now the instance failed so the uncommited data has to be rolled back so it will rollback from undo segments if the data is protected by redo logs.

Read consistency: Suppose you are updating the data so lock will held for that table now other users query means it has to old data before you commit so that data will read from rollback segements. It is nothing but read consistency

 
Is this answer useful? Yes | No
September 18, 2007 04:54:58   #3  
Mohammed Abdul Afroze        

RE: What are the uses of Rollback Segment ?
Rollback Segment Stores Undo Information and are used for the following purposes.

1. To undo the previous command
2. For read consistency and
3. For crash recovery.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape