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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Unix Question

Re: Unix Question

From: Mladen Gogala <mladen_at_wangtrading.com>
Date: Wed, 26 May 2004 09:55:17 -0400
Message-ID: <20040526135517.GC1433@mladen.wangtrading.com>


Actually, I think that shell is not the right tool to do so. Any programming language (including the scripting ones like Java, Perl or Python) has facilities to run jobs in background and communicate either by using SYSV IPC, pipes or some fancy queueing software like MQ-Series, Rendesvouz or Oracle AQ. The problem that Ryan has comes from trying to solve it with the wrong tool, like forcing the proverbial square peg through the round hole. Not everything can be solved by hammer, duct tape and WD-40. Shell is the right tool for interactive stuff and has only rudimentary programming abilities. It's not meant to be a "fix it all" programming solution. Multithreading with threads communicating with each other is something that should be done by specialized scripting languages.

On 05/26/2004 09:31:54 AM, "Powell, Mark D" wrote:
> Here is an idea. Add a write to a dbms_pipe to each script that sends the
> task return code to the pipe reader. Now add one more script that opens the
> pipe for read and goes into a loop: read, sleep until all tasks have
> registered. When all tasks have registered thier ending status then this
> monitoring task exists success otherwise it fires off an error message and
> exists failure.

-- 
Mladen Gogala
Oracle DBA



Note:
This message is for the named person's use only.  It may contain confidential, proprietary or legally privileged information.  No confidentiality or privilege is waived or lost by any mistransmission.  If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender.  You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed May 26 2004 - 08:52:10 CDT

Original text of this message

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