From 37080f5d0add35dc528212ece83adff1db6c50ee Mon Sep 17 00:00:00 2001
From: wzp <2880584989@qq.com>
Date: 星期四, 16 九月 2021 15:54:27 +0800
Subject: [PATCH] 更新

---
 web/web/logs/logx.txt |    8 ++++++++
 1 files changed, 8 insertions(+), 0 deletions(-)

diff --git a/web/web/logs/logx.txt b/web/web/logs/logx.txt
index eaf8683..b6827c4 100644
--- a/web/web/logs/logx.txt
+++ b/web/web/logs/logx.txt
@@ -535,3 +535,11 @@
 Process ID: 7904
 Session ID: 6 Serial number: 11866
 
+#60  2021-09-03 18:15:41,682 Common.dll OracleHelper.ExecuteReader              SQL=select A.*,NVL(b.OP_OUT_COUNT,0) OP_OUT_COUNT,NVL(B.OP_SUCCESS_COUNT,0) OP_SUCCESS_COUNT,NVL(b.OP_FAILED_COUNT,0) OP_FAILED_COUNT FROM GW_OP A LEFT JOIN
+                    (select OP_ID,NVL(SUM(OP_FEE_COUNT),0) OP_OUT_COUNT,
+	                    NVL(SUM(CASE WHEN STATUS=4 THEN OP_FEE_COUNT ELSE 0 END),0) OP_SUCCESS_COUNT,
+	                    NVL(SUM(CASE WHEN STATUS=5 THEN OP_FEE_COUNT ELSE 0 END),0) OP_FAILED_COUNT
+                    from LG_SM_20210903 where OP_SUBMIT_TIME > SYSDATE - 5.0/1440 GROUP BY OP_ID) b ON A.OP_ID = b.OP_ID WHERE a.OP_STATUS=1 ORDER BY a.OP_ID ASC Message=ORA-03113: end-of-file on communication channel
+Process ID: 15796
+Session ID: 204 Serial number: 5465
+

--
Gitblit v1.9.1