Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT!!! Extremely slowly table access after delete

Re: URGENT!!! Extremely slowly table access after delete

From: Jonathan Waland <jonathan.waland_at_vf.vodafone.co.uk>
Date: 1998/02/17
Message-ID: <34E980BB.9BAAC192@vf.vodafone.co.uk>#1/1

Naren Chintala wrote:
>
> This reason is Oracle reads all the blocks until the high watermark,
> irrespective of number of rows and hence the 1 minute. The only way of
> resetting the high watermark is by truncating the table.
>
> HTH.
>

I've found that rebuilding indexes is also helpful - especially if you cannot use truncate.

[alter index rebuild under 7.3+ is good for this]

Jon Waland Received on Tue Feb 17 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US