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) 编辑 收藏 举报