| Machine's name. [message #371450] |
Fri, 20 October 2000 12:54  |
Luis Gabriel
Messages: 11
Registered: October 2000
|
Junior Member |
|
|
Hi,
I try to get then name or IP for the machine from which a user is connected to oracle, like lgreyes.rzs.itesm.mx or 132.254.3.125.
Does somebody know how can I get this???.
|
|
|
|
| Re: Machine's name. [message #371451 is a reply to message #371450] |
Fri, 20 October 2000 13:51  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
See this example of what you can get. You need to have "select on any table" priv:
SELECT s.username "User Name",
s.osuser "OS User",
s.program "Program",
s.machine "Machine",
p.program "P Program",
si.physical_reads "Physical Reads",
si.block_gets "Block Gets",
si.consistent_gets "Consistent Gets",
si.block_changes "Block Changes",
si.consistent_changes "Consistent Changes",
s.process "Process",
p.spid, p.pid, s.serial#, si.sid
FROM sys.v_$sess_io si, sys.v_$session s, sys.v_$process p
WHERE s.username IS NOT NULL AND
si.sid(+)=s.sid
AND p.addr(+)=s.paddr
ORDER BY status,si.consistent_gets+si.block_gets DESC
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
