Thread: hwm
-
How do I check HWM for rollback seg?
-
-
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 rohitsn@altavista.com
Regards,
Rohit Nirkhe,Oracle DBA,OCP
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|