Oracle Audio Technologies Retail Data Warehouse 13 - Manual (Page 29)

Database Installation Guide 21
C
Appendix: Oracle 10g Database Creation
Scripts
###############################################################################
# Oracle 10.2.0.x Parameter file
#
# NOTES: Before using this script:
# 1. Change <datafile_path>, <admin_path>, <utl_file_path>, and <hostname>
# values as appropriate.
# 2. Replace the word SID with the database name.
# 3. Size parameters as necessary for development, test, and production
environments.
# ------------------------------------------------------------------------
# MAINTENANCE LOG
#
# Date By Parameter Old/New Notes
# +------+ +---------+ +-----------------+ +-------------+ +-------------+
# 02/20/06 Oracle NA NA creation
#
###############################################################################
# -------------------------------------------------------------------------------
# The following SGA parameters are CRITICAL to the performance of the
# database. The following settings are based on 1GB of allotted memory.
# The SGA is composed of:
# db_cache_size, log_buffer,java_pool_size, large_pool_size, shared_pool_size
# -------------------------------------------------------------------------------
db_cache_size = 256M
java_pool_size = 150M # 150M for initial db creation
log_buffer = 10485760
shared_pool_size = 350M # 350M for initial db creation
shared_pool_reserved_size = 35M # 10% of shared_pool_size
# --------------------------------------------------------------------------------
# The following parameters do not affect SGA size;
# --------------------------------------------------------------------------------
audit_file_dest = <admin_path>/adump
background_dump_dest = <admin_path>/bdump
compatible = 10.2.0
control_files = (<datafile_path>/control01.ctl
,<datafile_path>/control02.ctl)
core_dump_dest = <admin_path>/cdump
db_block_size = 8192 # Default is 2k; adjust before
db creation, cannot change after db is created
db_file_multiblock_read_count = 16 # Platform specific (max io
size)/(block size)
db_name = SID
job_queue_processes = 5 # Oracle Retail required;
number of cpu's + 1
local_listener =
"(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521))"
nls_calendar = GREGORIAN
nls_date_format = DD-MON-RR # Oracle Retail required; if
RDW database see later entry for proper format
nls_language = AMERICAN # Default
nls_numeric_characters = ".," # Should be explicitly set to
ensure all users/batch get the same results