init

TEST.__db_cache_size=595591168
TEST.__java_pool_size=16777216
TEST.__large_pool_size=12582912
TEST.__pga_aggregate_target=1073741824
TEST.__sga_target=1073741824
TEST.__shared_io_pool_size=0
TEST.__shared_pool_size=419430400
TEST.__streams_pool_size=8388608
*._b_tree_bitmap_plans=FALSE# Required 11i setting
*._fast_full_scan_enabled=FALSE
*._like_with_bind_as_equality=TRUE
*._optimizer_autostats_job=false# Turning off auto statistics
*._sort_elimination_cost_ratio=5
*._system_trig_enabled=true
*._TRACE_FILES_PUBLIC=FALSE
*.aq_tm_processes=1
*.AUDIT_SYS_OPERATIONS=TRUE
*.compatible='11.2.0'
*.control_files='/ORADB/oradata/TEST/cntrl01.dbf','/ORADB/oradata/TEST/cntrl02.dbf','/ORADB/oradata/TEST/cntrl03.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_name='TEST'
*.diagnostic_dest='/GSTDB/app/oratest/db/11.2.0/admin/TEST_tjpsb007'
*.dml_locks=10000
*.job_queue_processes=2
*.local_listener='TEST_LOCAL'
*.log_archive_dest_1='LOCATION=/ORADB/oradata/TEST/archive'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=10485760
*.log_checkpoint_interval=100000
*.log_checkpoint_timeout=1200# Checkpoint at least every 20 mins.
*.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'
*.o7_dictionary_accessibility=FALSE#MP
*.olap_page_pool_size=4194304
*.open_cursors=600# Consumes process memory, unless using MTS.
*.optimizer_secure_view_merging=false
*.OS_AUTHENT_PREFIX=''
*.parallel_max_servers=8
*.parallel_min_servers=0
*.pga_aggregate_target=1G
*.plsql_code_type='INTERPRETED'# Default 11i setting
*.plsql_optimize_level=2# Required 11i setting
*.processes=200# Max. no. of users x 2
*.sec_case_sensitive_logon=FALSE
*.session_cached_cursors=500
*.sessions=400# 2 X processes 
*.sga_target=1G
*.shared_pool_reserved_size=40M
*.shared_pool_size=400M
*.SQL92_SECURITY=TRUE
*.undo_management='AUTO'# Required 11i setting
*.undo_tablespace='APPS_UNDOTS1'# Required 11i setting
*.utl_file_dir='/usr/tmp','/GSTDB/app/oratest/utl_dir','/GSTDB/app/oratest/db/11.2.0/appsutil/outbound/TEST_tjpsb007','/usr/tmp'
*.workarea_size_policy='AUTO'# Required 11i setting