 |
The Generating init.ora File option generates an
init.ora file based on your inputs for the Number of Users, Dedicated
Server, Database Type,
Parallel Query Option (PQO), and so on. You can generate the init.ora
file without creating the database. This option is useful when you are
migrating or upgrading your database, and you want to use the init.ora
parameters added in the CES Database Server 9.1.9.
If you are migrating or upgrading your database to
Oracle, you might need to compare your current init.ora parameter values
with the generated
values and choose the optimal values suitable for your system. |
|
-
From the navigation pad, select Administration > Generate Init.ora.
The Database Setup Information window appears.
This table describes the fields displayed in the
Database Setup
Information window:
Field |
Description |
Number of CPUs |
Enter the number of CPUs in this field. |
Physical RAM |
Enter the RAM size, and select MB or GB. |
Concurrent Users |
Select the concurrent users. The available options
are:
-
Department
-
Company
-
Enterprise
-
Me
Enter the number of
users. |
Database Block Size |
Select the database block size. The available
options are: 4K, 8K, 16K, and 32K. |
Server Type |
Select the server type. The available options are:
-
Dedicated Server (DS)
-
Shared Server (SS)
|
Parallel Query Option |
Select the Parallel Query option. The
available options are: YES, and NO. |
-
Specify the values, and then click Next.
The Redo Log File size window
appears.
-
The recommended values displayed here are based on the values entered in
the previous window. Specify the values for the Redo Log File Size. The
init.ora file generated is based on this value.
-
Click Next to proceed.
The recommended init.ora parameters appears.
-
Click Finish.
You are prompted for the name of the file in which the
init.ora parameter values are to be stored.
-
Type the name, and then click OK to save the values.
|