RE: dbi, can kill an oracle job?

Look up 'ALTER SYSTEM KILL SESSION "sid,serial"'

You can get sid and serial from sys.v_$session

-----Original Message-----
From: oldyork90@xxxxxxxxx [mailto:oldyork90@xxxxxxxxx]
Sent: Friday, May 16, 2008 10:23 AM
To: dbi-users@xxxxxxxx
Subject: dbi, can kill an oracle job?

oracle 101 guy

env: oracle 9i, linux, perl dbi, apache, webpages with javascript

Executing a sql statement from a browser with perl and dbi.

Can we kill the job? There are two main scenarios where the option to
kill might be nice. The user leaves the browser and, two, box
resources get to a point where it is no longer useful to try and
finish the job (excessive load on the box).

Suggestions? I've never killed an Oracle job before. I assume dbi
has a way to get a process/job number and the facility to kill it ...
right?

Thank you.
.