Yes Pete. This was it. I cant tell you how many times I asked our
very experienced DBA if 'anything changed' on the weekend of Aug 13
that would have caused system triggers to stop working. (I am a
developer). He said Noooo.
Now I have to go give him an atomic weggie.
Thanx!
Pete Finnigan <plsql_at_petefinnigan.com> wrote in message news:<BMjsJQBTErSBRx2z_at_peterfinnigan.demon.co.uk>...
> Hi,
>
> Check if the hidden parameter _system_trig_enabled is still set to TRUE.
> If this is set to false then system triggers will no longer fire. You
> cannot use "show parameter" in SQL*Plus or select from v$parameter. You
> need to use some x$ views so you need access to the SYS schema. The
> following SQL will get the value for you:
>
> SQL> l
> 1 select x.ksppinm name,
> 2 y.ksppstvl value,
> 3 ksppdesc description
> 4 from x$ksppi x,
> 5 x$ksppcv y
> 6 where x.inst_id = userenv('Instance')
> 7 and y.inst_id = userenv('Instance')
> 8 and x.indx = y.indx
> 9* and x.ksppinm = '_system_trig_enabled'
> SQL> /
>
> NAME
> -------------------------------------------------------------
> VALUE
> -------------------------------------------------------------
> DESCRIPTION
> -------------------------------------------------------------
> _system_trig_enabled
> TRUE
> are system triggers enabled
>
>
> SQL>
>
> hth
>
> Kind regards
>
> Pete
Received on Fri Sep 17 2004 - 15:25:18 CDT
