Re: _sys_trig_enabled
- From: Joe Cooper <aregularjoe8@xxxxxxxxx>
- To: shrekdba@xxxxxxxxx, "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- Date: Mon, 14 Nov 2005 15:16:14 -0800 (PST)
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@xxxxxxxxx> 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@xxxxxxxxx
------------------------------------------------------------------------
"Zen is not easy.
It takes effort to attain nothingness.
And then what do you have?
Bupkes." -- The Goddess
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
Other related posts:
