on 03-27-2008 1:56 AM
Hi All,
What is the optimum time for inserting 1.5 million records to Oracle Staging Table? My scenario ECC to Oracle is taking 3 hours.
With your previous experience, what do you think about this. Is there a scope of improvement?
We have a simple insert through JDBC datatype. i.e Action = INSERT.
Kindly Advice.
Regards,
XIer
Edited by: XIer on Mar 27, 2008 9:20 AM
Edited by: XIer on Mar 27, 2008 10:02 AM
1,500,000 / (3*3600) = 138.8888889 Msgs / second
I personaly believe that the performance is pretty good. Even for the small size of messages.
Liang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Self Resolved..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ;
As the record size is big so it will take time to insert these records in the table.
Mudit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.