machine name

[hnetscape]

how can i find out the ip address or machine name on which i have been connected to oracle. I am able to find the how many machines and which user is connected to oracle from v$session view but i can't find the machine name. Please help me.

[julian]

Run the following in SQL+:

SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') "My IP Address" from dual;

[hnetscape]

thanks for the reply but I am getting the error

SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') "My IP Address" from dual
*
ERROR at line 1:
ORA-00904: invalid column name

Originally posted by julian
Run the following in SQL+:

SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') "My IP Address" from dual;

[nabaig]

The column Machine in v$session view gives the name of the machine.

Nizar.

[hnetscape]

How do I know that which is the correct machine name among the list. It will show all the machine name.

Originally posted by nabaig
The column Machine in v$session view gives the name of the machine.

Nizar.

[julian]

This means that your Oracle version is below 8i.

[nabaig]

Link this with OSUSER column.

Nizar

[pst]

Do a

select username "Oracle Username",osuser "OS Username",
machine from v$session;

With this you can use your username name to find out on which machine you are logged on.

hope that helps.

[hnetscape]

Yes, but is there no way of solving the problem

Originally posted by julian
This means that your Oracle version is below 8i.

[Raminder]

select unique(machine) from v$session where schemaname='SYS';