monitoring users in ODBC connections

[Carlos Uribe]

+How can I monitor OBDC users (and its proccess)connected to an Oracle (7.3.4.4) database, in a D370 server 10.20 from a windows client?

Top and Glance don't show this kind of connections, +Have the operating system any other option?

[Steve Slade]

Carlos,

You can use the V$session table to find which users are your application users. It contains the field, program, which names the program, (the application, used to connect to the database.

The view is accessed, by default, by the dba. However, they can give you access by giving you select access on v_$session.

[Alexander M. Ermes · Accepted solution]

Hi Carlos.
Another chance is the Oracle Enterprise Manager for Windows. Try to get a Oracle 8 client install cd. The basic features including the instance manager should eb ready to install on this CD. There you have a chance
to watch these connections with a Windows Client, if you have dba access.
Rgds
Alexander M. Ermes

[CHRIS ANORUO]

If you have SQL Navigator installed and configured to query your database, this command will give you the required information.
#select terminal, machine, logon_time, username, schemaname, osuser from V$session