Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Making a for loop parallel instead of serial - trolling for ideas
For years I have assumed that my nightly exports of ten Oracle databases
(one node) had to process sequentially -- perhaps because my Korn for loop
was working, I left it alone.
Unfortunately, I've become curious of late, and my theory is that the O/S should be capable of handling multiple export streams concurrently. Obviously I can "nohup" a shell script one after another. What I'm missing is the technique of running through that "for" loop without having to embed the (former) for logic into another script. For example, I'm presently doing a for loop that sets my SID and OH, then launches export with a parameter script. I do not wish to go back to having one hardcoded script for each of these databases -- obviously.
Anyhow, does anyone care to comment whether or not this seems feasible, or if I'm overlooking a better approach?
TIA,
dvz
Received on Mon Apr 15 2002 - 20:14:51 CDT
![]() |
![]() |