Saturday, April 16, 2011

What is High Water Mark (HWM) ?




The high water mark level is just a line separate the used blocks and free blocks.

The blocks above the HWM level is free blocks, they are ready to use.

The blocks below the HWM level is used blocks, they are already used.

See the below example:

If you delete some huge records from the database, that data will delete but the blocks are not ready to used, because that blocks are still below HWM level, so delete command never reset the HWM level,

At the same time you truncate the date, then the data will delete and that used blocks will goto above the HWM level, now its ready to used. now they consider has free blocks.

I hope this enough to understand.

+---- high water mark of newly created table
|
V
+--------------------------------------------------------+
|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+

      high water mark after inserting 10,000 rows
                                    |
                                    v
+--------------------------------------------------------+
|x |x |x |x |x |x |x |x |x |x |x |x |  |  |  |  |  |  |  |
|x |x |x |x |x |x |x |x |x |x |x |x |  |  |  |  |  |  |  |
+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+


      high water mark after inserting 10,000 rows
                                    |
                                    v
+--------------------------------------------------------+
|x |x |x |x |x |x |x |  |  |  |  |  |  |  |  |  |  |  |  |
|x |x |x |x |x |x |x |  |  |  |  |  |  |  |  |  |  |  |  |
+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+--+

Hope this helps...


17 comments:

Anonymous said...

valium generic diazepam valium ingredients - .25 xanax vs valium

Anonymous said...

buy xanax how much is a xanax 1 mg worth - what is xanax drug

Anonymous said...

buy valium online valium or diazepam - buy valium online mastercard

Anonymous said...

zolpidem online is zolpidem tartrate a narcotic - zolpidem 10mg information

Anonymous said...

zolpidem no prescription zolpidem 10mg pill identifier - zolpidem side effects 10 mg

Anonymous said...

buy cheap diazepam side effects taking diazepam long term - where can i buy diazepam online usa

Anonymous said...

ativan for anxiety buy generic ativan online - ativan jet lag

Anonymous said...

diazepam no prescription diazepam dose in adults - diazepam drug interactions

Anonymous said...

buy ambien online ambien 3 79 - ambien prescription dosage

Anonymous said...

soma online soma medication online pharmacy - buy soma online from canada

Anonymous said...

buy valium online order valium - buy valium online no prescription

Anonymous said...

cheap generic ambien side effects of zolpidem ambien - ambien discount card

Anonymous said...

valium no prescription do companies drug test valium - valium zepose

Anonymous said...

generic valium pill identifier valium 10mg price - buy real valium online uk

Anonymous said...

buy ambien online ambien overdose amount - many 10mg ambien get high

Anonymous said...

buy valium diazepam valium side effects weight gain - 10mg valium equal 1 mg xanax

Anonymous said...

valium pills where can i buy valium online yahoo answers - how much does valium cost on the street