View the terminal IP address of the Oracle server

Many people think that it is not practical to view the terminal IP address connected to the Oracle server. If it is only a data server, it is useless. If there is a central server and a distributed server, it will reflect its role. Specific procedures:

Select sys_context ('userenv', 'IP _ address') from dual;

Select utl_inaddr.get_host_address (terminal) from v $ session;

Select hostname from v $ session;

Ping hostname;

In the system that was previously in charge, the data on the database server needs to be extracted by data servers on multiple other nodes. Therefore, when a database server encounters a problem, you cannot always send someone to perform on-site maintenance, because each database server is located in other cities, you can only remotely connect to the database, view the ip address of the node database, and use the legendary plsql to solve the problem, travel, labor, and time savings for the company.