First page Back Continue Last page Graphics
Benefits of SPFILE
Provides “persistent parameter initialization”
- Parameter changes persist across database shutdown / startup cycles
Centralized location
- Avoids having multiple copies of init.ora
Notes:
By using a Server Parameter file, we gain persistent parameter initialization, i.e. parameter changes persist across database / instance shutdowns and startups. More on this feature later.
Another key benefit is eliminating the need to have a copy of the parameter file on every remote machine can be used to do STARTUPs.