User Access status from Task Manager..?

[anandharaj]

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

[vinit]

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'.

[anandharaj]

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

[vinit]

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.

[anandharaj]

Hi Vinit

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

Regards