Re: Oracle Performance Degradation at Large Table sizes

On 21 feb, 10:24, "enigma" <maboun..._at_gmail.com> wrote:
> Hi all,
>
> Environment: HP Proliant. Red Hat AS 3. RAID 5 (3 HD 330 GB each). 8
> GB RAM.
>
> Background: The DB is installed for a GSM operator of a big country
> and has records for all the subscribers in that country. The number of
> subscribers is increasing and we now have some tables that contain
> about 13 million entries. We are experiencing unstable performance on
> insert on all tables. sometimes an insert takes about 1.5 ms and other
> times it goes down to 500 micro seconds.
>
> Does Oracle have problems with large table sizes? Since this problem
> was not there when the number of subscribers was significantly less.

Table layout? # of indexes?

> Can you point me to a study on oracle performance?

tpm.org
>
> Does RAID have to do with this?

Sure - software based RAID5 would have a severe negative impact. What do you have?
>
> I appreciate any initial direction that could help me start narrowing
> down the problem.
>
> Thank you.
Received on Wed Feb 21 2007 - 09:35:11 CST