Oracle requests proxy

Question

Hi

I would like to monitor all the requests made to remote server. I was thinking to create a local proxy server, make all the requests to my local server and then server connects to remote server.

There a millions of other ways to solve this, but currently there is no better solution for an big and old asp site and slow and old development tools (interdev).

So, is this a database specific problem or can it be solved with simple server forwarding? I noticed MySQL offers simple solutions for this, but I did not find anything useful for oracle.

Thanks for your reply

Answer 1

You have different choices, of course, this can slowdown the server.

If you can modify the code after a new connection, just execute:

ALTER SESSION SET SQL_TRACE = TRUE;

For more detailed info use the following:

ALTER SESSION SET EVENT=’10046 trace name context forever, level 12’;

If you want for "ALL" the database, just add the following parameter on the init/spinit:

Event=’10046 trace name context forever, level 12’;

References:

• Create Oracle Trace file for 10046
• Levels on event 10046

Answer 2

AUDIT may do what you need, but I think it will need to be set on the remote database (and is best if there is a dedicated user account for the database link)