# PFILE Template
# Note: This is a "default" suitable for most installations
# Obviously, performance parameters need to be set on an individual basis
#
# File destinations
# @ = ORACLE_SID, gets replaced by oracle on startup, allows for nicely generic pfiles.
#
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+REDO'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=50g

#
# Generic parameters
#
*.compatible='11.1.0.7.0'
*.db_block_size=8192
*.db_domain='FOO.BAR.BAZ'
*.db_name='FOO'
*.db_unique_name='FOO'
*.job_queue_processes=10
*.log_archive_format='%t_%s_%r.dbf'
*.log_archive_max_processes=4
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'

#
# Performance parameters
#
*.filesystemio_options=setall
*.processes=1000
*.memory_target=2g
*.session_cached_cursors=150
*.db_ultra_safe=off
#*.db_securefile=always  #set this AFTER DB creation if you're installing XDB
#*.plsql_code_type=native # set this AFTER DB creation
#*.plsql_optimize_level=3 # set this AFTER DB creation
*.result_cache_mode=auto
*.result_cache_max_size=512m
*.result_cache_max_result=20
*.db_writer_processes=1
*.parallel_max_servers=32
*.parallel_execution_message_size=32768