ITPub博客

首页 > 数据库 > Oracle > Oracle----8i数据库调优

Oracle----8i数据库调优

原创 Oracle 作者:hrora 时间:2011-07-21 10:12:03 0 删除 编辑

ERPDB1#oslevel
4.3.3.0

ERPDB1#lsps -a
Page Space Physical Volume Volume Group Size %Used Active Auto Type
paging02 hdisk85 swapvg 17344MB 26 yes yes lv
paging01 hdisk84 swapvg 17344MB 26 yes yes lv
hd6 hdisk2 rootvg 17344MB 26 yes yes lv
paging00 hdisk3 swapvg 17280MB 26 yes yes lv


ERPDB1#/usr/samples/kernel/vmtune -a
nb_mem_pools = 2
nb_frs_per_memp = 2
total_frame_sets = 4
vmm_page_color_on = 0
memory frames = 8388569
maxpin = 6710856
minperm = 1677508
maxperm = 6710032
maxclient = 6710032
numperm = 3603294
numclient = 18
numcompress = 0
maxpin % = 80.0
minperm % = 20.0
maxperm % = 80.0
maxclient % = 80.0
numperm % = 43.0
numclient % = 0.0
numcompress % = 0.0
minpgahead = 2
maxpgahead = 8
minfree = 240
maxfree = 256
pd_npages = 524288
maxrandwrt = 0
numclust = 1
npswarn = 554496
npskill = 138624
numfsbufs = 93
hd_pbuf_cnt = 736
lvm_bufcnt = 9
lrubucket = 131072
defps = 1
sync_release_ilock = 0
pta_balance_thresh = 50.0
nokilluid = 0
v_pinshm = 0
strict_maxperm = 0
lgpg_regions = 0
lgpg_size = 0
hd_pendqblked = 112
psbufwaitcnt = 349523
fsbufwaitcnt = 1351459
rfsbufwaitcnt = 0

ERPDB1#lslpp -l|grep sdd
devices.sdd.43.rte 1.6.0.2 COMMITTED IBM Subsystem Device Driver
devices.sdd.43.rte 1.6.0.2 COMMITTED IBM Subsystem Device Driver

ERPDB1#lsattr -El aio0
minservers 1 MINIMUM number of servers True
maxservers 40 MAXIMUM number of servers True
maxreqs 4096 Maximum number of REQUESTS True
kprocprio 39 Server PRIORITY True
autoconfig available STATE to be configured at system restart True
fastpath enable State of fast path True

ERPDB1#lsattr -El sys0|grep pout
maxpout 33 HIGH water mark for pending write I/Os per file True
minpout 24 LOW water mark for pending write I/Os per file True

对如下参数进行调整:

minperm % = 20.0 ---> 5.0
maxperm % = 80.0 ---> 15.0
maxclient % = 80.0 ---> 15.0


minfree = 240 ---> 720
maxfree = 256 ---> 768

AIO相关参数修改:
MAXIMUM number of servers 40 ---> 200
Maximum number of REQUESTS 4096 ---> 16384
ERPDB1#lsattr -El sys0|grep pout
maxpout 33 HIGH water mark for pending write I/Os per file True ---->8193
minpout 24 LOW water mark for pending write I/Os per file True ---->4096

[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26078027/viewspace-1052830/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    31
  • 访问量
    66071