RE: http:[EMAIL PROTECTED]/msg08566.html http:[EMAIL PROTECTED]/msg08567.html
It was suggested to capture the PID in order to kill any abandoned queries. This appears to work if the web server, web app, and database are all on the same machine. However, it doesn't seem so if the web server and database are on different machines. What we've noticed is that when we kill the web app PID, the database query process still remains active. Yet, when we directly kill the database query PID, the web app PID is automagically killed. Is there any way through DBI to do this? In other words, do I really need to get the DBA involved? Any suggestions for an elegant way of handling this issue? Web Platform: HP-UX Netscape Enterprise DBI DBD-Oracle Database Platform: HP-UX Oracle 8 Thanks in advance, Anna -------------------------------------------------------- Anna Q. Fong, Webmaster California Data Exchange Center
