How  will you monitor rollback segment status ?

 Querying the DBA_ROLLBACK_SEGS viewIN USE         - Rollback Segment is on-line.AVAILABLE - Rollback Segment available but not on-line.OFF-LINE  - Rollback Segment off-lineINVALID        - Rollback Segment Dropped.NEEDS RECOVERY  - Contains data but need recovery or corupted.PARTLY  AVAILABLE  - Contains data from an unresolved transaction involving a distributed database.
  • Interview Candidate
  • 1
  • 1732

Showing Answers 1 - 1 of 1 Answers

samiksc

  • Dec 29th, 2005
 

The following views help in monitoring rollback segment usage:

  1. DBA_SEGMENTS
  2. DBA_ROLLBACK_SEGS
  3. V$ROLLNAME
  4. V$ROLLSTAT
  5. V$TRANSACTION

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions