Re: audit response

From: quarkman <quarkman_at_myrealbox.com>
Date: Tue, 29 Jul 2003 19:53:01 +1000
Message-ID: <oprs2gen1nzkogxn@haydn>

On Mon, 28 Jul 2003 15:35:34 -0500, TurkBear <john.greco_at_dot.state.mn.us> wrote:

> quarkman <quarkman_at_myrealbox.com> wrote:
>
>> That init.ora parameter is static. Therefore setting it to false
>> requires an instance re-start
>
>
> Is that still the case with 9i and the SP file usage instead of pfile?
>

As I mentioned, the parameter is a new invention in 9i R2, so yes... the fact that it's static is a 'feature'. And it likely won't be changing any time soon.

With an spfile, a simple 'alter system set xxxxx=false' would fail ('paramter can't be modified'). It would require an 'alter system set xxxxxx=false scope=spfile', but that does nothing until a new startup.

~QM Received on Tue Jul 29 2003 - 04:53:01 CDT