Re: Does setQueryTimeout() work on Oracle Thin Driver (8.1.6)

"Daniel J. Long" <longdj_at_cat.com> wrote in message news:<3B41BE5E.287CD83D_at_cat.com>...
> Hello,
>
> Our Oracle DBAs created a stored procedure for me which I can use to
> terminate a runaway query. Presumably, the "kill session" stored
> procedure is manipulating some Oracle system tables to affect this.
> Unfortunately I don't have the details on that. From my view, I request a
> "session id", like this: "select userenv( \'sessionid\' ) from dual"
> (using the Connection which has the runaway query). Then I send this
> sessionid and the logonid to the kill_session sp (on a new Connection),
> which then cleans up my runaway. In order for this to work, you have to
> be able to identify which Connection object (from your pool, for example)
> has the runaway query on it.
>
> I realize that the kill_session SP is the key. If you really need the
> details of that let me know.
>
> Good luck!
> Dan

Thanks a bunch! I'll talk to my DBAs about this.

Your help is much appreciated!
--Das Received on Sat Jul 21 2001 - 16:25:03 CDT