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

Home -> Community -> Mailing Lists -> Oracle-L -> SQLDBA sessions

SQLDBA sessions

From: Bambi Bellows <Bambi_Bellows_at_PO.CHI02_at_SMTPLINK.INFORES.COM>
Date: Fri, 19 Jan 1996 14:44:51 EST
Message-Id: <9601192124.AA19665@alice.jcc.com>

     Greetings, Fellow OraHax!!

     I am currently running v7.x on AIX, SunOS and HP-UX, with other
     Unii to follow at some point in time.  I am writing a horrendously
     complicated script which generates another horrendously complicated
     script to be fed through SQLDBA.  The SQLDBA script is of the
     format:

     do_sql_action;

!do_unix_action
do_some_more_sql_stuff;
!do_some_more_unix_stuff
more_sql; more_sql; still_more_sql;
!more_unix_junk
!and so on ad nauseum
exit So far, to the best of my analysis, the SQL script waits for the subprocess to complete before issuing the next statement (SQL or Unix). And, this is fine by me, 'cuz I need synchronous processing on this one. Has anyone, on ANY UNIX platform, seen the subprocess submitted asynchronously (or spawn/nowait for you VMSheads) ?? This, of course, begs the secondary question: if I *needed* asynchronous processing, is there anyway to tell SQLDBA to do that ?? Extra credit awarded to anyone answering both questions... Bambi.
Received on Fri Jan 19 1996 - 16:24:42 CST

Original text of this message

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