Re: logon-timeaccount

From: Mathew <mathewgearon_at_hotmail.com>
Date: 2000/05/03
Message-ID: <8epk22$afr$1@nnrp1.deja.com>#1/1

Thorsten
The v$session view has a column "logon_time". Use this together with sysdate and it should give you the connect time for each user.

Mathew.

In article <8epafd$ud0$1_at_nnrp1.deja.com>, thorsten2103_at_my-deja.com wrote:
> Hallo,
>
> it´s possible to count the connect-time per user to the database ?
> If yes, how ?
> We use Oracle8.0.5 on NT.
>
> Thanks.
> Thorsten
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 03 2000 - 00:00:00 CDT