Re: Spying on queries from application?
Date: Thu, 4 Mar 2010 16:51:31 -0800 (PST)
Message-ID: <56196f9f-07d8-4722-8135-13f23e6b013c_at_d2g2000yqa.googlegroups.com>
On Mar 4, 1:31 pm, jodleren <sonn..._at_hot.ee> wrote:
snip
> I use Borland Database Explorer, and using
> alter system set timed_statistics=true
> then
>
> ALTER SYSTEM SET
> EVENT='10046 trace name context forever, level 12'
> SCOPE=spfile;
Yeah that's kind of the starting point. The idea is one approach is to have a trigger look at all the new sessions ( new connections ) and set the tracing for just the database session ( the odbc work ) that you want to get traced.
Do you have permission from IT management for what you are trying to do?
If the DBA is dead are there other people in your organization that might be useful in helping you get the information that you need?
At your experience level you really want to figure out how to get this type of stuff done on a test system first ... please. Received on Thu Mar 04 2010 - 18:51:31 CST