Oracle Performance Degradation at Large Table sizes

From: enigma <mabounajm_at_gmail.com>
Date: 21 Feb 2007 01:24:29 -0800
Message-ID: <1172049868.948282.142890@k78g2000cwa.googlegroups.com>

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. Can you point me to a study on oracle performance?

Does RAID have to do with this?

I appreciate any initial direction that could help me start narrowing down the problem.

Thank you. Received on Wed Feb 21 2007 - 03:24:29 CST