Re: Oracle Table extents

If you 're using the cost based optimizer try to analyze the table when it goes slow.

Cheers
Igor

bjin wrote in message <36E336E4.1F8CCD62_at_hpsgns1.sgp.hp.com>...
>Hi,
>
>Try ALTER TABLE DEALLOCATE UNUSED statement. It deallocates unused
>space starting from the end of the table. If the last few extents don't
have
>records
>when the table has only a few records, it will help.
>
>Regards
>bjin
>
>
>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 Mon Mar 08 1999 - 08:12:30 CST