Home » Infrastructure » Unix » Terminating an Oracle procedure from Unix
Terminating an Oracle procedure from Unix [message #97173] Fri, 04 January 2002 07:26 Go to next message
Elizabeth
Messages: 6
Registered: January 2002
Junior Member
Hi,

I am encountering the following problem.

I have this script that i execute as a background process on unix. The script internally invokes a java program that calls PL/SQL procedures in oracle8.0.4.3.0. When I kill the process I am not sure if the executing stored procedures are also killed. Is there a way to check this and terminate the procedures if required (using a unix script).

Thanks in advance,
Elizabeth

----------------------------------------------------------------------
Re: Terminating an Oracle procedure from Unix [message #97183 is a reply to message #97173] Tue, 08 January 2002 10:17 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You should be able to get most of the info you are looking for by quering v$session (and v$process) based on the Unix process ID of your background job (you can capture the process id of the background job in a shell script).
Previous Topic: installing
Next Topic: Alternative OS (NOT Linux) for INTEL for Ora9i - is it possible?;-)
Goto Forum:
  


Current Time: Sun Sep 27 02:14:29 CDT 2020