Hello!!!.... please, I need a query that returns me the ip addrress of the PCs connected at this time
you can get the DNS name of the machine :
select username, machine from v$session
where audsid != 0
(audsid = 0 is for Oracle BG processes)
nevertheless to get the IP address, I guess you'll have to use an OS function ...
OS check is the best way to check your IPS
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width