SAP参数优化

文章摘自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'

 

posted on 2012-02-22 10:06  Bruce,Zhang  阅读(1563)  评论(0)  编辑  收藏  举报

导航