How to trace sql comes from middleware in production environment?

From: wangbin <wangbin_at_start.com.au>
Date: 29 Apr 2002 19:28:35 -0700
Message-ID: <2d15bd69.0204291828.719f8ba8@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 don't want to trace the whole database. I can trace one session, however, corba server set up about 70 sessions to DB. God knows which one is used by this click. I use the following way in the test environment.

1.restart DB and application;
2.run the following query before the click; SELECT q.hash_value,

       q.sql_text,
         q.first_load_time

  FROM v$sqlarea q
order by q.first_load_time
/
3.click the button;
4.rerun the query, compare the result.

It works in test environment, but I cannot use it in production. Is it any better way?

Regards,
Bin Received on Mon Apr 29 2002 - 21:28:35 CDT