Oracle 9i Release 2 Transaction Processing template

[Terrence Miao <terrence@xxxxxxxxxxxxxx>]

Transaction_Processing

Use this database template to create a pre-configured database optimized for transaction processing.

Common Options

Option Name	Selected
Example Schemas	true
Oracle Data Mining	true
Oracle Intermedia	true
Oracle JVM	true
Oracle Label Security	true
Oracle OLAP	false
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	4096
db_cache_size	33554432
db_file_multiblock_read_count	8
db_name
dispatchers	(PROTOCOL=TCP) (SERVICE={SID}XDB)
fast_start_mttr_target	300
hash_join_enabled	FALSE
java_pool_size	83886080
job_queue_processes	10
large_pool_size	16777216
open_cursors	300
pga_aggregate_target	16777216
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	900
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}/drsys01.dbf	DRSYS	20
{ORACLE_BASE}/oradata/{DB_NAME}/example01.dbf	EXAMPLE	136.875
{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	340
{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	93

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