HIGH WATER LEVEL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: HIGH WATER LEVEL

  1. #1
    Join Date
    May 2001
    Location
    London
    Posts
    149
    Dear all,

    Can anybody tell me in brief what is
    HIGH WATER LEVEL & LOW WATER LEVEL in Oracle

    Thanks in advance

    Paresh

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    hi

    High water mark if that is waht you mean then.....it refers to block storage..........it is the highest block which had rows in it.......suppose you delete some rows from a table then oracle will still keep the high water mark............however if you truncate a table then the high water mark would be deleted......


    if you mean high water level then.............gimme a sec i ma busy.......tryin to fig out what this heck means...


  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    HIGH WATER MARK indicates the level upto which the last table block reached.As soon as u enter data into the table HIGH WATER MARK also rises.When u delete the rows from the table the HIGH WATER MARK remains where it is,it doesnot fall.This leads to more I/O since when Oracle performs scan of the table it scans upto the HIGH WATER MARK.
    HIGH WATER MARK is reset only when u truncate or export the table,drop the table and import it again.
    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    Rohit nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com


  4. #4
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Hi Rohit

    yes. you are correct.

    regards

    anand

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