> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
