The below text is the Oracle 10g parameter file used in the
production database at the University of Michigan (as of 8/10/2007). They are currently using
Oracle 10.2.0.3.0. The properties (such as IP, server name etc)
used in the parameter file have been modified and they are not real
ones.
A few notes.
1). Michigan uses a primary-standby setting. If you do not have a standby
database, the fal_client/server do not have to be used.
2). The PGA don't need to be large. Michigan recently reduced the
pga_aggregate_target from 512M to 256M.
3). Some of the parameters are 10g and later.
4). If using 10g, you may want to adjust some of the default
settings for maintenance and awr report. For example, Oracle takes a
snapshot, by default, every hour, which may not be enough,
especially when there is problem. You may want to adjust this to 20 to
30 minutes. To adjust the default snapshot, see Oracle support
Metalink's Note:377143.1; The default weekday Oracle maintenance window
(collecting stats, for example) is at 10pm, which is a high-usage time
and Michigan adjusts it to early in the morning. To adjust the default
maintenance window, see
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/tasks.htm.
SAKAI.__db_cache_size=6190792704
SAKAI.__java_pool_size=33554432
SAKAI.__large_pool_size=16777216
SAKAI.__shared_pool_size=620756992
SAKAI.__streams_pool_size=0
*.archive_lag_target=600
*.audit_file_dest='/u01/app/oracle/admin/SAKAI/adump'
*.background_dump_dest='/u01/app/oracle/admin/SAKAI/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u02/oradata/SAKAI/control01.ctl','/u02/oradata/SAKAI/control02.ctl','/u02/oradata/SAKAI/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/SAKAI/cdump'
*.cursor_sharing='FORCE'
*.db_block_size=16384
*.db_create_online_log_dest_2=''
*.db_domain=''
*.db_file_multiblock_read_count=64
*.db_flashback_retention_target=500
*.db_name='SAKAI'
*.db_recovery_file_dest='/u02/flash_recovery_area/SAKAI'
*.db_recovery_file_dest_size=103079215104
*.db_unique_name='SAKAI_primary'
*.dg_broker_start=TRUE
*.dispatchers='(PROTOCOL=TCP) (SERVICE=SAKAIXDB)'
*.fal_client='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=121.105.235.199)(PORT=11587)))(CONNECT_DATA=(SERVICE_NAME=SAKAI_primary_XPT)(INSTANCE_NAME=SAKAI)(SERVER=dedicated)))'
*.fal_server='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=121.105.235.96)(PORT=11587)))(CONNECT_DATA=(SERVICE_NAME=SAKAI_XPT)(SERVER=dedic
ated)))','(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=121.105.235.95)(PORT=11587)))(CONNECT_DATA=(SERVICE_NAME=SAKAI_DELPHI_XPT)(INSTANCE_NAME=SAKAI)(SERVER=dedicated)))'
*.filesystemio_options='SETALL'
*.job_queue_processes=100
*.local_listener='SAKAI_primary'
*.log_archive_config='dg_config=(SAKAI,SAKAI_standby1)'
*.log_archive_dest_1='location="/u02/oradata/arch/SAKAI"','valid_for=(ONLINE_LOGFILE,ALL_ROLES)
DB_UNIQUE_NAME=SAKAI_primary'
*.log_archive_dest_2='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=standby1.os.umich.edu)(PORT=11587)))(CONNECT_DATA=(SERVICE_NAME=SAKAI_standby1_XPT)(INSTANCE_NAME=SAKAI)(SERVER=dedicated)))"','
ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1
reopen=300
db_unique_name="SAKAI_standby1" register net_timeout=180
valid_for=(online_logfile,primary_role)'
*.log_archive_dest_3=''
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_dest_state_3='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=2
*.log_archive_min_succeed_dest=1
*.open_cursors=300
*.pga_aggregate_target=268435456
*.processes=1000
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=6871947674
*.sga_target=6871947674
*.standby_archive_dest='/u01/app/oracle/admin/SAKAI/arch'
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_retention=18000
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/SAKAI/udump'