Re: High Water Mark Question - Reposted

Only if at some point your HWM grows way beyond the normal level you might need to concern yourself with it. When Oracle performs a full table scan it reads all blocks below HWM into the buffer cache - including the empty ones.

Regards
Ivan Bajon, ocp

Anurag Minocha <anurag_at_synergy-infotech.com> wrote in message news:382BC8CC.B5FAD1BC_at_synergy-infotech.com...
> Hi ,
> I have a question that suppose we have 1 lac rows in a table , the HWM
> is set to a particular value. Now i delete 75000 of the rows the HWM
> still remains the same.Again if i insert some 70,000 rows will the HWM
> increase or will it remain the same.
>
> I have to follow this procedure everyday in our database and am worried
> whether performance will go down or not.
>
> reply at
> anurag_minocha_at_hotmail.com
>
>
>
Received on Fri Nov 12 1999 - 08:22:43 CST