Oracle Table extents

From: <noams_at_ncc.co.il>
Date: Sun, 07 Mar 1999 09:40:27 GMT
Message-ID: <7bthib$imn$1@nnrp1.dejanews.com>

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 - 03:40:27 CST