奇葩的SQL*Net more data from client等待,导致批处理巨慢

最新推荐文章于 2020-07-01 09:48:23 发布

scan724

最新推荐文章于 2020-07-01 09:48:23 发布

阅读量4k

点赞数

CC 4.0 BY-SA版权

分类专栏： OWI

本文链接：https://blog.youkuaiyun.com/zhaoyangjian724/article/details/26806967

OWI 专栏收录该内容

87 篇文章 ¥39.90 ¥99.00

订阅专栏

一篇关于SQL*Net等待事件导致批处理速度显著减慢的分析，揭示了近13分钟的等待时间，占CPU时间的84%，平均等待时间为177毫秒。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<pre name="code" class="sql"><pre name="code" class="sql">UPDATE Business_Duebill
   SET RelativeSerialNo1 = :1,
       RelativeSerialNo2 = :2,
       CustomerID        = :3,
       BusinessType      = :4,
       MFCustomerID      = :5,
       CustomerName      = :6,
       SubjectNo          = :7,
       BusinessSum        = :8,
       BusinessCurrency   = :9,
       ActualBusinessRate = :10,
       Balance            = :11,
       NormalBalance      = :12,
       OverdueBalance     = :13,
       DullBalance      = :14,
       BadBalance       = :15,
       InterestBalance1 = :16,
       InterestBalance2 = :17,
       FineBalance1     = :18,
       FineBalance2     = :19,
       ActualMaturity   = :20,
       FinishDate        = :21,
       TABa

了解本专栏