Re: Spying on queries from application?
From: jodleren <sonnich_at_hot.ee>
Date: Wed, 3 Mar 2010 09:11:17 -0800 (PST)
Message-ID: <fec8d27d-b454-46a3-8400-89b1c7a43855_at_i25g2000yqm.googlegroups.com>
On Mar 3, 6:40 pm, jodleren <sonn..._at_hot.ee> wrote:
> 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
Date: Wed, 3 Mar 2010 09:11:17 -0800 (PST)
Message-ID: <fec8d27d-b454-46a3-8400-89b1c7a43855_at_i25g2000yqm.googlegroups.com>
On Mar 3, 6:40 pm, jodleren <sonn..._at_hot.ee> wrote:
> 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
Can Toad (Free) do it? Received on Wed Mar 03 2010 - 11:11:17 CST