Re: Number of DB connections

"Becky Innocent" <becky.innocent_at_platinum.com> wrote:

>Any idea how (which statement to use) to get the number of current
>connections to a database?
>
>Thanks a bunch.
>
>

From SqlPlus you could do:

select count(username) from sys.v_$session where type = 'USER' and username is not null;

Hope it helps.... Received on Tue Jul 14 1998 - 14:18:07 CDT