Re: Number of sessions
From: gazzag <gareth_at_jamms.org>
Date: Fri, 1 Feb 2008 08:30:51 -0800 (PST)
Message-ID: <e03f3bef-453b-4a77-9004-7d9408c58356@s19g2000prg.googlegroups.com>
Date: Fri, 1 Feb 2008 08:30:51 -0800 (PST)
Message-ID: <e03f3bef-453b-4a77-9004-7d9408c58356@s19g2000prg.googlegroups.com>
On 1 Feb, 15:30, suri <suriawan.limant..._at_googlemail.com> wrote:
> Isn't it so, that V$SESSION shows only the current running session? or
> it contains the sessions, that are ever connected since DB startup?
>
> Thanks,
> Suriawan- Hide quoted text -
>
> - Show quoted text -
You are correct.
Have you considered a database logon trigger to help gather the data you require?
HTH -g Received on Fri Feb 01 2008 - 10:30:51 CST