Re: find disconnected sessions

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 16 Jan 2003 18:57:27 +0100
Message-ID: <thsd2v0vc4inn054a23p8tdsoevrqgvktd@4ax.com>

On Thu, 16 Jan 2003 13:21:56 +0100, "Hartmut Wieczorek" <hwieczorek_at_meyermeyer.de> wrote:

>thnx for help it works, me fool ;)
>
> best regards
> Hartmut
>
>
>
><alifiemylarder1_at_hotmail.com> schrieb im Newsbeitrag
>news:3E269398.1663BD65_at_hotmail.com...
>> select ....
>> and sysdate = LOGON_TIME
>>
>> can't return anything since LOGON_TIME is unlikely equal to SYSDATE (the
>> precision is one second), instead use
>>
>> select ....
>> and trunc(sysdate) = trunc(LOGON_TIME)
>>
>>
>>
>> Hartmut Wieczorek wrote:
>>
>> > Hi All
>> > my problem is to find all the disconnected oracle sessions to kill them.
>...
>
>> > whats wrong ? can somebody help me?
>

Actually you would better use the last_call_et column. This column stores how many seconds elapsed since the last command was executed.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jan 16 2003 - 11:57:27 CST