Re: Spying on queries from application?
Date: Sat, 6 Mar 2010 09:17:47 -0800 (PST)
Message-ID: <1677d6e0-54c9-4269-b195-cc614392e9c3_at_d27g2000yqf.googlegroups.com>
On Mar 5, 8:35 am, jodleren <sonn..._at_hot.ee> wrote:
snip
> create or replace trigger set_trace after logon on database
> begin
> if user not in ('SYS','SYSTEM') then
> execute immediate 'alter session set timed_statistics=true';
> execute immediate 'alter session set max_dump_file_size=unlimited';
> execute immediate 'alter session set sql_trace=true';
> end if;
> exception
> when others then
> null;
> end;
> /
>
> it works, but the log files states "ORA-04098: trigger
> 'WISE.SET_TRACE' is invalid and failed re-validation"
What do you mean "it works?" ...
Normally system level triggers are not placed in user schemas. ( Check out your message about "WISE.SET_TRACE" aka "SCHEMA.TRIGGER_NAME" ). Did you install the trigger as SYSDBA? Received on Sat Mar 06 2010 - 11:17:47 CST