Re: Spying on queries from application?
From: joel garry <joel-garry_at_home.com>
Date: Wed, 3 Mar 2010 10:10:44 -0800 (PST)
Message-ID: <ba2373b6-4651-4ed4-a2c4-4142968fff8a_at_g8g2000pri.googlegroups.com>
On Mar 3, 8:40 am, 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 10:10:44 -0800 (PST)
Message-ID: <ba2373b6-4651-4ed4-a2c4-4142968fff8a_at_g8g2000pri.googlegroups.com>
On Mar 3, 8:40 am, 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
dbconsole or it's big brother EM can do it, you can look at all sessions, pick out cursors and specific SQL to your hearts content. There is probably a port 550x or 180x access through your browser. Try https://yourhostname:5500/em You may need to know the system login or equivalent. We could give more advice if we knew what kind of host you have, like where to look for the information about ports, or how to see if it is running.
jg
-- _at_home.com is bogus. http://www.fastcompany.com/magazine/53/peters.htmlReceived on Wed Mar 03 2010 - 12:10:44 CST