Michael - I have noticed the same issue you describe - ie. after the sqlplus process terminates, the shadow process continues to completion (assuming there is a COMMIT in the script). We are also on Compaq Tru64, but Oracle 8.1.6. I have only noticed it, not had a reason to dig in and investigate. I suspect that the shadow process is getting reparented to root. You might consider changing your kill to a kill -9. Or locate the shadow process and kill it, maybe first. Just some ideas, hopefully someone has more direct experience. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED]
-----Original Message----- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L > Maybe one of you has some inspiration. > Environment: Compaq Tru64 5.1; Oracle 8.1.7.3 > The concept is for a parent Korn shell to spawn a sqlplus child in > background (which will validate table structure via a PL/SQL Block) then > wait for a fixed time period before stopping/killing the sqlplus child. > After the sqlplus child is stopped some follow-up processing is needed to > "bookmark" where the sqlplus processing has stopped. > > My quick test script so far look like: > #!/bin/ksh > echo "Starting val_asc, spawning at " $(date) >> val_asc.out > sqlplus xxxxx/xxxx @val_asc3.pls >> val_asc3.log & valpid=$! > sleep 240 > kill -KILL %1 > echo "Leaving val_asc at " $(date) >> val_asc.out > exit > When the sqlplus line runs it starts 2 processes: > oragdv 169035 167185 0.0 10:00:20 pts/1 0:00.18 sqlplus > oragdv 169652 169035 0.0 10:00:22 ?? 0:00.13 oracleGDV > (DESCRIPTION=(LOCAL=YES). . . > The problem is when the kill command executes, only the first of these 2 processes is killed immediately. The 2nd (with the PPID at 1) continues processing until the PL/SQL Block completes (including database updates) before it terminates. > Here's the question. Is there a straightforward way to terminate that 2nd > process before starting post processing? > > Any suggestions would be appreciated as I have been bashing my head > against the proverbial wall for several days now ;) I have used the $! parameter to id the sqlplus PID and have been fiddling with ps & awk to try and obtain the 2nd process's PID but have yet to be successful > Michael Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
