Re: _sys_trig_enabled

Or, if you're x$ table challenged like me, look in v$parameter:    

  SQL> select name, value from v$parameter where name like '%trig%enabled%';

  NAME                                 VALUE
----------------------------------         -------------------------------------
_system_trig_enabled           FALSE

   

  (While this works in 9i, it appears that it doesn't work in 10g. Looks like I'll have to become x$ table UN-challenged in the near future.)    

  Joe Cooper
  Senior Oracle DBA
  Department of Veteran Affairs
  Austin, TX   

bill thater <shrekdba_at_gmail.com> wrote:
  On 11/14/05, Bobak, Mark wrote:
> Hi Bill,
>
> SQL> select ksppinm from x$ksppi where ksppinm like '%trig%enabled%';
>
> KSPPINM
> ----------------------------------------------------------------
> _system_trig_enabled

duh. thanks.

--
--
Bill "Shrek" Thater ORACLE DBA
shrekdba_at_gmail.com
------------------------------------------------------------------------
"Zen is not easy.
It takes effort to attain nothingness.
And then what do you have?
Bupkes." -- The Goddess
--
http://www.freelists.org/webpage/oracle-l


  


		
---------------------------------
 Yahoo! FareChase - Search multiple travel sites in one click.  
--
http://www.freelists.org/webpage/oracle-l