Initialization Parameters
Use the Memory page to set the
initialization parameters that control the memory usage of the
database. Typical allots memory as a percentage of the total
available physical memory and Custom dictates the values.
The
Initialization Parameters screen is displayed in Figure 3.10.
Figure 3.10 DBCA – Initialization
Parameters
If
selecting Custom,
specify Automatic to allocate specific amounts to SGA and PGA or Manual
to enter specific values for each SGA component.
Refer to Figure 3.11 for an example.
Figure 3.11 DBCA – Initialization
Parameters
When
sizing,
specify the smallest block size (8K recommended) and the maximum
number of operating system user processes that can connect
simultaneously to the database (150 by default).
For Character Sets, select a character set
that determines what languages can be represented in the
database. Use the default if the only language that needs to be
supported is the language of the operating system. Use Unicode
(AL32UTF8) to support multiple languages for database users and
applications.