How to configure Oracle execute concurrently ?

Question

4.00/5 (1 vote)

See more:

Hi everybody,

I've developed an application that need to to insert a lot of data at a time and also need speed. If i i insert data sequentially, it run very slow. So, i 've create some Thread (about 30 threads, use ThreadPool) for inserting. But the speed is not imporoved. It is even slower than when i insert sequentially. How to solve this? are there any options while installing for concurrently insert?

Currently, I use Oracle 10g (10.2.0) on Windows 7 64bits and i've installed it with basic option(default option). Do i have to change to Oracle 11g? If need, i'll change.

-------------------------------------------------------------------
It's seem faster when i create 30 Oracle account. Then, each thread uses an account to connect to Oracle and execute some insert statements. Is this a right method??

Posted 12-Jun-11 1:35am

thanhvinh0906

Updated 12-Jun-11 6:06am

v4

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2011-06-12T04:37:00

Solution 1

Adding threads won't help you. Adding more threads than you have cores is even worse.

Changing the client version won't make anything faster. The problem is with your technique.

Setup your data in whatever container you need to to use Oracles Bulk Insert[^].

Posted 12-Jun-11 4:37am

Dave Kreskowiak

Comments

thanhvinh0906 12-Jun-11 12:03pm

It's seem faster when i create 30 Oracle account. Then, each thread uses an account to connect to Oracle and execute some insert statements. Is this a right method??

Dave Kreskowiak 12-Jun-11 12:13pm

No, it's not. I just got done telling you that.

thanhvinh0906 12-Jun-11 13:10pm

But, in my situation, It's faster. I don't know why. If i use just one connection to execute all store procedure (i use store procedure to insert data), it takes from 3 to 4 seconds. When i use about 10 connections, it takes about 900 miliseconds to 2 seconds. I've tested it many times. Can you explain it for me? Thank you very much!

Dave Kreskowiak 12-Jun-11 15:06pm

You want it to go faster, correct? Ditch the threads and use bulk insert.

thanhvinh0906 13-Jun-11 2:41am

Thank you! I'll try it

thanhvinh0906 13-Jun-11 6:50am

Thanks, i've used bulk insert. It's faster than i expected. Great!

RakeshMeena 24-Jun-11 2:45am

My 5!

Srinivas Kumar Pasumarthi · Answer 2 · 2011-06-12T04:46:00

Solution 2

if u want to improve performance of ur application

u require to use stored procedures to interact with database

not only that

make some settings in configuration file

use 'compilation = false' to dont make compilation every time when u hosted on internet

Posted 12-Jun-11 4:46am

Srinivas Kumar Pasumarthi