Oracle 9i creates a database
Author: Unknown Updated: Finishing Source: ddvip.net Update Time: 2004.09.05 Contributor mail: tg * ddvip.com 6.6.1] with [Database Configuration Assistant to create a database (1) appears as shown in Figure 6.18 [Welcome 】interface. (2) The [Operation] interface shown in Figure 6.19 appears. (3) The [Database Template] interface shown in Figure 6.20 appears. (4) The [Database Identification] interface shown in Figure 6.21 appears. (5) The [Database Connection Options] interface shown in Figure 6.22 appears. (6) The [Memory] tab of the initialization parameter shown in Figure 6.25 appears. Table 6.4 [Typical] Memory configuration parameters
Parameter Meaning [Maximum Connected Connection User Number] Text Box Settings To connect (simultaneously) Connect (simultaneously) of any given time (simultaneous) [Percentage for Oracle's physical memory] text box input can be assigned to all physical memory of the database Percentage [Database Type] drop-down list box Select the general purpose of the database, this will affect the initialization parameter db_cache_size (data block size), Processes, Shared_Pool_SIZE (shared pool), and return table space information. Including online transaction processing (OLTP), multi-purpose (default option) and data warehouse have a total of 3, which defaults to multi-purpose. (7) Figure 6.26 shows the [Archive] tab of the initialization parameter. (8) Figure 6.27 shows the [Database Size] tab of the initialization parameter. (9) Figure 6.28 shows the [File Location] tab of the initialization parameter. (10) The [Database Storage] interface shown in Figure 6.29 appears. (11) The [Create Options] interface shown in Figure 6.30 appears. (12) The [Summary] interface shown in Figure 6.31 appears. (12) The [Summary] interface shown in Figure 6.31 appears. (14) The [Successful Creation Database] interface shown in Figure 6.33 appears. 6.6.2 Parameters of the created database Open the C: /oracle/admin/tempdb/pfile/init.ora file, you can view the settings of the most important initialization parameters as follows. [See Supported files]: / Chapter 6 /int.ora.
