DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: hwm

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    How do I check HWM for rollback seg?

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    HWMSIZE in v$ROLLSTAT

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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
  •  


Click Here to Expand Forum to Full Width