Look up 'ALTER SYSTEM KILL SESSION "sid,serial"' You can get sid and serial from sys.v_$session
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:23 AM To: [email protected] 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.
