Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

monitoring users in ODBC connections

SOLVED
Go to solution
Carlos Uribe
Occasional Visitor

monitoring users in ODBC connections

+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?
3 REPLIES
Steve Slade
Frequent Advisor

Re: monitoring users in ODBC connections

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.
If at first you do not succeed. Destroy all evidence that you even attempted.
Alexander M. Ermes
Honored Contributor
Solution

Re: monitoring users in ODBC connections

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
CHRIS ANORUO
Honored Contributor

Re: monitoring users in ODBC connections

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
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.