# 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.
#
*.audit_file_dest='/opt/app/oracle/admin/@/adump'
*.background_dump_dest='/opt/app/oracle/admin/@/bdump'
*.core_dump_dest='/opt/app/oracle/admin/@/cdump'
*.user_dump_dest='/opt/app/oracle/admin/@/udump'
*.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='10.2.0.4.0'
*.db_block_size=8192
*.db_domain='swi.srse.net'
*.db_name='TGSAS01'
*.db_unique_name='TGSAS01'
*.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
#
*.pga_aggregate_target=5g
*.processes=1000
*.sga_target=2g
*.session_cached_cursors=150
*.db_writer_processes=1
*.parallel_max_servers=32
*.parallel_execution_message_size=32768