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.
you can only get port from listener.log
you can get ip using sys_context functions
You can get ip from listener.log...see snippet from log below...
11-APR-2003 13:34:31 * (CONNECT_DATA=(SID=zap)(CID=(PROGRAM=D:\oracle\ora81\bin\Sqlplusw.exe)(HOST=SUN101)(USER=rgg))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.66.239)(PORT=4143)) * establish * zap * 0
IP can be found out with this...
select sys_context('userenv','ip_address') from dual;
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?
dont u use following query
select terminal,machine,username from v$session
where username is not null
Click Here to Expand Forum to Full Width