<<Previous Next>>
Oracle - What is Rollback
Segment in oracle? - Feb 23, 2010 at 11:00 PM by Rajmeet
Ghai
What is Rollback Segment in oracle?
Rollback segment is an area that is used to access data of a
transaction before it was committed. This segment is used when a
transaction is rolled back in order to read the old values. This
data is then invalidated when a transaction is COMMITTED.
Oracle - What
is Rollback Segment in oracle? - June 27, 2009
at 11:00 AM
What is Rollback Segment in
oracle?
Rollback Segment in oracle is used to store
"undo" information temporarily.
Also read
Describe Oracle architecture in brief, What is the function of
SMON?, Explain different types of segment, Explain SGA memory
structures..............
An extent is stored some specific information. This information
is stored using specific number of adjoining data blocks. A
collection of extent is called as a segment stored in the same
tablespace.............
A data block is the smallest unit of logical storage for a
database object. As objects grow they take chunks of additional
storage that are composed of contiguous data blocks.............
Rollback segments undo changes when a transaction is rolled back,
they also ensure that transactions leave the uncommitted changes
unnoticed...............
|
