Oracle 9i Release 2 New Database template

[Terrence Miao <terrence@xxxxxxxxxxxxxx>]

New Database

Use this template to create a customized database.

Common Options

Option Name	Selected
Example Schemas	true
Oracle Data Mining	true
Oracle Intermedia	true
Oracle JVM	true
Oracle Label Security	false
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	8KB
db_cache_size	24MB
db_file_multiblock_read_count	16
dispatchers	(PROTOCOL=TCP) (SERVICE={SID}XDB)
fast_start_mttr_target	300
hash_join_enabled	TRUE
java_pool_size	80MB
job_queue_processes	10
large_pool_size	8MB
open_cursors	300
pga_aggregate_target	24MB
processes	150
query_rewrite_enabled	FALSE
remote_login_passwordfile	EXCLUSIVE
shared_pool_size	80MB
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

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

Tablespaces

Status	Name	Type	Extent management
ONLINE	CWMLITE	PERMANENT	LOCAL
ONLINE	DRSYS	PERMANENT	LOCAL
ONLINE	EXAMPLE	PERMANENT	LOCAL
ONLINE	INDX	PERMANENT	LOCAL
ONLINE	ODM	PERMANENT	LOCAL
ONLINE	SYSTEM	PERMANENT	LOCAL
ONLINE	TEMP	TEMPORARY	LOCAL
ONLINE	TOOLS	PERMANENT	LOCAL
ONLINE	UNDOTBS1	PERMANENT , UNDO	LOCAL
ONLINE	USERS	PERMANENT	LOCAL
ONLINE	XDB	PERMANENT	LOCAL

Data Files

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

Redo Log Groups

Group	Size(K)
1	102400
2	102400
3	102400