Oracle Database Discussions

When I kill a pro*C program with the unix kill command, the Oracle session associated with the program stay active. I have to kill the session via sqlplus. Due to the fact that the session hold locks on some table, I cannot restart the program unless I kill the session manually. If I don't kille the session manually it stays active for hours

Is there any way to terminate a session automatically when the OS processs is killed ? Is pmon supposed to be in charge of this ?

setting the expire_time parameter in sqlnet.ora is not an valid option since the connection is bequeathed.


thanks in advance for your time.