# Initialization parameter file for Oracle9i database
# on Windows XP. 
#
# Taken from Core Servlets and JavaServer Pages
# from Prentice Hall and Sun Microsystems Press,
# http://www.coreservlets.com/.
# (C) 2003 Marty Hall and Larry Brown;
# may be freely used or adapted.

# Database Identification
db_domain=coreservlets.com
db_name=csajsp

# Instance Identification
instance_name=csajsp

# Cache and I/O
db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_count=16
 
# Cursors and Library Cache
open_cursors=300
 
# Diagnostics and Statistics
background_dump_dest=C:\oracle\admin\csajsp\bdump
core_dump_dest=C:\oracle\admin\csajsp\cdump
timed_statistics=TRUE
user_dump_dest=C:\oracle\admin\csajsp\udump

# File Configuration
control_files=("C:\oracle\oradata\csajsp\CONTROL01.CTL", 
               "C:\oracle\oradata\csajsp\CONTROL02.CTL", 
               "C:\oracle\oradata\csajsp\CONTROL03.CTL")

# Job Queues
job_queue_processes=10
 
# MTS
dispatchers="(PROTOCOL=TCP) (SERVICE=csajspXDB)"
 
# Miscellaneous
aq_tm_processes=1
compatible=9.2.0.0.0
 
# Optimizer
hash_join_enabled=TRUE
query_rewrite_enabled=FALSE
star_transformation_enabled=FALSE
 
# Pools
java_pool_size=33554432
large_pool_size=8388608
shared_pool_size=50331648
 
# Processes and Sessions
processes=150
 
# Redo Log and Recovery
fast_start_mttr_target=300

# Security and Auditing
remote_login_passwordfile=EXCLUSIVE
 
# Sort, Hash Joins, Bitmap Indexes
pga_aggregate_target=25165824
sort_area_size=524288
 
# System Managed Undo and Rollback Segments
undo_management=AUTO
undo_retention=10800
undo_tablespace=undotbs