Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Displaying user IP address

467835Aug 28 2008 — edited Sep 2 2008

Hi all experts,

I want to display the user's machine IP address that are connected to the oracle database. For example, if the users machine IP address is 65.345.347.111 and connected to PROD database, i want to display like below

USERNAME IP ADDRESS DB NAME

How i could do this? I do not see any column in v$session that will display the user machine IP address. Please give me some feedback.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 30 2008

Added on Aug 28 2008

#general-database-discussions

15 comments

2,465 views