General Purpose

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

Common Options

Option	Selected
Oracle JVM	true
Oracle Intermedia	true
Oracle Text	true
Oracle XML DB	true
Oracle OLAP	true
Oracle Spatial	true
Oracle Data Mining	true
Oracle Ultra Search	true
Oracle Label Security	false
Sample Schemas	false
Enterprise Manager Repository	true

Initialization Parameters

Name	Value
background_dump_dest	{ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\bdump
compatible	10.1.0.2.0
control_files	("{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control01.ctl", "{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control02.ctl", "{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control03.ctl")
core_dump_dest	{ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\cdump
db_block_size	8KB
db_cache_size	314572800
db_domain
db_files	1024
db_file_multiblock_read_count	16
db_name	wpsdb
db_recovery_file_dest	{ORACLE_BASE}\flash_recovery_area
db_recovery_file_dest_size	2048MB
dispatchers	(PROTOCOL=TCP) (SERVICE={SID}XDB)
java_pool_size	48MB
job_queue_processes	10
large_pool_size	8MB
log_buffer	65536
open_cursors	1800
pga_aggregate_target	209715200
pre_page_sga	true
processes	300
remote_login_passwordfile	EXCLUSIVE
shared_pool_size	209715200
sort_area_size	65536
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	{ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\udump

Name	Value
Database Character Set	UTF8
National Character Set	UTF8

Name	Tablespace	Size(M)
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\SYSTEM01.DBF	SYSTEM	440
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\UNDOTBS01.DBF	UNDOTBS1	25
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\SYSAUX01.DBF	SYSAUX	210
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\USERS01.DBF	USERS	5
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\TEMP01.DBF	TEMP	20

Name
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control01.ctl
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control02.ctl
{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control03.ctl