Re: Spying on queries from application?
From: jodleren <sonnich_at_hot.ee>
Date: Wed, 3 Mar 2010 08:40:57 -0800 (PST)
Message-ID: <62cbe258-eb16-4474-86ad-bf977e8cbef6_at_q23g2000yqd.googlegroups.com>
On Mar 3, 6:25 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> On Mar 3, 9:51 am, jodleren <sonn..._at_hot.ee> wrote:
>
> snip
>
>
>
> > 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
>
> 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?
Date: Wed, 3 Mar 2010 08:40:57 -0800 (PST)
Message-ID: <62cbe258-eb16-4474-86ad-bf977e8cbef6_at_q23g2000yqd.googlegroups.com>
On Mar 3, 6:25 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> On Mar 3, 9:51 am, jodleren <sonn..._at_hot.ee> wrote:
>
> snip
>
>
>
> > 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
>
> 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?
The DBA is long time dead :) And I do not know that much about Oracle
yet.
We have a test DB where I can play, I will check it out.
Sonnich Received on Wed Mar 03 2010 - 10:40:57 CST