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]
Subject: RE: wait/notify syntax for unix help please
I don't
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
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 from
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
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
jobs
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 $! will return you PID of the last child process and then
you can wait on that PID. Looks something like
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
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 Unix IDE
PROTECTED] Sent: Tuesday, October 07, 2003
10:24 PMTo: Multiple recipients of list ORACLE-LSubject:
Unix Help
Hi,
Sorry for the
slightly non-Oracle post.
I am after a
UNIX code snippet that will help me copy archive logs to another directory BUT
not if they already exist
Title: Message
Or was
it that we just ignored your post? ;o)
Dave
-Original Message-From: Sujatha Madan
[mailto:[EMAIL PROTECTED]Sent: Tuesday, October 07, 2003
11:29 PMTo: Multiple recipients of list ORACLE-LSubject:
IGNORE: Unix Help
Sorry ... but I solved
Title: Message
Hi,
Sorry for the
slightly non-Oracle post.
I am after a UNIX
code snippet that will help me copy archive logs to another directory BUT not if
they already exist. So if only 2 archive logs are generated between script runs
only the two new ones should copy. I know I can do
Title: Message
Sorry
... but I solved it.
Cheers
Sujatha
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Sujatha MadanSent: Wednesday, 8 October 2003 1:24
PMTo: Multiple recipients of list ORACLE-LSubject: Unix
Help
Hi,
Sorry
I have this unix script, please tell me how to change it so it also does the following:
counts the time between start time and end time of the process(I mean time difference
between Jobb startat(Job started) and Job Klart(Job Finished).
loadbilbo.sh:
#!/bin/sh
. /usr/bin/orasetup.sh
.
Yawn...
-Original Message-
Sent: Tuesday, April 16, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L
I have this unix script, please tell me how to change it so it also does the
following:
counts the time between start time and end time of the process(I mean time
difference
Alan,
What do you mean the file is to large for vi? If you are going to string the lines
together be sure that you don't overrun the linitations of the server input line
length. If you need to have continuations in the line I think that the \ tells the
server the command is continued on the
Title: UNIX help needed for sed multi-line pattern space
Alan,
Why not use awk?
cat filename | awk '{if (
substr($0,length($0),1) == ";") {print " " $0 } else {printf($0)
}}'
Hope this helps
Chris
-Original Message-From: Martin, Alan
[mailto:[EMAIL
16 matches
Mail list logo
