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,