Re: has anyone used threads to parallelize bulk loads?

> Ryan wrote:
>
> I find this useful when I have large loads with alot of small to
> medium sized DML statements. Instead of running them serially I use
> DBMS_JOB and break them up into pieces.
>
> DBMS_JOB is limiting in that it can only do 36 at once per instance.
> If I want to do more, Id have to do it outside the database. I have
> read about unix 'pthreads'. These appear to have the same
> wait,notify,synchronize interface that java has. Im also on Solaris.
>
> Has anyone done anything like this? Any features on Solaris that I can
> use? I know solaris has some built-in low level C functions to handle
> locking(such as a mutex script). Any idea of some sources I can use to
> look this up?
>
> I dont need this for work right now, but I may need it in the future,
> so I want to play around with it. Or do I have to take this to a unix
> sys admin forum? If so anyone know any good ones?
>
> Threading interfaces seem to be very similiar across platforms. In
> oracle you achieve the same thing with dbms_job,dbms_lock,and
> dbms_alert.
>
> anyone got any scripts or experience with this? This is not essential.
> Im just playing around.

Ryan,

  Read the OCI manual, you have many things in it about multithreading, including a set of functions for creating threads, mutexes to synchronize them, etc. - OCI wrappers assumed to be more 'portable' - in truth I find the Posix pthread library to be as portable and simpler to use ...
 I think that you also have some sample code in $ORACLE_HOME/rdbms/demo, although I have never found the sample OCI code to be really useful to understand the finest points.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).