oracle查询历史运行sql

select sql_text,a.sql_id,sample_time,sql_opname,machine from v$sql a ,dba_hist_active_sess_history b where a.sql_id = b.sql_id

查询历史sql

select utl_inaddr.get_host_address('dbpay') from dual;

把主机名转换成ip

(主机名需要在hosts文件内)