用这个sql试试select sys.utl_inaddr.get_host_address(substr(machine,instr(machine,'\',-1)+1)) ip_address,a.* from v$session a