Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alternative SQL command to Dead Connection Detection ?
miam wrote:
> Hello
>
> From my administration program connected to an Oracle database, I want to
> probe another session, to know if it is dead or not at this time, but
> without enabling the SQL*Net's Dead Connection Detection.
>
> Does any SQL command exist to do that ?
> For example, something like "ALTER SYSTEM ..."
>
> I didn't find this in the documentation, and I'm afraid it couldn't exist...
>
> Thanks...
Could STATUS from v$session possibly do what you want?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Apr 21 2004 - 08:43:50 CDT