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

Thread: User Access status from Task Manager..?

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Hi Gurus,

    I am running Oracle 805 Database on win-nt, From the win-nt TASK MANAGER screen, how will I know the number of users are accessing my Database right now?.

    Regards
    Anandharaj
    a_anandharaj@yahoo.com

  2. #2
    Join Date
    Oct 2000
    Posts
    467
    Since NT is thread based all you can see is ORACLE.EXE running in the background. For that matter, u cannot see the background processes as well. For the connected users, u have to use the v$session where type != 'BACKGROUND'.
    Vinit

  3. #3
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Hi vinit, Thank you for your reply.

    but, Normally user try to connect the database from client using sqlplus tool (plus33.exe) or some other tools with the parameters of username, password and host string.... It means plus33.exe or other_tools.exe is executed...correct..?
    then why it is not showing in the Task manager of the oracle NT server..?

    Clarification regarding this, will be appriciated ?

    Regards
    Anandharaj
    a_anandharaj@yahoo.com

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    Assuming the user sessions are connecting to the DB using client on their PCs, the plus33.exe will be appearing on their Task manager and not of the server.
    Don't have much idea about other_tools.exe.
    Vinit

  5. #5
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Hi Vinit

    Thank you very much.
    Other tools, which I specified are:
    TOAD.EXE, PLSQLDEV.EXE etc...

    Regards
    Anandharaj
    a_anandharaj@yahoo.com

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