What is a Rollback segment entry ?
Answers were Sorted based on User's Feedback
Answer / manvendra
ROLLBACK SEGMENT OR UNDO SEGMENT IS THE AREA IN UNDO TABLE
SPACE WHERE CHANGED OR NEW UNCOMMITTED DATA RESIDES.
WHEN WE COMMIT, UNDO SEGMENT DATA BECOME UNUSEABLE. BUT IT
STILL RESIDES IN THE UNDO SEGMENT FOR 600 SECONDS.
TO REMOVE THE CONSITANCY ISSUE FROM ORACLE DB.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ravi
WHEN WE COMMIT, UNDO SEGMENT DATA BECOME UNUSEABLE. BUT IT
STILL RESIDES IN THE UNDO SEGMENT FOR 900 SECONDS.
it is called undo retention period
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ravi dutta
this contains the commited and uncommited data stored in
rollback table space prior to 9i. in 9i, it is called as
undo table space.
Is This Answer Correct ? | 1 Yes | 0 No |
How does Space allocation table place within a block ?
What is use of Rollback Segments In Database ?
What is an Oracle Data Segment?
what is ORACLE MEMORY STRUCTURES
What does LGWR do?
What are the functions of SMON?
What is meant by recursive hints ?
What is the function of Dispatcher (Dnnn)?
What are the components of SGA?
What is function of RECO?
What constitute an ORACLE Instance?
Can a View based on another View in Oracle?