Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Initialization Parameters, 197 of 220


SPFILE

Parameter type 

String 

Syntax 

SPFILE = spfile_name 

Default value 

ORACLE_HOME/dbs/spfile.ora 

Parameter class 

Static (auto-resource) 

Range of values 

Any valid SPFILE 

Oracle9i Real Application Clusters 

Multiple instances should have the same value. 

The value of this parameter is the name of the current server parameter file (SPFILE) in use. This parameter can be defined in a client side PFILE to indicate the name of the server parameter file to use.

When the default server parameter file is used by the server, the value of SPFILE is internally set by the server.

The SPFILE resides in the ORACLE_HOMEdbs directory; however, users can place it anywhere on their machine as long as it is specified in a PFILE.

See Also:

Oracle9i Database Performance Guide and Reference for more information about creating the SPFILE 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback