Sunday , October 22 2017
Home / Oracle DBA / Overview of Oracle Parameter Files

Overview of Oracle Parameter Files

Overview of Parameter Files

To start a database instance, Oracle Database must read either a server parameter file, which is recommended, or a text initialization parameter file, which is a legacy implementation. These files contain a list of configuration parameters. To create a database manually, you must start an instance with a parameter file and then issue a CREATE DATABASE command. Thus, the instance and parameter file can exist even when the database itself does not exist.

Initialization Parameters

Initialization parameters are configuration parameters that affect the basic operation of an instance. The instance reads initialization parameters from a file at startup. Oracle Database provides many initialization parameters to optimize its operation in diverse environments. Only a few of these parameters must be explicitly set because the default values are adequate in most cases.

Server Parameter Files

instance shutdown and startup. A server parameter file is a repository for initialization parameters that is managed by Oracle Database. A server parameter file has the following key characteristics:
  • Only one server parameter file exists for a database. This file must reside on the database host.
  • The server parameter file is written to and read by only by Oracle Database, not by client applications.
  • The server parameter file is binary and cannot be modified by a text editor.
  • Initialization parameters stored in the server parameter file are persistent. Any changes made to the parameters while a database instance is running can persist across
A server parameter file eliminates the need to maintain multiple text initialization parameter files for client applications. A server parameter file is initially built from a text initialization parameter file using the CREATE SPFILE statement. It can also be created directly by the Database Configuration Assistant.

Text Initialization Parameter Files

A text initialization parameter file is a text file that contains a list of initialization parameters. This type of parameter file, which is a legacy implementation of the parameter file, has the following key characteristics:
  • When starting up or shutting down a database, the text initialization parameter file must reside on the same host as the client application that connects to the database.
  • A text initialization parameter file is text-based, not binary.
  • Oracle Database can read but not write to the text initialization parameter file. To change the parameter values you must manually alter the file with a text editor.
  • Changes to initialization parameter values by ALTER SYSTEM are only in effect for the current instance. You must manually update the text initialization parameter file and restart the instance for the changes to be known.

Modification of Initialization Parameter Values

You can adjust initialization parameters to modify the behavior of a database. The classification of parameters as static or dynamic determines how they can be modified.
The scope of a parameter change depends on when the change takes effect. When an instance has been started with a server parameter file, you can use the ALTER SYSTEMSET statement to change values for system-level parameters as follows:
  • SCOPE=MEMORY
Changes apply to the database instance only. The change will not persist if the database is shut down and restarted.
  • SCOPE=SPFILE
Changes are written to the server parameter file but do not affect the current instance. Thus, the changes do not take effect until the instance is restarted.
  • SCOPE=BOTH
Changes are written both to memory and to the server parameter file. This is the default scope when the database is using a server parameter file.
The database prints the new value and the old value of an initialization parameter tothe alert log. As a preventative measure, the database validates changes of basicparameter to prevent illegal values from being written to the server parameter file.
View More:
Undo Table spaces
Overview of Table spaces
Overview of Segments

Comments

comments

Check Also

Moving a database from Normal File System to ASM storage

Default storage for oracle database is File System, where database files resides on local storage. …

Leave a Reply

Your email address will not be published. Required fields are marked *