Re: How to trace sql comes from middleware in production environment?

wangbin_at_start.com.au (wangbin) wrote in news:2d15bd69.0204291828.719f8ba8_at_posting.google.com:

> Our application has N-tie structure: Browser+corba server + DB. Many
> times I am asked what happens in the db when clicking this button.
> It's quite easy to identify a active query, if it lasts for a while. I
> have the problem if it finishes in a second.

I just solved a similar problem for my company. The good news is that we control the source code, so the fix was easy.
1) create a PL/SQL procedure which does ALTER SESSION SET EVENT ......
[I forget the specific value 1046, value 8 or something like that] 2) have another procedure where turns off the trace. 3) modify the application so a user can manually turnon/turn-off tracing.

Now the problem is solved
I can be contacted for more detail at oracledba at operamail dot com Received on Thu May 02 2002 - 21:26:06 CDT