OraFAQ Forum: Unix » Terminating an Oracle procedure from Unix

Home » Infrastructure » Unix » Terminating an Oracle procedure from Unix

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Terminating an Oracle procedure from Unix [message #97173]

Fri, 04 January 2002 07:26

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

----------------------------------------------------------------------

Report message to a moderator

Re: Terminating an Oracle procedure from Unix [message #97183 is a reply to message #97173]

Tue, 08 January 2002 10:17

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).

Report message to a moderator

Previous Topic:	installing
Next Topic:	Alternative OS (NOT Linux) for INTEL for Ora9i - is it possible?;-)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 05 11:01:12 CST 2025