u011525922的博客

–查询对应的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