Re: The number of connection to the database oracle
From: Conan <conan_at_>
Date: Wed, 6 Sep 2000 18:18:09 +0100
Message-ID: <1%ut5.21433$r4.11395_at_news.indigo.ie>
Date: Wed, 6 Sep 2000 18:18:09 +0100
Message-ID: <1%ut5.21433$r4.11395_at_news.indigo.ie>
Provided you have access to the correct views
select count(*) from v$session
where username='TOTO'
/
HTH
conan
OJ wrote in message <8p5o2j$1jf8$1_at_news4.isdnet.net>...
>Hello
>how can I get back the number of connections (sessions) on a database where
>the login is 'TOTO' for example.
>
>Any ideas?
>
>thanks!
>
>Olivier.
>
>
>
>
>
Received on Wed Sep 06 2000 - 19:18:09 CEST