Re: creating a trigger on v$session.module

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:<DqGvc.12084$sI.5463_at_attbi_s52>...
> "moklet" <ratshek_at_telkom.co.za> wrote in message
> news:a8701c69.0406030424.51743c10_at_posting.google.com...
> > i've been trying to create an insert/update trigger on v_$session but
> > with no success. following is my code:
> >
> > 1 create or replace trigger trg_module
> > 2 instead of insert or update on t_$session
> > 3 begin
> > 4 delete from t_modes;
> > 5* end;
> > SQL> /
> >
> > Trigger created.
> >
> > (t_$session is a view of sys.v_$session).
> >
> > as you can see the trigger compiles ok but the code ('delete ...') is
> > never run when there is a change in v$session. one explanations i got
> > was that you cannot put this trigger on a view of a fixed table/view.
> >
> > the reason i'm doing this is to monitor changes in v$session.module
> > and then execute some code. if there is another way of achieving this
> > i would appreciate the advice.
> >
> > regards,
> \
> How about a log on trigger? You shouldn't put triggers on a sys object.
> Jim

the problem with a log on trigger is that it will only be triggered when i logon to the database. i am looking for something that will always monitor changes in v$session.module and not just at log on.

is there another way that i can use to find out which module is currently using a session? Received on Fri Jun 04 2004 - 11:26:15 CEST