Re: Large tables

From: <mpir_at_compuserve.com>
Date: Mon, 08 Jun 1998 18:52:27 GMT
Message-ID: <6lhbtb$l4c$1@nnrp1.dejanews.com>

The first thing that comes to mind, you have one or more indexes on the table that periodically rebalance their b-trees. As the table gets larger, the rebalancing can occur more often and take longer.

In article <6lgip5$ke1$1_at_nnrp1.dejanews.com>, qutub_at_hotmail.com wrote:
>
> Hi there,
>
> I have a 2GB table, in the starts when this table creates, the inserts are
> very fast but after few days the same insert become very very slow. what
> coluld be the reason?
>
> Is there any recommended size of oracle tables ?
>
> Any help will be appreciated.
>
> Abdulla
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 08 1998 - 13:52:27 CDT