Tell Me
 

Managing Database Settings

Previous previous|next Next Page

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