We use oracle connection manager with our databases and XML logging of SQL statements. In the logs, (and in V$SESSIONS) the source IP of all the statements appears to be the host that runs the connection manager, not the IP of the actual client.
Is there any way to pass down through OCM the real source IP of the client, so it gets logged in the XML SQL query log? If not, is it possible to configure OCM to log the source IP and the username of the connecting user, or similar information, so I can correlate this log with the Database XML Log?
Thanks!
Calin