SAP参数优化

yonhu

　　文章摘自http://blog.sina.com.cn/cenmengbo 中兴精密的博客
　　环境介绍：
　　DEV    IBM P520/4.5*2/16G    有配置CLIENT,开发CLIENT,和几个测试CLIENT
　　
　　/usr/sap/DEV/SYS/profile/DEV_DVEBMGS00_DEV  参数优化后参数如下

2011/10/26 Active parameters 08:26:20

此处的参数可以通过ST02来分析并设置，设置后重启SAP.

　　鼠标双击红色部分

　　双击“当前参数”

　　调整参数，完毕！

Parameter Name	Parameter value
abap/heaplimit	40000000
rdisp/max_wprun_time	72000
abap/swap_reserve	20971520
rdisp/ROLL_SHM	65536
rdisp/ROLL_MAXFS	65536
rdisp/PG_SHM	65536
rsdb/obj/max_objects	15000
rdisp/rfc_max_login	50
rsdb/obj/buffersize	30000
rtbb/max_tables	2000
rtbb/buffer_length	25000
zcsa/db_max_buftab	10000
zcsa/table_buffer_area	75000000
sap/bufdir_entries	8000
zcsa/presentation_buffer_area	25000000
rsdb/cua/buffersize	12000
abap/use_paging	0
abap/buffersize	1000000
rsdb/ntab/irbdsize	12000
rsdb/ntab/sntabsize	6000
rsdb/ntab/ftabsize	30000
rsdb/ntab/entrycount	40000
abap/heap_area_nondia	1000000000
abap/heap_area_dia	1000000000
abap/heap_area_total	500000000
rdisp/PG_MAXFS	65536
ztta/roll_extension	500000000
ztta/roll_area	15000000
login/system_client	670
zcsa/system_language	1
login/no_automatic_user_sapstar	0
install/codepage/appl_server	8400
install/codepage/db/transp	8400
zcsa/installed_languages	1ED
SAPSYSTEMNAME	DEV
SAPSYSTEM	00
INSTANCE_NAME	DVEBMGS00
DIR_CT_RUN	$(DIR_EXE_ROOT)/run
DIR_EXECUTABLE	$(DIR_INSTANCE)/exe
exe/saposcol	$(DIR_CT_RUN)/saposcol
rdisp/wp_no_dia	10
rdisp/wp_no_btc	3
exe/icmbnd	$(DIR_CT_RUN)/icmbnd
icm/server_port_0	PROT=HTTP,PORT=80$$
ms/server_port_0	PROT=HTTP,PORT=81$$
rdisp/wp_no_enq	4
rdisp/wp_no_vb	6
rdisp/wp_no_vb2	3
rdisp/wp_no_spo	1
em/initial_size_MB	5120
ipc/shm_psize_10	162000000
ipc/shm_psize_14	0
ipc/shm_psize_18	0
ipc/shm_psize_19	0
ipc/shm_psize_30	-10
ipc/shm_psize_40	146000000
ipc/shm_psize_41	0
ipc/shm_psize_51	-10
ipc/shm_psize_52	-10
ipc/shm_psize_54	-10
ipc/shm_psize_55	-10
ipc/shm_psize_57	-10
ipc/shm_psize_58	-10

  

2./oracle/DEV/102_64/dbs/initDEV.ora  参数优化后的结果

###########################################################
#  (c)Copyright SAP AG, Walldorf                          #
# @(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/INITSIDBASE.ORA#1 $
###########################################################
###########################################################
# PART I, TUNING PARAMETERS                               #
###########################################################
#### SYSTEM GLOBAL AREA BUFFERS
# Total System Global Area = sum(bytes) of all caches
# Variable Size = shared_pool_size (approx.)
# Database Buffers = db_block_buffers * db_block_size
# Redo Buffers = log_buffer
#
# unit of shared_pool_size: bytes
# unit of db_block_buffers: number of cached blocks
# unit of log_buffer: bytes
shared_pool_size = 3145728000
# 10% of shared_pool_size
shared_pool_reserved_size = 221962567
log_buffer = 1048576
#### MANAGING SORTS
# A small sort requires sort_area_retained_size in
# memory. Larger sorts are allocating segments in
# PSAPTEMP. They are using sort_area_size in memory.
sort_area_retained_size = 0
sort_area_size = 2097152
#sort_spacemap_size = 512
#### PGA-PARAMETERS
open_cursors = 800
#cursor_space_for_time =  true
#### LOCKS
# dml_locks = processes * 50
dml_locks = 4000
#enqueue_resources = 8000
#### CPU-PARAMETERS
#spin_count = 200
#_cpu_count = 4
#### TUNING ARCHIVING
#log_archive_buffer_size      127
#log_archive_buffers      4
#### USE VECTOR READ
#use_readv = true
#### OTHER TUNING PARAMETERS
#sequence_cache_entries = 100
#sequence_cache_hash_buckets = 89
###########################################################
# PART II, CHANGEABLE PARAMETERS                          #
###########################################################
#### CONTROL-FILES
# the controlfiles should be mirrored to every new
# database mount point @SAPDATA_HOME@/sapdata<#>
#control_files = @SAPDATA1@/cntrl/cntrlDEV.dbf @SAPDATA2@/cntrl/cntrlDEV.dbf @SAPDATA3@/cntrl/cntrlDEV.dbf
#### AUTOMATICLY STARTED BACKGROUND PROCESSES
#### MANAGING LOG SWITCHES
# checkpoints occur only when switching logs, if
# log_checkpoint_interval * size of OS blocks > size of
# the actual redo log
log_checkpoint_interval = 0
#log_checkpoint_timeout = 0
#### PROCESS-PARAMETERS
# The number of allocated semaphores is equal to the
# number of processes
# sessions = 1.2 * processes
processes = 150
sessions  = 300
#### AUDITING AND STATISTICS
# sql_trace=TRUE
# audit_trail = true
# db_block_lru_extended_statistics = 1000
# db_block_lru_statistics = true
###########################################################
# PART III, STATIC PARAMETERS                             #
###########################################################
#### DB-NAME
db_name = DEV
#### DB-BLOCKSIZE
db_block_size = 8192
#### DB-FILES
db_files = 254
#### OPTIMIZER MODE
#optimizer_mode = choose
#optimizer_search_limit = 3
#### PATHS / DESTINATIONS / TRACES
# /oracle/DEV/saptrace/background: trace files of the background
# processes
# /oracle/DEV/saptrace/usertrace:  trace files of the user processes
# log_archive_dest is a destination, not a path.
# The archivefiles get the name
# /oracle/DEV/oraarch/DEVarch<thread#>_<log#>
background_dump_dest = /oracle/DEV/saptrace/background
user_dump_dest       = /oracle/DEV/saptrace/usertrace
core_dump_dest       = /oracle/DEV/saptrace/background
log_archive_dest     = /oracle/DEV/oraarch/DEVarch
#log_archive_format  = %t_%s
#### OTHER
# reduce_alarm only supported on HP
#reduce_alarm = TRUE
#### ORACLE OPS PARAMETER
remote_os_authent = true
# retention time for RMAN backup information in control file
control_file_record_keep_time = 30
#see SAP note 124361
#db_file_multiblock_read_count = 8
log_checkpoints_to_alert = true
#### OPTIMIZER MODE
#optimizer_index_cost_adj = 10
#### AUDITING AND STATISTICS
#timed_statistics = true
compatible = 10.2.0
parallel_execution_message_size = 16384
query_rewrite_enabled = false
replication_dependency_tracking = false
star_transformation_enabled = true
undo_retention = 43200
undo_tablespace = PSAPUNDO
undo_management = AUTO
pga_aggregate_target = 6059500902

#总和
sga_max_size = 13335873454
db_cache_size = 10737418240
job_queue_processes = 1
remote_login_passwordfile = exclusive
recyclebin = off
event = "10191 trace name context forever, level 1"
FILESYSTEMIO_OPTIONS = setall
_OPTIM_PEEK_USER_BINDS = FALSE
_B_TREE_BITMAP_PLANS = FALSE
_INDEX_JOIN_ENABLED = FALSE
_IN_MEMORY_UNDO = FALSE
_OPTIMIZER_MJC_ENABLED = FALSE
_SORT_ELIMINATION_COST_RATIO = 10
_TABLE_LOOKUP_PREFETCH_SIZE = 0
control_files = (/oracle/DEV/origlogA/cntrl/cntrlDEV.dbf, /oracle/DEV/origlogB/cntrl/cntrlDEV.dbf, /oracle/DEV/sapdata1/cntrl/cntrlDEV.dbf)

　　
　　把ORACLE的DATABUFFER扩大到了10G

3.为了SAP跑的更快，需要DB02  在GLOBAL 下把数据库定期update，oracle dictionary,system statistics下。以上3个可以同时进行。

公司参数

1 *._B_TREE_BITMAP_PLANS=FALSE
2 *._IN_MEMORY_UNDO=FALSE
3 *._INDEX_JOIN_ENABLED=FALSE
4 *._OPTIM_PEEK_USER_BINDS=FALSE
5 *._OPTIMIZER_MJC_ENABLED=FALSE
6 *._SORT_ELIMINATION_COST_RATIO=10
7 *._TABLE_LOOKUP_PREFETCH_SIZE=0
8 *.background_dump_dest='D:\oracle\CLN\saptrace\background'
9 *.compatible='10.2.0'
10 *.control_file_record_keep_time=30
11 *.control_files='D:\oracle\CLN\origlogA\cntrl\cntrlCLN.dbf','D:\oracle\CLN\origlogB\cntrl\cntrlCLN.dbf','D:\oracle\CLN\sapdata1\cntrl\cntrlCLN.dbf'
12 *.core_dump_dest='D:\oracle\CLN\saptrace\background'
13 *.db_block_size=8192
14 *.db_cache_size=1864684134
15 *.db_files=254
16 *.db_name='CLN'
17 *.dml_locks=4000
18 *.event='10191 trace name context forever, level 1'
19 *.FILESYSTEMIO_OPTIONS='setall'
20 *.job_queue_processes=1
21 *.log_archive_dest_1='LOCATION=D:\oracle\CLN\oraarch\CLNarch'
22 *.log_archive_dest=''
23 *.log_buffer=1048576
24 *.log_checkpoint_interval=0
25 *.log_checkpoints_to_alert=true
26 *.open_cursors=800
27 *.parallel_execution_message_size=16384
28 *.pga_aggregate_target=629145600
29 *.processes=80
30 *.query_rewrite_enabled='false'
31 *.recyclebin='off'
32 *.remote_login_passwordfile='exclusive'
33 *.remote_os_authent=true
34 *.replication_dependency_tracking=false
35 *.sessions=160
36 *.sga_max_size=2729368268
37 *.shared_pool_reserved_size=96468413
38 *.shared_pool_size=964684134
39 *.sort_area_retained_size=0
40 *.sort_area_size=2097152
41 *.star_transformation_enabled='true'
42 *.undo_management='AUTO'
43 *.undo_retention=43200
44 *.undo_tablespace='PSAPUNDO'
45 *.user_dump_dest='D:\oracle\CLN\saptrace\usertrace'