Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger DATABASE ON STARTUP

Re: Trigger DATABASE ON STARTUP

From: Mladen Gogala <mgogala_at_earthlink.net>
Date: Fri, 07 Dec 2001 03:23:32 GMT
Message-ID: <pan.2001.12.06.22.23.14.845263.969@earthlink.net> 





On Thu, 06 Dec 2001 16:27:00 -0500, Bill Border wrote:



> Try setting the init.ora parameter:

> 

> _SYSTEM_TRIG_ENABLED = false

> 

> This will tell Oracle to not run system triggers.




This parameter has to be set when upgrading to 8.1.7.2.x patchset.
Why would like to disable system triggers, anyway? There are some 
perverted DBAs among us who put dbms_shared_pool.keep invocations 
in the database triggers.

-- 
Mladen Gogala


Received on Thu Dec 06 2001 - 21:23:32 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US