The interactions in this eCourse require Javascript to be enabled.
Managing Database Settings
previous|next
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