topic Re: sqlloader multithread issue in Operating System - Microsoft

sqlloader multithread issue

hzabin — Wed, 27 Jan 2010 07:15:18 GMT

i have 8 cpu but when using sqlldr we find the main thread is 1 & load thread 0
how i can modify these parameters

Re: sqlloader multithread issue

Horia Chirculescu — Wed, 27 Jan 2010 07:39:47 GMT

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.

Re: sqlloader multithread issue

hzabin — Wed, 27 Jan 2010 07:49:48 GMT

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

Re: sqlloader multithread issue

hzabin — Wed, 27 Jan 2010 08:00:20 GMT

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.

Re: sqlloader multithread issue

hzabin — Wed, 27 Jan 2010 12:10:34 GMT

how i can change the thread in windows

Re: sqlloader multithread issue

Horia Chirculescu — Thu, 28 Jan 2010 09:33:47 GMT

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.