initASR parameter

[oraprod@tjpsb004 dbs]$ cat initASR.ora

ASR.__db_cache_size=15367929856

ASR.__java_pool_size=402653184

ASR.__large_pool_size=67108864

ASR.__pga_aggregate_target=5368709120

ASR.__sga_target=21474836480

ASR.__shared_io_pool_size=0

ASR.__shared_pool_size=5368709120

ASR.__streams_pool_size=67108864

*._b_tree_bitmap_plans=FALSE# Required 11i setting

*._fast_full_scan_enabled=FALSE

*._gby_hash_aggregation_enabled=FALSE

*._like_with_bind_as_equality=TRUE

*._optimizer_autostats_job=FALSE

*._query_on_physical=FALSE

*._remove_aggr_subquery=FALSE

*._sort_elimination_cost_ratio=5

*._system_trig_enabled=true

*._trace_files_public=TRUE

*.aq_tm_processes=1

*.archive_lag_target=0

*.audit_sys_operations=TRUE

*.audit_trail='DB','EXTENDED'

*.cell_offload_processing=FALSE

*.compatible='11.2.0'

*.control_files='/oradb/oracle/product/ASR/db/apps_st/data/cntrl01.dbf','/oradb_1/oracle/produ ct/ASR/db/apps_st/data/cntrl03.dbf','/oradb_2/oracle/product/ASR/db/apps_st/data/cntrl02.dbf'

*.cursor_sharing='EXACT'# Required 11i settting

*.db_block_checking='FALSE'

*.db_block_checksum='TRUE'

*.db_block_size=8192

*.db_files=512# Max. no. of database files

*.db_lost_write_protect='FULL'

*.db_name='ASR'

*.db_unique_name='EBS_MAS'

*.db_writer_processes=1

*.dg_broker_start=TRUE

*.diagnostic_dest='/orahome/oracle/product/ASR/db/adr'

*.dml_locks=10000

*.event='38022 trace name context forever, level 1'

*.fal_server='ebs_stndby'

*.filesystemio_options='SETALL'

*.job_queue_processes=8

*.log_archive_config='dg_config=(EBS_MAS,EBS_HY)'

*.log_archive_dest_1='LOCATION=/arch/oracle/product/ASR/db/apps_st/data'

*.log_archive_dest_2='service="ebs_stndby"','LGWR ASYNC NOAFFIRM delay=0 optional compression=d isable max_failure=0 max_connections=1 reopen=300 db_unique_name="EBS_HY" net_timeout=30 ','valid_for=(all_logfiles,primary_role)'

*.log_archive_dest_state_2='ENABLE'

*.log_archive_format='ASR_%t_%r_%s.arc'

ASR.log_archive_format='ASR_%t_%r_%s.arc'

*.log_archive_max_processes=4

*.log_archive_min_succeed_dest=1

ASR.log_archive_trace=0

*.log_buffer=52428800

*.log_checkpoint_interval=100000

*.log_checkpoints_to_alert=TRUE

*.max_dump_file_size='20480'# trace file size

*.nls_comp='binary'# Required 11i setting

*.nls_date_format='DD-MON-RR'

*.nls_length_semantics='BYTE'# Required 11i setting

*.nls_numeric_characters='.,'

*.nls_sort='binary'# Required 11i setting

*.nls_territory='america'

*.olap_page_pool_size=157286400

*.open_cursors=1200# Consumes process memory, unless using MTS.

*.optimizer_secure_view_merging=false

*.parallel_max_servers=8

*.parallel_min_servers=0

*.pga_aggregate_target=5G

*.plsql_code_type='INTERPRETED'# Default 11i setting

*.processes=1200# Max. no. of users x 2

*.resource_manager_plan=''

*.sec_case_sensitive_logon=FALSE

*.service_names='ASR','EBS_MAS'

*.session_cached_cursors=1600

*.sessions=2400# 2 X processes

*.sga_max_size=20G

*.sga_target=20G

*.shared_pool_reserved_size=500M

*.shared_pool_size=5G

*.standby_file_management='AUTO'

*.undo_management='AUTO'# Required 11i setting

*.undo_tablespace='APPS_UNDOTS1'# Required 11i setting

*.utl_file_dir='/usr/tmp','/usr/bin','/tmp/OUTBOUND','/orahome/oracle/product/ASR/db/tech_st/1 1.2.0/appsutil/outbound/ASR_tjpsb004','/usr/tmp'

*.workarea_size_policy='AUTO'# Required 11i setting