2024年4月22日发(作者：迅雷看看电脑版下载)

本文由我司收集整编，推荐下载，如有疑问，请与我司联系

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

2014/05/24 0 pre name= code > 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, TABalance = :22,

TAInterestBalance = :23, TATimes = :24, LcaTimes = :25, ExtendTimes = :26,

AdvanceFlag = :27, PayBackAccount = :28, PayInterestAccount = :29, BailAccount = :30,

PutOutAccount = :31, OperateOrgID = :32, MfOrgID = :33, UpdateDate = :34, Classify4

= :35, ReturnType = :36, BailPercent = :37, PaymentType = :38, TermsFreq = :39,

BusinessStatus = :40, OperateUserID = :41, OverdueDate = :42, BillType = :43, RateFloat

= :44, RateFloatType = :45, AdjustRateType = :46, THIRDPARTYZIP2 = :47, FinishType

= :48 WHERE SerialNo = :49出现了大量的SQL*Net more data from client p1 p2124-

5?? -14 01.14.34.059 1571SQL*Net more data from client00-100224-5?? -

14 01.14.33.058 1571SQL*Net more data from client00-100324-5?? -14

01.14.32.058 361enq: WF - contention000-100424-5?? -14 01.14.32.058

1571SQL*Net more data from client00-100524-5?? -14 01.14.31.057

1571SQL*Net more data from client00-100624-5?? -14 01.14.30.056

1571SQL*Net more data from client00-100724-5?? -14 01.14.29.056

1571SQL*Net more data from client00-100824-5?? -14 01.14.28.055 361db

file sequential read216430710-100924-5?? -14 01.14.28.055 1571SQL*Net more data

from client100-1001024-5?? -14 01.14.27.055 1571SQL*Net more data

from client00-1001124-5?? -14 01.14.26.054 1571SQL*Net more data from

client00-1001224-5?? -14 01.14.25.049 1571SQL*Net more data from

client00-1001324-5?? -14 01.14.24.049 1571SQL*Net more data from