Home » RDBMS Server » Performance Tuning » Table with 40 million records problem
Table with 40 million records problem [message #615108] Fri, 30 May 2014 05:35 Go to next message
viba1987
Messages: 3
Registered: May 2014
Location: Chennai
Junior Member
Hi ,

I have got a table with 40 million records . when we perform the operations of write ( 12000 inserts ) and read ( all 40 million records for a rule engine processing ) simultaneously , facing degraded performance ( Write takes more than 20 minutes and Read is taking long time ) . How can I increase the performance. Thanks in advance!

Info : Oracle DB server running with 4 GB of RAM .

[Updated on: Fri, 30 May 2014 05:39]

Report message to a moderator

Re: Table with 40 million records problem [message #615109 is a reply to message #615108] Fri, 30 May 2014 06:02 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
With such less information posted(guess to keep it precise, isn't it?), the only suggestion would be to increase the hardware configuration.

To proceed further with help/assistance, have a look at the sticky on top of this forum and post the required details.

[Updated on: Fri, 30 May 2014 06:03]

Report message to a moderator

Re: Table with 40 million records problem [message #615110 is a reply to message #615109] Fri, 30 May 2014 06:03 Go to previous messageGo to next message
viba1987
Messages: 3
Registered: May 2014
Location: Chennai
Junior Member
Yes Lalit . Just wanted to make it precise . Can you please let me know what more info needed so that i can share the same.
Re: Table with 40 million records problem [message #615111 is a reply to message #615110] Fri, 30 May 2014 06:04 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
viba1987 wrote on Fri, 30 May 2014 16:33
Can you please let me know what more info needed so that i can share the same.


Read http://www.orafaq.com/forum/t/84315/
Re: Table with 40 million records problem [message #615898 is a reply to message #615108] Tue, 10 June 2014 20:21 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
12K inserts (12 thousand rows) should take all of 2 seconds on most Oracle databases unless you are doing something wrong. Since you have provide 0 information on your load process and your rule engine processing and the processes that this rule engine supports, we can only provide basic generalized information about performance.

What is the insert time for just the 12000 seconds?

Have you have a looks at the wait events ?

Have you checked DBA_BLOCKERS and DBA_WAITERS to see if you are waiting on locks?

When you say insert do you really mean insert?  Or do you have a complex load process doing manual validation and row-by-row processing, and maybe home grown auditing via user coded triggers?  Or maybe other stuff you have not told us?

How long did you expect it to take to process 40 million rows?  What kind of processing do you do with these rows?

With out these kinds of details, there is little we can do for you.

Kevin
Previous Topic: Staging table without indexes, slow queries
Next Topic: Indexing and Tuning
Goto Forum:
  


Current Time: Thu Mar 28 09:29:57 CDT 2024