Re: How to check the level/number of concurrent users

From: Craig M. Wall <cwall_at_petersons.com>
Date: Fri, 11 Sep 1998 09:37:38 -0400
Message-ID: <6tb8rd$st4@news9.noc.netcom.net>

Let's review the definition of a concurrent user/license...

"Concurrent Devices": the maximum number of input devices accessing the Programs at any given point in time. If multiplexing software or hardware (e.g. a TP monitor, webserver product) is used, this number must be measured at the multiplexing front-end.
http://www.oracle.com/products/free_software/html/license.html

Since all of my "input devices" (Windows 95 & NT PCs) have distinct machine names and don't connect via web browsers, Tuxedo or MTS, I use the following query to keep track of my concurrent usage.

SQL> select count(distinct machine) -1 Concurrent from v$session;

CONCURRENT

121

A single user can have dozens of connected sessions on their PC running all kinds of software connecting to the Oracle database under a variety of different usernames and it all just counts as one concurrent license.

Regards,
Craig M. Wall

Leigh Gardner wrote in message <35f7c8dd.15583662_at_news.globalnet.co.uk>...
>Is there anyway for me to check the number of concurrent users using
>my Oracle7 database in order to ensure we arent breaching our
>concurrent license maximum?
>
>TIA
>
>L.
Received on Fri Sep 11 1998 - 08:37:38 CDT