Init.ora
======
db_name = "sblprod"
instance_name = sblprod
service_names = sblprod

control_files = ("/oracle/ora92/oradata/sblprod/control01.ctl",
"/oracle/ora92/oradata/sblprod/control02.ctl",
"/oracle/ora92/oradata/sblprod/control03.ctl")

open_cursors = 3000
max_enabled_roles = 60

db_block_size = 8192
db_block_buffers = 983040 # Changed 10/02 ver 4.0
#db_cache_size=805306380 # db_cache_size= db_block_buffers * db_block_size
#db_cache_size=905306380
#db_cache_size=1273741824
#db_cache_size=2073741824 # Changed 09/01 ver 1.0
db_writer_processes=8
#db_file_multiblock_read_count=64
db_file_multiblock_read_count=16 # chyanged 10/02 ver 4.0
Parallel_automatic_Tuning = TRUE

buffer_pool_keep = (buffers:158000,lru_latches:12) # changed 10/02 ver 3.0
buffer_pool_recycle = (buffers:294448, lru_latches:10) # changed 10/02 ver 3.0


NLS_SORT = BINARY
shared_pool_reserved_size = 944371840
#shared_pool_reserved_size = 188743680 # Changed 09/08 ver 2.0

cursor_sharing = EXACT
session_cached_cursors = 200

#shared_pool_size = 1643718400 # Changed 09/01 ver 1.0
#shared_pool_size = 1943718400 # Changed 09/08 ver 2.0
#shared_pool_size = 2443718400 # Changed 09/08 ver 4.0
shared_pool_size = 3443718400 # Changed 09/08 ver 4.0
#large_pool_size = 504857600
large_pool_size = 804857600 # Changed 09/08 ver 2.0
java_pool_size = 1600000

log_checkpoint_interval = 51360000
processes = 3200
log_buffer = 4048000

log_archive_start = true
#log_archive_dest_1 = "location=/interfaces/sblprod/"
log_archive_dest_1 = "location=/arch"
log_archive_format = arch_%t_%s.arc
#log_archive_max_processes = 2 #check

undo_management=auto # Changed 09/01
undo_tablespace=undo_tbs # Changed 09/01
undo_retention=7200 # Changed 09/01

background_dump_dest = /oracle/ora92/admin/sblprod/bdump
core_dump_dest = /oracle/ora92/admin/sblprod/cdump
user_dump_dest = /oracle/ora92/admin/sblprod/udump

remote_login_passwordfile = exclusive # Changed for upgrade
#remote_login_passwordfile = none

#os_authent_prefix = ""
#mts_servers=0

#compatible = "8.1.7"
compatible = 9.2.0
#sort_area_size = 259715200 # changed 09/08 ver 2.0
#sort_area_retained_size = 26214400 # changed 09/08 ver 2.0
workarea_size_policy=AUTO # Changed 09/01 ver 1.0
pga_aggregate_target=2147483648 # Changed 09/01 ver 1.0


#sort_multiblock_read_count=32 # obsolete
utl_file_dir=/interfaces

#optimizer_mode=Rule # Changed for upgarde Changed 09/11 ver 3.0
#optimizer_mode=CHOOSE #all parameter has to change if opt_mode=choose

# Oracle recomeded parameter to work with optimizer mode

optimizer_mode=CHOOSE # Changed for oracle upgrade
#hash_area_size= 419430400 # 2*sort_area_size # changed 09/08 ver 2.0
hash_join_enabled=true
optimizer_dynamic_sampling=1
optimizer_features_enable=9.2.0
#optimizer_index_caching=20
optimizer_index_caching=0 # changed 10/02 ver 4.0
partition_view_enabled=false
query_rewrite_enabled=false
query_rewrite_integrity=enforced
star_transformation_enabled=false

# Siebel recomended parameter for optimizer mode

#optimizer_max_permutations=100
optimizer_max_permutations=2000 # changed 10/02 ver 4.0
optimizer_index_cost_adj=1

timed_statistics=True

log_checkpoints_to_alert=TRUE
#db_block_lru_latches=70 # obsolete

#_system_trig_enabled=false # explicitly set fpr upgrade

db_files=350

job_queue_processes=2 # Changed for upgrade
#job_queue_processes=0

nls_date_format='DD-MM-YYYY'

#fast_start_io_target = 327680
lock_sga = TRUE #check may be obsolete
pre_page_sga = TRUE

resource_limit = TRUE
#EVENT = "10619 trace name context forever, level 1"
utl_file_dir='/interfaces','c:\temp'