Re: Running with _system_trig_enabled set to false

From: <khans.jak_at_gmail.com>
Date: Fri, 4 Jul 2014 05:43:34 -0700 (PDT)
Message-ID: <60bb6a0c-1e4d-4a01-94ae-dc214290eea9_at_googlegroups.com>


On Tuesday, January 28, 2003 5:32:31 AM UTC+5:30, Joe Fischer wrote:
> There were some posts back in 08/2002 about getting messages
> like "ORA-04045 ORA-04045: errors during recompilation/revalidation of
> SYS.CDC_ALTER_CTABLE_BEFORE." A solution was posted about doing:
>
> -- disable system triggers
> alter system set "_system_trig_enabled"=false;
> _at_?/rdbms/admin/catalog
> _at_?/rdbms/admin/catproc
> -- re-enable system triggers
> alter system set "_system_trig_enabled"=true;
>
> This is on a 9.2 database. When I set system_trigger back to
> true, the original problem shows up whenever somebody tries to connect
> to the database. If I leave it set to false, everything seems to work
> OK. Is this normal OK?
> ---
> Joe

Certainly helpful. Do you know its an Hidden parameter and you wont be able to see anywhere in order to check the status before you perform update.

This may be helpful.

SELECT

a.ksppinm Param , 
b.ksppstvl SessionVal ,
c.ksppstvl InstanceVal,
a.ksppdesc Descr 

FROM
x$ksppi a , 
x$ksppcv b , 
x$ksppsv c

WHERE
a.indx = b.indx AND 
a.indx = c.indx AND 
a.ksppinm LIKE '/_%' escape '/' AND A.ksppinm='_system_trig_enabled'
ORDER BY
1

Thanks. Received on Fri Jul 04 2014 - 14:43:34 CEST

Original text of this message