Re: Trigger DATABASE ON STARTUP

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 7 Dec 2001 02:09:14 -0800
Message-ID: <a20d28ee.0112070209.50fe8d0@posting.google.com>

Mladen Gogala <mgogala_at_earthlink.net> wrote in message news:<pan.2001.12.06.22.23.14.845263.969_at_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.

IMO this has nothing to do with perversion, but with common sense.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Dec 07 2001 - 04:09:14 CST