User Information on the Oracle Server.

[JOSE ROBERTO BONATI]

I have oracle server (Red Hat LINUX). I wonder if there is some internal Oracle tables, get practical information User (TCP / IP) connected to the server, which has a column stating the version of Windows that you use?.

[Tim...]

Hi.

Check out the columns of the v$session view. This includes information about the clients connected to the database. You can also return session information like this:

http://www.oracle-base.com/articles/9i/ ... ort_string

Cheers

Tim...