oracle590,IBM590+DS8100+SAP 有超高的I/O Wait

有可能的话，使劲的加大db_cache_size。shared pool size 你减一半应该没有问题

下面这些语句都要调优，基本上每个查询都有几十万的物理读，你的io肯定很严重。

SQL ordered by Reads for DB: CFQ  Instance: CFQ  Snaps: 243 -246

-> End Disk Reads Threshold:      1000

CPU      Elapsd

Physical Reads  Executions  Reads per Exec %Total Time (s)  Time (s) Hash Value

--------------- ------------ -------------- ------ -------- --------- ----------

438,175            1      438,175.0    1.3    19.22    180.16 2604293311

Module: ZMMRT0123

SELECT T_00 . "WERKS" , T_01 . "LIFNR" , T_01 . "EKGRP" , T_00 .

"GJAHR" , T_00 . "MATNR" , T_00 . "BELNR" , T_00 . "BUZEI" , T_

00 . "EBELN" , T_00 . "EBELP" , T_00 . "BWART" , T_00 . "LFBNR"

, T_00 . "LFPOS" , T_00 . "XBLNR" , T_00 . "BUDAT" , T_00 . "MEN

GE" , T_00 . "WRBTR" , T_00 . "WAERS" , T_00 . "DMBTR" , T_00 .

396,068            1      396,068.0    1.1    41.61   1057.87 1813408425

Module: ZIEIP0011

SELECT T_01 . "MATNR" , T_01 . "WERKS" , T_01 . "BWART" , T_01 .

"LGORT" , T_01 . "BUKRS" , T_01 . "MEINS" , T_01 . "MENGE" , T_

01 . "SHKZG" , T_02 . "MTART" , T_00 . "MBLNR" , T_00 . "MJAHR"

, T_00 . "BUDAT" , T_01 . "CHARG" FROM "MKPF" T_00 , "MSEG" T_01

, "MARA" T_02 WHERE ( T_01 . "MANDT" = :A0 AND T_00 . "MBLNR" =

334,527            1      334,527.0    1.0    35.82   1335.29 2394656573

Module: RM07DOCS

SELECT T_01 . "ANLN1" , T_01 . "ANLN2" , T_01 . "APLZL" , T_01 .

"AUFNR" , T_01 . "AUFPL" , T_00 . "BKTXT" , T_00 . "BLDAT" , T_

01 . "BPMNG" , T_01 . "BPRME" , T_01 . "BSTME" , T_01 . "BSTMG"

, T_00 . "BUDAT" , T_01 . "BUKRS" , T_01 . "BWART" , T_01 . "BWT

AR" , T_01 . "CHARG" , T_00 . "CPUDT" , T_00 . "CPUTM" , T_01 .

325,014        3,155          103.0    0.9    46.44   1830.80   26113033

Module: SAPLM61X

SELECT * FROM "MDRS" WHERE "MANDT" = :A0 AND "MATNR" = :A1 AND "

WERKS" = :A2 AND "XLOEK" = :A3 AND "KZEAR" = :A4

241,066            7       34,438.0    0.7    11.78    637.58 2477481268

Module: SAPMF05B

SELECT * FROM "BSIS" WHERE "MANDT" = :A0 AND "HKONT" = :A1 AND "

BUKRS" = :A2 ORDER BY "MANDT" , "BUKRS" , "HKONT" , "AUGDT" , "A

UGBL" , "ZUONR" , "GJAHR" , "BELNR" , "BUZEI"

188,873            2       94,436.5    0.5    15.18     16.17  658428380

Module: ZSDRS0002

SELECT T_00 . "XBLNR" , T_01 . "MATNR" , T_01 . "MENGE" , T_01 .

"MEINS" , T_01 . "WERKS" , T_01 . "LGORT" , T_01 . "MBLNR" , T_

01 . "MJAHR" , T_01 . "ZEILE" , T_01 . "SGTXT" , T_01 . "SHKZG"

, T_01 . "SMBLN" , T_01 . "SJAHR" , T_01 . "SMBLP" FROM "MKPF" T

_00 , "MSEG" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MBLNR

117,503            1      117,503.0    0.3     6.30    189.89 3931865073

Module: ZRLE_DELNOTE_DR

SELECT /*+ FIRST_ROWS  */ "MATNR" , "MTART" FROM "LIPS" WHERE "M

ANDT" = :A0 AND "MATNR" = :A1 AND ROWNUM <= :A2

117,455       16,016            7.3    0.3     9.41    425.23 3551357359

Module: SAPLBSVA

SELECT * FROM "JEST" WHERE "MANDT" = :A0 AND "OBJNR" IN ( :A1 ,

:A2 , :A3 , :A4 , :A5 )

[本帖最后由 WESTLIFE_XU 于 2007-12-26 10:00 编辑]