I am oracle devloper currently i get a chance to work on shell scripts to run sql statements.
extarct.txt contains 15 .sql files, want to using loop continue three times,first it should take 1 to 5 next 5 to 10 and last 10-15
I can't run all the .sql file in single run to avoid deadlock condition.
So, I think you mean you want to run 1-5, then 6-10, then 11-15.
Can you use split to create 5 line input files? You can loop round the files you have generated and submit jobs in the background for each then wait for them all to complete. That is one way.
Another way might be to read the whole file as a single loop, but you might hit problems if your record count is not strictly divisible by 5.
Yet another way (but a logical change) would be to read the file in as a single loop and start 5 jobs. Then watch those jobs (get the background process id from $! just after it is launched) and when one finishes, start another. This way you will have 5 jobs running always rather than one long running job stopping all the others, but it depends if that's what you want your logic to do. It is a structural difference which may not be what you want.
Can you clarify what you want it to do?
I presume you are writing this in ksh or are you using bash or something else? This is usually considered better as a loop to prevent anything within the loop from reading (eating up) your input file data:-
I also don't think that echo is a command for within sqlplus. Perhaps !echo might do the display or perhaps SELECT $name FROM dual ; would also do it.
Oracle does (seems to) have some PARALLEL execution Features ever since version 7.1. Do you want to deploy those or do you want to run five sqlplus *nix processes in background (as rbatte1 proposed)?
Hi all,
i developed a script to measure the uptime of a process in a Solaris 10/11 environments.
All is well, but i came across a situation where there are multiple processes of the same name. Basically i have the following result file:
beVWARS 13357 19592122
beVWARS 14329 19591910... (4 Replies)
Hi,
I want to read file multiple times. Right now i am using while loop but that is not working.
ex.
While read line
do
while read line2
do
echo stmt1
#processing some data based on data.,
done < file2.txt
done < file1.txt # This will have 10... (4 Replies)
Hello All,
Maybe I'm Missing something here but I have NOOO idea what the heck is going on with this....?
I have a Variable that contains a PATTERN of what I'm considering "Illegal Characters". So what I'm doing is looping
through a string containing some of these "Illegal Characters". Now... (5 Replies)
Hi, I was debating if I should put this in the dummies or scripts section, I apologize in advance if I chose poorly.
Fairly new to Unix and BASH scripting but I thought I made it fairly well given my limited understanding. However, the output indicates that it's looping and I'm ending up with a... (5 Replies)
Hi,
hope I am posting in the right section.
My problem is that I have 2 or more arguments passed and I want to check if the arguments passed exists or not.
The first argument should not exist and the remaining others should exist.
example:
./shells.sh argument1 argument2 argument3
... (5 Replies)
Hi all
Sorry for the basic question, but i am writing a shell script to get around a slightly flaky binary that ships with one of our servers. This particular utility randomly generates the correct information and could work first time or may work on the 12th or 100th attempt etc !.... (4 Replies)
Hi Im running this script, which is supposed to find the max value build some tables and then stop running once all the tables are built. Thing is , it keeps assigning a null value to $h and then $g is null so it keep building tables i.e. testupdateNUL. How can I stop this? Here is what I have:
... (4 Replies)
I'm trying to understand if it's possible to create a set of variables that are numbered based on another variable (using eval) in a loop, and then call on it before the loop ends.
As an example I've written a script called question (The fist command is to show what is the contents of the... (2 Replies)
Sorry for such a dreadful title, but I'm not sure how to be more descriptive. I'm hoping some of the more gurutastic out there can take a look at a solution I came up with to a problem, and advice if there are better ways to have gone about it.
To make a long story short around 20K pieces of... (2 Replies)