cancel
Showing results for 
Search instead for 
Did you mean: 

sqlloader multithread issue

hzabin
Occasional Advisor

sqlloader multithread issue

i have 8 cpu but when using sqlldr we find the main thread is 1 & load thread 0
how i can modify these parameters
5 REPLIES
Horia Chirculescu
Honored Contributor

Re: sqlloader multithread issue

Hello,

You should read:

http://www.macs.hw.ac.uk/dept/facil/guides/oracle_9i/doc/server.901/a90192/ch09.htm#1008017

"In this example, the SQL*Loader load thread has offloaded the SQL*Loader main thread, allowing the main thread to build the next stream buffer while the load thread loads the current stream on the server.

The goal is to have the load thread perform as many stream buffer loads as possible."

Best regards,
Horia.
Best regards from Romania,
Horia.
hzabin
Occasional Advisor

Re: sqlloader multithread issue

I'm raed it before , actually I don't how to implement it
hzabin
Occasional Advisor

Re: sqlloader multithread issue

dear sir ,
for more explain my isuee is execute multi sqlloader in same time for multi files, to solved it i did as following steps
create 4 oracle jobs to call sqlldr command
but when see the task manger i found the 4 sqlldr.exe as queue first request first out (waiting time to execute next sqlldr )


but i want executing at same time.


hzabin
Occasional Advisor

Re: sqlloader multithread issue

how i can change the thread in windows
Horia Chirculescu
Honored Contributor

Re: sqlloader multithread issue

I have no idea if you can do this in Windows.

Those settings are based on the operating system facilities.

You opened this thread on HP-UX.

Best regards,
Horia.
Best regards from Romania,
Horia.