select sys_context('userenv','host') from dual; 查看主机名
select utl_inaddr.get_host_address from dual;查看IP地址
(select banner from sys.v_$version where rownum=1),察看Oracle版本
select member from v$logfile where rownum=1 获得操作系统版本
select instance_name from v$instance 获得sid标示符
