connection to db

User_DLBYE

dear all,

            hope all are doing well,i m new to oracle .i need your precious help, i want to know how to find that  who is connected to my database through toad? i need client machine name.

db:11.2.0.3

os:rhel 6

thanks & best regards.

Paul M.

SQL> select machine from v$session where lower(PROGRAM)='toad.exe'

  2  order by machine;

User_DLBYE

thanks for replying,i already tried this but it is giving local machine name (server name) but i want want client machine name.

Paul M.

it is giving local machine name (server name) but i want want client machine name.

Well, in my environments (mostly Linux RAC) I get the Client machine.

Gaurav_91

Hi,

The query given by Paul will return the client machine name also if any client machine is connected to Oracle database.

Andrew Brennan

Paul M's query should be displaying the client machine. If it's displaying the local server name, then either the local server is running toad (which seems unlikely), or you've encountered a bug with the v$session view.

User_DLBYE

thanks for replying.can anybody please tell me all the views which are available  in oracle database  used to identify users connection to database?

EdStevens

941949 wrote:

thanks for replying.can anybody please tell me all the views which are available  in oracle database  used to identify users connection to database?

Whenever I have a question like that, the first thing I do is go to the fine Reference Manual (for 11g, that's at http://docs.oracle.com/cd/E11882_01/server.112/e40402/toc.htm)

and start scanning the table of contents for views whose name suggests they might be a good candidate for having the data I want.  In your case, probably the v$ views.

Unknown

thanks for replying,i already tried this but it is giving local machine name (server name) but i want want client machine name.

Then you don't have any other users that are connected right now.

If you did then V$SESSION would show them and the client machine name. See the projection of V$SESSION in the Database Reference

http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3016.htm#sthref3653