Oracle 9i Release 2 General Purpose template

[Terrence Miao <terrence@xxxxxxxxxxxxxx>]

General_Purpose

Use this database template to create a pre-configured database optimized for general purpose usage.

Common Options

Option Name	Selected
Example Schemas	true
Oracle Data Mining	true
Oracle Intermedia	true
Oracle JVM	true
Oracle Label Security	true
Oracle OLAP	true
Oracle Spatial	true
Oracle Text	true
Oracle Ultra Search	true
Oracle XML DB	true

Initialization Parameters

Name	Value
aq_tm_processes	1
background_dump_dest	{ORACLE_BASE}/admin/{DB_NAME}/bdump
compatible	9.2.0.0.0
control_files	("{ORACLE_BASE}/oradata/{DB_NAME}/control01.ctl", "{ORACLE_BASE}/oradata/{DB_NAME}/control02.ctl", "{ORACLE_BASE}/oradata/{DB_NAME}/control03.ctl")
core_dump_dest	{ORACLE_BASE}/admin/{DB_NAME}/cdump
db_block_size	8192
db_cache_size	33554432
db_file_multiblock_read_count	16
db_name
dispatchers	(PROTOCOL=TCP) (SERVICE={SID}XDB)
fast_start_mttr_target	300
hash_join_enabled	TRUE
java_pool_size	83886080
job_queue_processes	10
large_pool_size	16777216
open_cursors	300
pga_aggregate_target	25165824
processes	150
query_rewrite_enabled	FALSE
remote_login_passwordfile	EXCLUSIVE
shared_pool_size	83886080
sort_area_size	524288
star_transformation_enabled	FALSE
timed_statistics	TRUE
undo_management	AUTO
undo_retention	10800
undo_tablespace	UNDOTBS1
user_dump_dest	{ORACLE_BASE}/admin/{DB_NAME}/udump

Character Sets

Name	Value
Database Character Set	WE8ISO8859P1
National Character Set	AL16UTF16

Data Files

Name	Tablespace	Size(M)
{ORACLE_BASE}/oradata/{DB_NAME}/cwmlite01.dbf	CWMLITE	20
{ORACLE_BASE}/oradata/{DB_NAME}/drsys01.dbf	DRSYS	20
{ORACLE_BASE}/oradata/{DB_NAME}/example01.dbf	EXAMPLE	138.125
{ORACLE_BASE}/oradata/{DB_NAME}/indx01.dbf	INDX	25
{ORACLE_BASE}/oradata/{DB_NAME}/odm01.dbf	ODM	20
{ORACLE_BASE}/oradata/{DB_NAME}/system01.dbf	SYSTEM	410
{ORACLE_BASE}/oradata/{DB_NAME}/tools01.dbf	TOOLS	10
{ORACLE_BASE}/oradata/{DB_NAME}/undotbs01.dbf	UNDOTBS1	200
{ORACLE_BASE}/oradata/{DB_NAME}/users01.dbf	USERS	25
{ORACLE_BASE}/oradata/{DB_NAME}/xdb01.dbf	XDB	38.125
{ORACLE_BASE}/oradata/{DB_NAME}/temp01.dbf	TEMP	41

Control Files

Control file

{ORACLE_BASE}/oradata/{DB_NAME}/control01.ctl

{ORACLE_BASE}/oradata/{DB_NAME}/control02.ctl

{ORACLE_BASE}/oradata/{DB_NAME}/control03.ctl

Redo Log Groups

Group	Size(K)
1	102400
2	102400
3	102400