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
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 it
[mailto:[EMAIL 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
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
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
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 betwee
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
. /d31/ap
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
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 n
Title: UNIX help needed for sed multi-line pattern space
If I have the following two-line sql statement in a file:
SELECT A,B,C FROM TABLE1
WHERE A=1;
and want to create a single line, I could use the following sed script:
/[^;]$/{
N
s/\n/ /
}
which would produce:
SELECT A,B,C
17 matches
Mail list logo