From: Palooka <>
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

Original text of this message