Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Making a for loop parallel instead of serial - trolling for ideas

Making a for loop parallel instead of serial - trolling for ideas

From: David Van Zandt <dvanzandt_at_iquest.net>
Date: Mon, 15 Apr 2002 20:14:51 -0500
Message-ID: <MTKu8.215$RO2.30122@news1.iquest.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US