Oracle post installation parameter tuning

[former_member201054]

I have installed oracle(10.1) and SAP(ECC 6.0) successfully on an AIX (5.3)platform, now what oracle parameters to be changed and it should be done where for optimum perforamance.Please let me know all the oracle post installation steps for ECC 6.0 and AIX 5.3.

[former_member204746 · Accepted solution]

here's my initSID.ora file:

#
# Set as of OSS note 830576 version 159 dated 23.09.2007 
# oracle 10.2.0.4 patch 8
#
_first_spare_parameter=1
_optimizer_mjc_enabled=FALSE
_push_join_union_view=FALSE
_sort_elimination_cost_ratio=10
#
# BEGIN SAP note 1165319
#
_fix_control='6120483:OFF'
_fix_control='6329318:OFF'
_fix_control='5765456:7'
_fix_control='5705630:ON'
_fix_control='6221403:ON'
_fix_control='6440977:ON'
_fix_control='6626018:ON'
_fix_control='6972291:ON'
#
# END SAP note 1165319
#
archive_lag_target=3000
background_dump_dest=D:\ORACLE\PRD\SAPTRACE\BACKGROUND
compatible=10.2.0
control_file_record_keep_time=30
control_files='E:\oracle\PRD\cntrl\cntrlPRD.dbf','D:\oracle\PRD\cntrl\cntrlPRD.dbf','J:\oracle\PRD\cntrl\cntrlPRD.dbf'
core_dump_dest=D:\ORACLE\PRD\SAPTRACE\BACKGROUND
db_block_size=8192
db_cache_size=10243063680
db_files=500
db_name=PRD
#
# List of events with explanation, it is important that all these events to be grouped together
#
#Event 10027: Note 596420 set for Oracle 8i, 9i and 10g
#Event 10028: Note 596420 set for Oracle 8i, 9i and 10g
#Event 10049: Note 1253845, only WINDOWS, 10.2.0.4 with mini patch 5 to 9
#Event 10091: DO NOT SET: Note 1227227, 10.2.0.2 or 10.2.0.4 without fix 7188932
#Event 10162: DO NOT SET: Notes 977319, 1040300, <= 10.2.0.2
#Event 10183: Note 128648 set for Oracle 8i, 9i and 10g
#Event 10191: Note 128221 set for Oracle 8i, 9i and 10g
#Event 10411: Note 830576 10.2.0.4 or higher
#Event 10629: Note 869521 >=9.2.0.6
#Event 10891: Note 1037651 >=10.2.0.2
#Event 14532: Note 1031682 >=10.2.0.2
#Event 38068: Note 176754
#Event 38085: Note 1165319 >= 10.2.0.4
#Event 38087: Note 948197
#Event 44951: Note 1166242 >= 10.2.0.4
event="10027 trace name context forever, level 1"
event="10028 trace name context forever, level 1"
event="10049 trace name context forever, level 2"
event="10183 trace name context forever, level 1"
event="10191 trace name context forever, level 1"
event="10411 trace name context forever, level 1"
event="10629 trace name context forever, level 32"
event="10891 trace name context forever, level 1"
event="14532 trace name context forever, level 1"
event="38068 trace name context forever, level 100"
event="38085 trace name context forever, level 1"
event="38087 trace name context forever, level 1"
event="44951 trace name context forever, level 1024"
#
# END OF List of events
#
filesystemio_options=SETALL
log_archive_dest_1="LOCATION=E:\oracle\PRD\saparch\PRDarch"
log_archive_format=%t_%s_%r.dbf
log_buffer=1048576
log_checkpoints_to_alert=TRUE
max_dump_file_size=20000
open_cursors=800
# MANUAL CHANGE, not recommended as per SAP note 830576
optimizer_dynamic_sampling=2
#
# end of manual change
#
#
# set only for OLTP system, do not set on BW
#
optimizer_index_caching=50
optimizer_index_cost_adj=20
#
# END OF SPECIAL set only for OLTP system
#
parallel_execution_message_size=16384
#
#parallel_max_servers=DB-CPU-Cores * 10
#
parallel_max_servers=20
parallel_threads_per_cpu=1
#
#pga_aggregate_target
#OLTP: 20 % of available memory
#OLAP: 40 % of available memory
#
pga_aggregate_target=3355443200
#
# processes =
# ABAP work processes * 2 +
# J2EE server processes *
# <max-connections> +
# PARALLEL_MAX_SERVERS + 40
#
processes=300
query_rewrite_enabled=FALSE
recyclebin=OFF
remote_os_authent=TRUE
replication_dependency_tracking=FALSE
resource_manager_plan=""
#
# session = processes * 2
#
sessions=600
#
# shared_pool_size
# CPUs value
# ---- ------
#    4 650M
#    6 1G
#   10 1.175G
#   32 2.75G
#   64 2.75G
#  128 3G
#
#old value=shared_pool_size=1557056000
shared_pool_size=1610612736
star_transformation_enabled=TRUE
undo_management=AUTO
undo_retention=900
undo_tablespace=PSAPUNDO
user_dump_dest=D:\ORACLE\PRD\SAPTRACE\USERTRACE

[Former Member]

Hi,

I have installed oracle(10.1)

10.1 it not supported from SAP, you need patch at least 10.2.0.2 (or 10.2.0.4) and after implement OPatche's

to... Regards.

[former_member227600]

Hi ,

please read the following note for Oracle10g parameter setting.

Note 830576 - Parameter recommendations for Oracle 10g

Regards

karan