OCI/Pro*C Method For ALTER SYSTEM KILL SESSION

All,
I'm posed with a problem. I have a particular middleware product that likes to leave dead processes around with connections to ORACLE. I've written a Pro*C program that checks the IP address and sends a ping (ICMP ECHOREQUEST) to the machines and if they are indeed turned off (PCs), then it kills the associated process on the server. What I'd like to do, and I've attempted this with Pro*C to no avail, is to have this program issue an ALTER SYSTEM KILL SESSION 'sid, serial#' first, and then kill the process. Pro*C doesn't allow me to do this (as ALTER SYSTEM isn't supported in Embedded SQL). My option is to attempt this in OCI (the ALTER SYSTEM method).

Here are my 2 questions...

1. Can this be done with a kill signal to the oracle process... I don't want to send a KILL -9 to the process.
2. OR can this be done using OCI and just calling ORACLE directly and issuing the ALTER SYSTEM method which I'd like to use.

Thanks for any replies

darrin_at_ids.net
darrin_at_mit.edu Received on Fri May 26 1995 - 00:00:00 CEST