升级到Oracle 12.2后,SAP Query非常慢

2020-08-27 16:12发布

点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)我们最近从12.1升级到12.2...

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


我们最近从12.1升级到12.2,并注意到查询变得非常缓慢。 这是性病。 尝试检索idocs的查询(SAP程序)在过去10分钟内发生了更改。

瞬时查询现在需要6分钟以上的时间。 我看到访问路径以UPDDAT <今天的日期开头,这基本上终止了查询。 好奇是否有人曾经遇到过这个问题?

系统:PRD
 SQL_ID fjb1snm8p9pdy,子编号1
 -------------------------------------
 选择" MANDT"," DOCNUM"," DIRECT"," RCVPOR"," RCVPRT"," RCVPRN"," RCVPFC"," RC"
 VSAD"," SNDPOR"," SNDPRT"," SNDPRN"," SNDPFC"," MESTYP"," IDOCTP"," MESCOD"," ME
 SFCT","状态"," CREDAT"," CRETIM"," UPDDAT"," UPDTIM",来自" EDIDC"
 " MANDT" =:A0 AND(" UPDDAT" =:A1 AND" UPDTIM">:A2或" UPDDAT">:A3)和
 (" UPDDAT" <:A4或" UPDDAT" =:A5和" UPDTIM" <=:A6)
 " EDIDC"。" UPDDAT"," EDIDC"。" UPDTIM" DESC
 计划哈希值:228809918
 --------------------------------------------------  --------------------------------------------------  -------
 |  ID | 操作| 姓名| 行| 字节| TempSpc | 费用(%CPU)| 时间|
 --------------------------------------------------  --------------------------------------------------  -------
 |  0 | 选择声明|  |  |  |  |  2497(100)|  |
 |  1 | 排序方式|  |  30007 |  8820K |  10M |  2496(1)|  00:00:01 |
 |  2 | 查看|  VW_ORE_9301D7A9 |  30007 |  8820K |  |  807(1)|  00:00:01 |
 |  3 | 联合所有|  |  |  |  |  |  |
 |  4 | 按索引行访问表|  EDIDC |  29916 |  4236K |  |  802(0)|  00:00:01 |
 | * 5 | 索引范围扫描|  EDIDC〜2 |  5385 |  |  |  402(0)|  00:00:01 |
 | * 6 | 过滤器|  |  |  |  |  |  |
 |  7 | 按索引行访问表|  EDIDC |  87 |  12615 |  |  2(0)|  00:00:01 |
 | * 8 | 索引范围扫描|  EDIDC〜2 |  16 |  |  |  1(0)|  00:00:01 |
 | * 9 | 过滤器|  |  |  |  |  |  |
 |  10 | 按索引行访问表|  EDIDC |  4 |  580 |  |  2(0)|  00:00:01 |
 | * 11 | 索引范围扫描|  EDIDC〜2 |  8 |  |  |  1(0)|  00:00:01 |
 --------------------------------------------------  --------------------------------------------------  -------
 谓词信息(由操作ID标识):
 --------------------------------------------------  --


    5-访问(" MANDT" =:A0和" UPDDAT" <:A4)
        filter(("" UPDDAT">:A3 OR(" UPDDAT" =:A1 AND" UPDTIM">:A2)))
    6-过滤器(:A3 <:A5)
    8-访问(" MANDT" =:A0 AND" UPDDAT" =:A5 AND" UPDTIM" <=:A6)
        过滤器(LNNVL(" UPDDAT" <:A4))
    9-过滤器((:A6>:A2 AND:A5 =:A1))
   11-访问(" MANDT" =:A0 AND" UPDDAT" =:A1 AND" UPDTIM">:A2 AND" UPDTIM" <=:A6)
        过滤器((LNNVL(" UPDDAT" <:A4)AND LNNVL(" UPDDAT">:A3)))