oracle中如何查看数据库服务器的ip地址

SELECT INSTANCE_NAME, HOST_NAME, VERSION, STATUS, INSTANCE_ROLE, THREAD#, ARCHIVER, LOG_SWITCH_WAIT, LOGINS, SHUTDOWN_PENDING, DATABASE_STATUS, INSTANCE_MODE, ACTIVE_STATE, BLOCKED, CON_ID, INSTANCE_ID, HOST_IP_ADDRESS
FROM V$INSTANCE;