Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54

    Unanswered: How many users logged in database?

    I have Oracle 9i on Win2000. I have SQL-Plus and Enterprise Managers Console. Is there a way to check how many users logged in database?
    Thanks.
    Bruce

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246

    Re: How many users logged in database?

    for a count of users who are currently connected you can query v$session. for example, select count(*) from v$session where username is not null and username != 'SYS';
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  3. #3
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54
    Thanks Mark!

    v$session is very interesting.

Posting Permissions

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