Re: Resetting highwatermark

Brian Rasmusson wrote:
>
> Hi,
>
> is it possible to reset the highwatermark of a table? I cannot drop
> or truncate the table as it is in use constantly.
>
> What i have is a transaction table, where one process writes, and
> one reads and deletes.
>
> I only process a limited number of transactions at a time, and i find
> a range by selecting min and max ids of the rows. Problem
> is if the read/delete process has been down for a period, lots of
> transactions will be written to the table, thus setting the highwater
> mark.
>
> Now, if there have been, say, 800.000 transactions in the table, but
> there
> normally is only around 5000, the selection of min and max will be very
> slow. Is there any way to get around this?
>
> Best regards,
> Brian
>
> --
> ------------------------------------------------------------------------
> Brian Rasmusson, Software engineer & analyst e-mail: brianr_at_belle.dk
> Belle Systems A/S web : www.belle.dk
> Network, Internet and communication specialists phone : +45 59442500
> ------------------------------------------------------------------------

Possibly look at using partition views on the table which would then open up the possibility of using truncate on the "older" partitions...

Cheers

-- 
---------------------------------------------
Connor McDonald
BHP Information Technology
Perth
Australia
email: mcdonald.connor.cs_at_bhp.com.au
"My views are not BHP ...blah blah"
---------------------------------------------
"Opera singers are the only people that when you 
 stick a knife in them, they sing, not bleed"