Date: Tue, 12 Aug 2008 18:37:00 +0100
> 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