First page Back Continue Last page Graphics
Introduction to SPFILE...
SPFILE = Server Parameter File
Similar to test parameter file
- Contains initialization parameter settings
Differences from text parameter file:
- Stored in binary format
- SPFILE always resides on database server
- Parameter file resides on remote machine performing STARTUP
Notes:
The server parameter file (SPFILE) allows you to store and manage your initialization parameters persistently in a server side binary file. It is similar to the parameter file file from earlier versions of Oracle in that it is used to set the parameters for an instance. It is different in that it is a binary file and it is always stored on the server itself. (In contrast to the text init.ora file which is sometimes replicated to client workstations used to startup the database.)