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'
页:
[1]