Release 2 (8.1.6)
Part Number A76961-01
Initialization Parameters, 2 of 188
The initialization parameter file is a text file that contains a list of parameters and a value for each parameter. The file should be written in the client's default character set. Specify in the parameter file values that reflect your installation.
The following are sample entries in a parameter file:
The name of the parameter file varies depending on the operating system. For example, it can be in mixed case or lowercase, or it can have a logical name or a variation of the name
INIT.ORA. Also supplied is an
INITDW.ORA file, which contains suggested parameter settings for data warehouses and data marts. As the database administrator, you can choose a different filename for your parameter file.
See your Oracle operating system specific documentation for the default locations and filenames for these parameter files. The initialization parameter file is read by the client-side tool you use to start the server (such as SQL*Plus).
Sample parameter files are provided on the Oracle Server distribution medium for each operating system. A sample file is sufficient for initial use, but you will probably want to modify the file to tune the database system for best performance. Any changes will take effect after you completely shut down the instance and then restart it.
Database administrators can use initialization parameters to:
Many initialization parameters can be fine-tuned to improve database performance. Other parameters should never be altered or should be altered only under the supervision of Oracle Corporation Worldwide Support staff.