Re: audit response

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 29 Jul 2003 23:11:01 GMT
Message-ID: <9aDVa.3326$0K2.2540@news02.roc.ny>

"quarkman" <quarkman_at_myrealbox.com> wrote in message news:oprs2gen1nzkogxn_at_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

Adding to that ... the usage of spfile does *not* make parameters more dynamic than using pfile.

Anurag Received on Tue Jul 29 2003 - 18:11:01 CDT