Results 1 to 5 of 5

Thread: # of users

  1. #1
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86

    Unanswered: # of users

    Hello.
    I know there is an oracle tool (or application or executable) that can be used to log the # of users that connect to the DB (ie, 2 diff OS users connect using the same DB users -> 2 licences).
    I need this to solve a licence problem.
    DB version: 806, 8174, 902, 920.
    OS version: Windows, HPUX.
    Thanks in advance.
    Regards,

    Manf

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The view v$license will give you the license high water mark amoung other things.

    Column Datatype Description
    SESSIONS_MAX
    NUMBER
    Maximum number of concurrent user sessions allowed for the instance

    SESSIONS_WARNING
    NUMBER
    Warning limit for concurrent user sessions for the instance

    SESSIONS_CURRENT
    NUMBER
    Current number of concurrent user sessions

    SESSIONS _HIGHWATER
    NUMBER
    Highest number of concurrent user sessions since the instance started

    USERS_MAX
    NUMBER
    Maximum number of named users allowed for the database
    Last edited by beilstwh; 09-27-04 at 10:09.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Yes, but I can't use that view (concurrent users), cause due to not all the users connect at the same time... I need something to log info for at least two full days.
    Thanks anyway!
    Regards,

    Manf

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    You could use a system event trigger which on logon or logoff does a count of sessions from v$sessions (remember to exclude sessions belonging to oracle processes) and logs it to a table.

    http://download-west.oracle.com/docs...6a.htm#2111136

    v$resource_limit may also be useful

    Alan

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    To check your license use SESSIONS _HIGHWATER from v$licenses. This is the maximum number of users that were logged in AT THE SAME TIME. Thus if your license if for 100 users and SESSIONS _HIGHWATER = 102, you are going over your license. This highwater count is reset every time the database if bounced.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •