Re: Spying on queries from application?

From: John Hurley <>
Date: Wed, 3 Mar 2010 08:25:59 -0800 (PST)
Message-ID: <>

On Mar 3, 9:51 am, 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

You can set an after login database trigger and activate low level tracing if needed.

The trace files can get very big and you don't want to do this for many sessions probably.

Google around for things like "oracle database login trigger" and/or "10046 trace" ... proceed cautiously and test out everything in a test environment before even thinking about possibly doing this in a live prod environment.

Have you talked to your DBA's about the information that you need? Received on Wed Mar 03 2010 - 10:25:59 CST

Original text of this message