DEVFYI - Developer Resource - FYI

How will you monitor rollback segment status ?

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

309. How will you monitor rollback segment status ?

Querying the DBA_ROLLBACK_SEGS view
IN USE - Rollback Segment is on-line.
AVAILABLE - Rollback Segment available but not on-line.
OFF-LINE - Rollback Segment off-line
INVALID - Rollback Segment Dropped.
NEEDS RECOVERY - Contains data but need recovery or corupted.
PARTLY AVAILABLE - Contains data from an unresolved transaction involving a distributed database.

(Continued on next question...)

Other Interview Questions