Re: Spying on queries from application?
Date: Wed, 3 Mar 2010 15:51:50 +0000 (UTC)
Message-ID: <pan.2010.03.03.15.51.50_at_email.here.invalid>
On Wed, 03 Mar 2010 06:51:32 -0800, jodleren wrote:
> Hi all
>
> We have a management programme, which uses Oracle DB. We (I) also make
> some intranet stuff etc for this system, which uses the same DB.
>
> Now I need to track what this programme does, meaning I want to know
> which tables it uses etc for certain actions. The programme is not made
> by us, we just have our own additions. Therefore I need to copy some of
> that action.
>
> Is there a spy that can give me that? The programme uses ODBC. My driver
> is 10.2. I dont know about the DB version.
>
> WBR
> Sonnich
The name is 10046. James 10046. Set up the trace using either DBMS_MONITOR, DBMS_SYSTEM.SET_EV or DBMS_SUPPORT.START_TRACE_IN_SESSION and then analyze it using tkprof, trca, orasrp or Hotsos profiler. That should tell you everything you should now, and more.
-- http://mgogala.byethost5.comReceived on Wed Mar 03 2010 - 09:51:50 CST