Re: find disconnected sessions

From: Hartmut Wieczorek <hwieczorek_at_meyermeyer.de>
Date: Thu, 16 Jan 2003 13:21:56 +0100
Message-ID: <3e26a436$0$5366$9b4e6d93@newsread4.arcor-online.net>

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?
Received on Thu Jan 16 2003 - 06:21:56 CST