Friends,
Server:
OS: RHEL AS 3.0
DB: 9iR2
150 users:
OS: win xp
client: developer 6
here is the query i usually monitor the users....
select s.username uname, s.osuser osname, s.schemaname sname,
s.status stat, s.machine machine,s.program prg,s.module mdl,
s.logon_time lgtime,s.sid sesid,s.serial# seseno from v$session s,v$process p
where s.schemaname='PRODDB' and s.paddr = p.addr order by s.osuser,s.logon_time,s.machine
now what should i include in the above query to get the ip address of the client according to their os username?
Is it possible to get the ip address?
thanks