| Table with 40 million records problem [message #615108] |
Fri, 30 May 2014 05:35  |
 |
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 #615898 is a reply to message #615108] |
Tue, 10 June 2014 20:21  |
 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
