How do I check HWM for rollback seg?
Printable View
How do I check HWM for rollback seg?
HWMSIZE in v$ROLLSTAT
Hi,
High Water Mark is a mark in rollback segment or a tablespace segment which shows u the level at which the segment extended till the database startup.
In rollback segment u can find out the HWM in v$rollstat dynamic performance view.The column name is HWMSIZE
In case of any doubts write at [email protected]
Regards,
Rohit Nirkhe,Oracle DBA,OCP