1.

How Will You Monitor Rollback Segment Status ?

Answer»

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.

Querying the DBA_ROLLBACK_SEGS view


Discussion

No Comment Found

Related InterviewSolutions