Re: Spying on queries from application?

From: Mladen Gogala <>
Date: Wed, 3 Mar 2010 15:51:50 +0000 (UTC)
Message-ID: <>

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.
> 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.

Received on Wed Mar 03 2010 - 09:51:50 CST

Original text of this message