Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unanswered: Identity My Session - onstat -u


    I have a multi-user application connecting to the database.
    As such, the user id would all be the same for all the connections.

    Running onstat -u would list all the sessions connecting
    to the database. But the issue is, how can we identity which
    is user1, user2, etc session?

    Please advise.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2005
    onstat -g ses shows only the sessions...
    onstat -u shows also session's threads,

    If your application connects with only one user name, you can't find out, which session is user1, user2 etc.
    But in generally, one session stands for one user(also depends on your application). If your users are connecting from different hosts, column 'hostname' in 'onstat -g ses' may help you.

Posting Permissions

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