DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: concurrent users

  1. #1
    Join Date
    Sep 2000
    Posts
    305

    concurrent users

    Hi Guru's


    I wanted to know one thing, How to find out how many users/clients are requesting/retring for the connection to the database at a particular time?

    Thanks in advance,
    Shailendra

  2. #2
    Join Date
    Sep 2002
    Posts
    376
    Enable Auditing for user logins

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You can try this

    at time t1

    select name,value from v$sysstat
    where name like 'logons current'


    at time t2

    the difference will be the answer you r lookin for

    regards
    Hrishy

Posting Permissions

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


Click Here to Expand Forum to Full Width