I don't know about Solaris but on HP-UX and AIX you can do:
run_sql_1 &
run_sql_2 &
wait
This will wait until both have finished.
Re a specific PID $! will return you PID of the last child process and then
you can wait on that PID. Looks something like:
run_sql_1 &
run_sql_2 &
PID_WAIT=$!
wait ${PID_WAIT}
HTH
Chris Dunscombe
-----Original Message-----
Sent: 27 October 2003 16:09
To: Multiple recipients of list ORACLE-L
I need to parallelize some sql operations and Im running them from unix
scripts.
I want to spawn off a few in the background from a master script, then have
the master script 'wait' for them to finish. Ive done this in Java and with
dbms_alert, but I cant dig up the syntax to do this with korn shell on
solaris.
Also, if I want to wait for a specific PID, how do I get the PID of the
thread I want to wait for?
so I have
nohup run_sql &
wait(on previous nohup)
then to use notify, I just use 'notify()' inside the script right?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dunscombe, Chris
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).
