How to find IP Address and Port No. from client connecting to Database
I know some detail from v$session. but I want to know, which object i can select to find ip address and port no. from client connect to my database.
Thanks,
Kim.
I want to use select command. which table i select?
Thank you, for every one
Assume, I am DBA. How can I monitor by using select statement to view who,ip address, port no connect to my database.
I use SQL Plus. If I use sys_context i will get my ip address. I want ip address from anyone connect to me, not my ip.
becuase I will develop monitoring tool on web base. I can monitor from anywhere by web.
How do I?