当前位置：网站首页>oracle 查询主机名和对应的IP地址

oracle 查询主机名和对应的IP地址

2022-07-17 00:50:00 【51CTO】

--查询对应的IP地址

select count(1), machine, a.CLIENT_INFO from v$session a group by machine, CLIENT_INFO;

--查询对应的主机名、IP地址

select distinct w.machine, a.CLIENT_INFO from DBA_HIST_ACTIVE_SESS_HISTORY w, v$session a where w.sql_exec_start >= sysdate - 30

--and w.machine not in ('db2','db1')

and a.MACHINE = w.machine

---或者 select distinct w.machine, a.CLIENT_INFO from v$active_session_history w, v$session a where w.sql_exec_start >= sysdate - 30

--and w.machine not in ('db2','db1')

and a.MACHINE = w.machine

日积月累

版权声明
本文为[51CTO]所创，转载请带上原文链接，感谢
https://blog.51cto.com/u_12160691/5479555