Re: Spying on queries from application?

From: jodleren <sonnich_at_hot.ee>
Date: Fri, 5 Mar 2010 08:11:13 -0800 (PST)
Message-ID: <0a0a528d-5d11-4229-8f72-bbf14a4723e4_at_g4g2000yqa.googlegroups.com>

On Mar 5, 5:42 pm, Mladen Gogala <n..._at_email.here.invalid> wrote:
> On Fri, 05 Mar 2010 03:37:51 -0800, jodleren wrote:
> > But let me return to my problem: I can get tracing from my database
> > explorer, but not from my storage programme... why?
>
> The answer to that question depends on the error message you're getting
> when you try to do that.
>
> --http://mgogala.byethost5.com

That was:

• 2010-03-05 13:59:31.268
• SESSION ID:(17.16450) 2010-03-05 13:59:31.268 Skipped error 4098 during the execution of WISE.SET_TRACE
• 2010-03-05 13:59:31.268 ksedmp: internal or fatal error ORA-04098: trigger 'WISE.SET_TRACE' is invalid and failed revalidation

which really does not explain much...

I also found an tried this:

create or replace trigger wise.sql_trc
after logon
on wise.schema
begin
execute immediate 'alter session set sql_trace=true'; end;
/

Here the report is:

• SESSION ID:(9.32137) 2010-03-05 18:02:42.781 Skipped error 604 during the execution of WISE.SQL_TRC
• 2010-03-05 18:02:42.781 ksedmp: internal or fatal error ORA-00604: error occurred at recursive SQL level 1 ORA-01031: insufficient privileges ORA-06512: at line 2
  • I am the admin of the DB, so I wonder what else I have to do...

WBR
Sonnich Received on Fri Mar 05 2010 - 10:11:13 CST