Mani's Blog

November 16, 2011

Sample Oracle 11g init.ora file for OLTP

Filed under: Uncategorized — mani @ 12:03 am

This is sample init.ora parameter file for OLTP application.   The stand-alone DB is configured with 32GB memory.

*._replace_virtual_columns=FALSE
*._shared_io_pool_size=0
*._simple_view_merging=TRUE
*.audit_file_dest=’/local/opt/oracle/admin/DBNAME/adump’
*.audit_trail=’NONE’
*.compatible=’11.1.0.0.0′
*.control_files=’+XN_DATA/DBNAME/controlfile/control01.ctl’,’+XN_DATA/DBNAME/controlfile/control02.ctl’,’+XN_DATA/DBNAME/controlfile/control03.ctl’
*.cursor_sharing=’SIMILAR’
*.db_32k_cache_size=2147483648
*.db_block_size=8192
*.db_cache_size=12884901888
*.db_create_file_dest=’+XN_DATA’
*.db_create_online_log_dest_1=’+XN_DATA’
*.db_domain=’xxx.com’
*.db_file_multiblock_read_count=16
*.db_name=’DBNAME’
*.db_recovery_file_dest=’/local/data/oracle/nfs’
*.db_recovery_file_dest_size=1610612736000
*.db_writer_processes=2
*.diagnostic_dest=’/local/opt/oracle’
*.filesystemio_options=’setall’
*.java_pool_size=268435456
*.job_queue_processes=10
*.large_pool_size=268435456
*.log_archive_dest_1=’location=/arch/DBNAME’
*.log_archive_format=’%d-%S_%T_%r.oarl’
*.memory_max_target=28991029248
*.memory_target=0
*.open_cursors=1000
*.optimizer_mode=’ALL_ROWS’
*.pga_aggregate_target=3221225472
*.processes=1000
*.remote_login_passwordfile=’exclusive’
*.resource_manager_plan=”
*.service_names=’xxx’,’yyy’
*.sessions=1105
*.sga_max_size=26843545600
*.sga_target=0
*.shared_pool_size=5368709120
*.streams_pool_size=0
*.undo_tablespace=’UNDOTBS1′

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: