Re: Spying on queries from application?
Date: Fri, 5 Mar 2010 08:11:13 -0800 (PST)
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.
- 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
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...
Sonnich Received on Fri Mar 05 2010 - 10:11:13 CST