X-Received: by 10.58.195.162 with SMTP id if2mr5469670vec.21.1404477815600; Fri, 04 Jul 2014 05:43:35 -0700 (PDT) X-Received: by 10.50.18.50 with SMTP id t18mr358790igd.10.1404477815500; Fri, 04 Jul 2014 05:43:35 -0700 (PDT) Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!217.188.199.168.MISMATCH!takemy.news.telefonica.de!telefonica.de!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!newspeer1.nac.net!border2.nntp.dca1.giganews.com!nntp.giganews.com!w8no5912097qac.0!news-out.google.com!bp9ni2745igb.0!nntp.google.com!hn18no2964531igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Fri, 4 Jul 2014 05:43:34 -0700 (PDT) In-Reply-To: <3e35c721.244341003@news-server.insight.rr.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=111.93.244.18; posting-account=VFT8tgoAAADMfJxmAdG8-_RYDHfBvTQn NNTP-Posting-Host: 111.93.244.18 References: <3e35c721.244341003@news-server.insight.rr.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <60bb6a0c-1e4d-4a01-94ae-dc214290eea9@googlegroups.com> Subject: Re: Running with _system_trig_enabled set to false From: khans.jak@gmail.com Injection-Date: Fri, 04 Jul 2014 12:43:35 +0000 Content-Type: text/plain; charset=ISO-8859-1 Lines: 41 Xref: news.cambrium.nl 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; > @?/rdbms/admin/catalog > @?/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.