Re: SPFILE
From: Palooka <nobody_at_nowhere.com>
Date: Tue, 12 Aug 2008 18:37:00 +0100
Message-ID: <3Tjok.153641$dz3.41004@newsfe20.ams2>
Date: Tue, 12 Aug 2008 18:37:00 +0100
Message-ID: <3Tjok.153641$dz3.41004@newsfe20.ams2>
Mtek wrote:
> Hi,
>
> We are not using SPFILE now. But we have decided to. One the file is
> created, do we need to restart the instance for it to take effect, so
> then we can use ALTER SYSTEM to change parameters? Or once we create
> it, is it automatically active?
>
It won't be used until you restart the instance, so I'd recommend not
creating it until you are ready to shut down and restart.
Palooka Received on Tue Aug 12 2008 - 12:37:00 CDT