Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find the ip address of the user?

VPSAug 21 2007 — edited Aug 21 2007

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2007
Added on Aug 21 2007
11 comments
1,242 views