常用的oracle命令

 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标示符

<a href="http://news.csdn.net/n/20061127/98323.html">http://news.csdn.net/n/20061127/98323.html</a>