|
Oracle DBA Checklist - -Verify rollback segment - Daily Procedures
Oracle DBA Checklist
(Continued from previous question...)
Oracle DBA Checklist - -Verify rollback segment - Daily Procedures
Status should be ONLINE, not OFFLINE or FULL, except in some cases you may have a special rollback segment for large batch jobs whose normal status is OFFLINE.
a) Optional: each database may have a list of rollback segment names and their expected statuses.
b) For current status of each ONLINE or FULL rollback segment (by ID not by name), query on V$ROLLSTAT.
c) For storage parameters and names of ALL rollback segment, query on DBA_ROLLBACK_SEGS. That view's STATUS field is less accurate than V$ROLLSTAT, however, as it lacks the PENDING OFFLINE and FULL statuses, showing these as OFFLINE and ONLINE respectively.
(Continued on next question...)
Other Interview Questions
| 