select to_char(sysdate,'DD-MON-YY HH24:MI:SS'), count(*),machine,program,status from gv$session wher

Dear ALL

From the below query, we used to find number of "JDBC Thin Client" connections established to our database from different machines, where machine column gives our machine names as output along other columns info.

But my requirement is instead of machine names we need machine IP's.

select to_char(sysdate,'DD-MON-YY HH24:MI:SS'), count(*),machine,program,status from gv$session where program='JDBC Thin Client' group by  program,machine,status order by 2;

Thanks in advance!!!

Regards

Narender