After completing the Database Content screen, Click Next. Initialization Parameters screen will be displayed.
Initialization Parameters screen is used define the various initialization parameter settings used to configure size and setup characteristics of the Oracle instance.
The Block Size setting corresponds to the smallest unit of storage within the Oracle database. All database objects such as tables, indexes etc. are governed by the block database is created, this size cannot be modified.
The maximum and minimum size of an Oracle block depends on the operating system.
8KB is sufficient for most transaction-oriented applications, and 16KB and above are used in data warehouse–type applications.
The Processes setting specifies the maximum number of simultaneous operating system processes that can be connected to this Oracle database. You must include at least six processes for each of the Oracle background processes. You can increase this number on this screen.
This parameter does have a bearing on the overall size of your Oracle instance. The larger you make this number, the more room Oracle must reserve in the SGA to track the processes.
The Character Sets Tab
You use the options on the Character Sets tab to configure the character sets you will use within your database. You will determine the database character set, the national character set, the default language, and the default date format.
Specifying a database character set defines the type of encoding scheme that Oracle uses to determine how characters are displayed and stored within your Oracle environment. The character set you choose determines the languages that can be represented in your environment. It also controls other nuances such as how your database interacts with your operating system and how much storage is required for your data. The default character set is based on the language setting of the operating system.
Specifying a national character set defines how your database represents unicode characters in a database that does not use a Unicode-enabled character set.
You use the Default Language setting to manage certain aspects of how your database represents information pertaining to different locales. For example, this setting determines how your database displays time and monetary values.
You use the Default Date setting to specify how Oracle displays dates by default. For example, the AMERICA setting shows dates in the DD-MON-YYYY format by default.
The Connection Mode Tab You use the options on the Connection Mode tab to specify the type of connections to use for this database. You can choose dedicated or shared server mode. The default connection mode is dedicated server.
After completing the Initialization Parameters screen, click Next. You will then be presented with the Database Storage screen.
The DBCA also lets to install examples of actual working databases. Oracle provides a set of example schemas and applications that use these schemas. These sample schemas now or later by running a series of SQL scripts.
After completing the Initialization Parameters screen, click Next. Database Storage screen will be displayed.
This screen allows to review and change the locations of the actual objects that compose the Oracle database, i.e., datafiles, control files, and redo logs.
Clicking on the various elements on the tree structure provided in the left pane of this screen displays displays the details of each component. Selecting an element displays details about the element on the right.
New objects can be added in the case of creating a custom database that does not use a template.
After completing the Database Storage screen, click Next to create the database. Database Creation Options Screen will be displayed.
The Creation Options screen provides two options:
If Save database to a template definition is selected, this definition is added to the list of database definitions. The DBA can this definition later to create database. select on subsequent executions of the DBCA.
DBCA can also create a set of scripts that can be run manually create the database.
If the database is to be created immediately, click Finish. A confirmation screen will be displayed with all the options selected on the previous screens.
Scroll down the window to examine the following options to install into the database
The information on this Summary Screen can be saved as HTML file for lature use.
Once the database creation process starts, Oracle creates the database as specified.
It starts the instance, creates all the necessary database components, and configures all the database options that you specified. (It takes several minutes to more than an hour depending on the options being installed).