Oracle 9i CREATE Database

6.6.1 Create a database with the database configuration Assistant
(1) The "Welcome" interface appears as shown in Figure 6.18.

(2) The "Operations" interface appears as shown in Figure 6.19.

(3) The database template interface appears as shown in Figure 6.20.

(4) The "Database Identification" interface appears as shown in Figure 6.21.

(5) The Database connection options interface appears as shown in Figure 6.22.

(6) The Memory tab of the initialization parameter as shown in Figure 6.25 appears.

Table 6.4 "Typical" memory configuration parameters

Parameters	Meaning
Maximum concurrent connected Users text box	Set the approximate number of users to connect to the database concurrently at any given time
Percentage of physical memory for Oracle text box	Enter the percentage of all physical memory that can be assigned to the database
Database type Drop-down list box	Select the approximate purpose of the database, which will affect the settings for initialization parameters db_cache_size (data block size), processes (process count), shared_pool_size (Shared pool), and fallback table space information. Includes online transaction processing (OLTP), multipurpose (default options), and Data Warehouse total of 3 kinds, the default is multi-purpose.

(7) Figure 6.26 shows the Archive tab of the initialization parameters.

(8) Figure 6.27 shows the database size tab of the initialization parameters.

(9) Figure 6.28 shows the file Location tab of the initialization parameter.

(10) The database storage interface appears as shown in Figure 6.29.
(11) The "Create Options" interface appears as shown in Figure 6.30.

(12) The "Overview" interface appears as shown in Figure 6.31.
(12) The "Overview" interface appears as shown in Figure 6.31.

(14) The "Successfully created database" interface appears as shown in Figure 6.33.

Parameters of the database created by 6.6.2
Open C:\ORACLE\ADMIN\TEMPDB\PFILE\INIT. Ora file, you can view the settings for the most important initialization parameters as follows.
"See supporting Files": \ 6th Chapter \int.ora.
―――――――――――――――――――――――――――――――――――――
# Copyright (c) 1991, 2001 by Oracle Corporation
# MTS
Dispatchers= "(protocol=tcp) (Ser=modose)",
"(PROTOCOL=TCP) (Pre=oracle.aurora.server.giopserver)",
"(PROTOCOL=TCP) (Pre=oracle.aurora.server.sgiopserver)"
# Other
compatible=9.0.0
Db_name=tempdb
# Distributed, replicated and snapped
Db_domain=mynet
Remote_login_passwordfile=exclusive
# Archive
log_archive_dest_1= ' location=c:\oracle\oradata\tempdb\archive '
Log_archive_format=%t_%s.dbf
Log_archive_start=true
# sort, hash join, bitmap index
sort_area_size=524288
# File Configuration
Control_files= ("C:\oracle\oradata\TEMPDB\CONTROL01.") CTL ",
"C:\oracle\oradata\TEMPDB\CONTROL02. CTL "," C:\oracle\oradata\TEMPDB\CONTROL03. CTL ")
# Pool
java_pool_size=52428800
large_pool_size=10485760
shared_pool_size=63868928
# Cursor and library cache
open_cursors=300
# System-managed undo and fallback segments
Undo_management=auto
Undo_tablespace=undotbs
# Network Registration
Instance_name=tempdb
# Diagnostics and Statistics
Background_dump_dest=c:\oracle\admin\tempdb\bdump
Core_dump_dest=c:\oracle\admin\tempdb\cdump
Timed_statistics=true
User_dump_dest=c:\oracle\admin\tempdb\udump
# Process and Session
processes=150
# Redo Logs and restores
fast_start_mttr_target=300
# cache and I/O
db_block_size=4096
db_cache_size=86749184
―――――――――――――――――――――――――――――――――――――