🎴 Flashcard Mode

Oracle Database Administration

Card1 / 20
Mastered0
Review0
QuestionClick to flip

What should you look at to compute the number of undo blocks written per second on disk ?

AnswerClick to flip back
A
V$UNDOSTAT
💡 Explanation:

V$UNDOSTAT provides statistics on undo tablespace usage including undo blocks written per second. This dynamic performance view contains one row for each 10-minute interval and shows various undo metrics including transaction activity and space consumption. V$TRANSACTION shows active transactions, V$ROLLSTAT shows rollback segment statistics, and DBA_UNDO_EXTENTS shows undo extent information but not the per-second write rate.

Change Mode