Answer Detail: RE: What is use of rollback segments in Oracle databas...

GeekInterview.com > Interview Questions > Oracle > Memory Management

Print |

Question: What is use of rollback segments in Oracle database

June 06, 2006 00:10:53	#2
anandhi80	Member Since: June 2006 Total Comments: 1
RE: What is use of rollback segments in Oracle databas...
when a user updated a particular table (for example 100 rows)...the old value will be retained in the roll back segments(Oracle 8) and now it is Undo segment (oracle 9i). If the user issue a rollback command the old value will be taken from the rollback segment(that too if undo_retention parameter set properly in the parameter file).