设为首页 收藏本站
查看: 1548|回复: 0

[经验分享] SAP参数优化

[复制链接]

尚未签到

发表于 2015-9-20 00:08:31 | 显示全部楼层 |阅读模式
  文章摘自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.

DSC0000.jpg
  鼠标双击红色部分
DSC0001.jpg
  双击“当前参数”
DSC0002.jpg
  调整参数,完毕!

Parameter NameParameter value
abap/heaplimit40000000
rdisp/max_wprun_time72000
abap/swap_reserve20971520
rdisp/ROLL_SHM65536
rdisp/ROLL_MAXFS65536
rdisp/PG_SHM65536
rsdb/obj/max_objects15000
rdisp/rfc_max_login50
rsdb/obj/buffersize30000
rtbb/max_tables2000
rtbb/buffer_length25000
zcsa/db_max_buftab10000
zcsa/table_buffer_area75000000
sap/bufdir_entries8000
zcsa/presentation_buffer_area25000000
rsdb/cua/buffersize12000
abap/use_paging0
abap/buffersize1000000
rsdb/ntab/irbdsize12000
rsdb/ntab/sntabsize6000
rsdb/ntab/ftabsize30000
rsdb/ntab/entrycount40000
abap/heap_area_nondia1000000000
abap/heap_area_dia1000000000
abap/heap_area_total500000000
rdisp/PG_MAXFS65536
ztta/roll_extension500000000
ztta/roll_area15000000
login/system_client670
zcsa/system_language1
login/no_automatic_user_sapstar0
install/codepage/appl_server8400
install/codepage/db/transp8400
zcsa/installed_languages1ED
SAPSYSTEMNAMEDEV
SAPSYSTEM00
INSTANCE_NAMEDVEBMGS00
DIR_CT_RUN$(DIR_EXE_ROOT)/run
DIR_EXECUTABLE$(DIR_INSTANCE)/exe
exe/saposcol$(DIR_CT_RUN)/saposcol
rdisp/wp_no_dia10
rdisp/wp_no_btc3
exe/icmbnd$(DIR_CT_RUN)/icmbnd
icm/server_port_0PROT=HTTP,PORT=80$$
ms/server_port_0PROT=HTTP,PORT=81$$
rdisp/wp_no_enq4
rdisp/wp_no_vb6
rdisp/wp_no_vb23
rdisp/wp_no_spo1
em/initial_size_MB5120
ipc/shm_psize_10162000000
ipc/shm_psize_140
ipc/shm_psize_180
ipc/shm_psize_190
ipc/shm_psize_30-10
ipc/shm_psize_40146000000
ipc/shm_psize_410
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'

运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.yunweiku.com/thread-115942-1-1.html 上篇帖子: sap 打油诗 下篇帖子: Create Popup in SAP FPM
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表