Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> SQLDBA sessions
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;Received on Fri Jan 19 1996 - 16:24:42 CST
!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.
![]() |
![]() |