|
Oracle Database XE consists of two main components:
- The Oracle instance comprises memory structures known as the System Global Area (SGA) and Oracle background processes.
- The Oracle database comprises data files, redo log files, and control files.
|
 |
The instance is controlled by a set of parameters that are listed in the initialization parameter file (init.ora). Some of these parameters:
- May be modified for a given session by using ALTER SESSION commands
- May be modified for the entire database instance by using ALTER SYSTEM commands
- Require restarting the database to change the setting
- Are fixed for a given database
In Oracle Database XE, the parameters and settings may be viewed in the About Database tool. This tool has information about the following:
- Version
- Settings
- National language support
- CGI environment
- Parameters
|