Re: Oracle Table extents

This is because the HighWaterMark of the table doesn't change when rows are deleted. The only alternative to recreating is TRUNCATEing it. This will reset the HWM, while the table remains in existence.

Hth,

Sybrand Bakker, Oracle DBA

noams_at_ncc.co.il wrote:

> Hello,
>
> I have a problem with a large online table (260 bytes per row X 600,000 rows)
> that is accessed a lot by different users that are inserting, selecting and
> deleting from it instantly.
>
> The initial extent that I gave the table was 50MB and next extents 25MB (it
> can climb up to a million records at some point in the day and can decrease
> to a minimum of 0 records at some other point).
>
> The table and tablespace should be 24H online and ready for transactions.
>
> My problem is that a simple select (even count(*)) from the table takes a lot
> of time when it has only a few records , the same time as it takes to select a
> million.
>
> I know that recreating the table every night with a job would do the trick ,
> but the table should be always online and there are views that use it.
>
> What is my best solution?
>
> Thanks in advance.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Sun Mar 07 1999 - 04:43:21 CST