oracle 从 SQL*Plus 获取 ip 和端口
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/17325145/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-19 01:45:32 来源:igfitidea点击:
Get ip and port from SQL*Plus
提问by Jon Heller
I have Oracle 10g
我有 Oracle 10g
SQL> show addressIP + PORT
Is it possible to show address IP + port of machine from SQL*plus?
是否可以从 SQL*plus 显示地址 IP + 机器端口？
回答by Jon Heller
select sys_context('userenv', 'ip_address') ip_address, port
from gv$session
where gv$session.inst_id = sys_context('userenv', 'instance')
and gv$session.sid = sys_context('userenv', 'sid');
