How to create triggers that track client IP addresses in Oracle

If you want the session_info in v$logmnr_contents to record client IP, in Session_info we don't see IP directly,

But we still have a way, because the contents of this session_info is actually a log from the V$session view of the extract, we can

Create a trigger to track the client IP address in the production database:

Create or Replace Trigger On_logon_trigger

After logon on database

Begin

Dbms_application_info.set_client_info (Sys_context (' Userenv ', ' ip_address '));

End

/

Now we can see the newly logged-on client IP address in the Client_info column of the V$session view. So now we can see the IP of the client in Session_info.

Select Sid,serial#,username, Program,client_info from V$session

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/