|Lesson 3||Initialization file|
|Objective||Identify the types of information contained in the initialization file. |
Oracle Initialization File
Parameters in the Initialization File
The database initialization file is a text file containing a number of parameters that control how the Oracle database works.
At a very high-level, you could categorize those parameters as:
- A pointer to the database control files
- Information about the database itself, such as the physical block size used when reading and writing datafiles
- Parameters that control the Oracle background processes
- Parameters that control how Oracle allocates memory
- Pointers to the directories containing the alert log and trace files for the instance
Here are some lines from a typical initialization file
db_name = devl
db_files = 1024
db_block_size = 8192
There are many parameters that you can set in the initialization file. Oracle documents all of them in the Oracle Server Reference Manual.
Look through the following SlideShow to learn about the most important parameters in a bit more detail:
How the initialization file works
Oracle reads the initialization file whenever you start an instance
Any changes that you make to the initialization file afterwards will not take effect until you shut down and restart your system.
Strictly speaking, Oracle does not consider the initialization file to be part of a database.
here is why
It is an important file though, and you want to preserve it with the same care that you do all the other files that are database files.
Initialization File - Exercise