after the process is complete, will it cause a
problem? say the PID no longer exists when you issue wait?
>
> From: "Dunscombe, Chris" <[EMAIL PROTECTED]>
> Date: 2003/10/27 Mon AM 11:39:34 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subje
Mladen Gogala scribbled on the wall in glitter crayon:
> On 10/27/2003 01:54:25 PM, [EMAIL PROTECTED] wrote:
>> if you attemp to wait after the process is complete, will it cause a
>> problem? say the PID no longer exists when you issue wait?
>
> Why don't you try it? There is this phenomenal Un
On 10/27/2003 01:54:25 PM, [EMAIL PROTECTED] wrote:
if you attemp to wait after the process is complete, will it cause a
problem? say the PID no longer exists when you issue wait?
Why don't you try it? There is this phenomenal Unix IDE called "vi"
which can help you to write a shell script and O'Re
EMAIL PROTECTED]>
> Subject: RE: wait/notify syntax for unix help please
>
> 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 $! w
Here's another idea. Expand on it and modify as needed.
COUNT=1
while [ $COUNT -le 8 ]; do
## The first jobs command is to clear out any "jobs completed"
messages.
jobs > /dev/null
if [ -z "`jobs`" ]; then break; fi
sleep 30
COUNT=$(( $COUNT + 1 ))
done
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
I know that bash has "wait" built in. It works like this:
GODOT=`ps -fu $LOGNAME|grep sqlplus|grep -v PID|perl -e 'while (<>)
[EMAIL PROTECTED] /\s+/; print "$A[1] "}'`
wait $GODOT
On 10/27/2003 11:09:25 AM, [EMAIL PROTECTED] wrote:
> I need to parallelize some sql operations and Im running them
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