Re: oracle server licensing

From: Chris Hamilton <ToneCzar_at_erols.com>
Date: Mon, 05 Apr 1999 14:07:12 GMT
Message-ID: <3708c276.679306@news.erols.com>

On Mon, 05 Apr 1999 18:55:31 +1200, Michael Bamford <bambi_at_ozemail.com.au> wrote:

>Look in the alert.log file at shutdown - it gives the user conncurrent
>connection highwater mark.

The V$LICENSE table gives the following info as well:

Sessions_Max -- max # of sessions allowed (license_max_sessions in init.ora).

Sessions_Warning -- # of sessions that will cause a warning message to be written into the alert log (license_sessions_warning in init.ora).

Sessions_Current -- current # of sessions connected.

Sessions_HighWater -- max # of sessions at any one time (since last db restart).

Users_Max -- max # of user accounts allowed (license_max_users from init.ora).

Chris

---

Chris Hamilton -- toneczar_at_erols.com
Oracle DBA -- Wall Street Sports
http://www.wallstreetsports.com/ Received on Mon Apr 05 1999 - 09:07:12 CDT