[ABI 5.2] 汇总户填报机构配置表未更新至汇总页面中

图1是分析表的计算结果吗？可以后台看下分析表计算详情的sql，核对查看是什么原因。

图1是汇总表的计算结果，分析表详情如下

可以复制一个出来，删除计算正确的，只保留没有数据的表元，计算后查看详细信息。

这俩个表达式中的表名不一致有影响吗

填报部门与其他字段的表达式表名

2021-06-27 02:25:06.325 开始计算报表：LVBB_HZ（内存情况：FREE=315.8M TOTAL=754M MAX=3.5G）
2021-06-27 02:25:06.342 引用的主题表： 报表填报机构配置表, 报表上报情况说明
2021-06-27 02:25:06.342 查询的数据级次范围：汇总户|办公室|计划财务部|业务综合部|风险管理部|金融市场部|业务一部|业务二部|业务三部|业务四部|业务五部|业务六部|业务七部|船舶业务部|厂商业务部|新能源业务部|人力资源部|航空业务部|系统数据。
================GRID1================
2021-06-27 02:25:06.342 在并行计算线程池中，开始计算表格GRID1的第1个分析区（0.2.12.39）！
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时10毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C3 as C3,a.K3 as K3,b.D3 as D3,b.E3 as E3,b.F3 as F3,b.G3 as G3,b.H3 as H3,b.I3 as I3,a.L3 as L3,a.mc_C30 as mc_C30,b.mc_E31 as mc_E31,b.mc_F32 as mc_F32,b.mc_G33 as mc_G33,b.mc_H34 as mc_H34
from (
select a.USERID_ as C3,a.TABLEID_ as K3,a.USERID_||a.TABLEID_ as L3,b.NAME as mc_C30
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_KHXX_GRKHXX'))) a
,(
select MAX(a.LOGINID_) as D3,MAX(a.SAVEFLAG_) as E3,MAX(a.REPORTFLAG_) as F3,MAX(a.AUDITFLAG_) as G3,MAX(a.LOCKFLAG_) as H3,MAX(a.LOCKTIME_) as I3,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E31,max(d.NAME) as mc_F32,max(c.NAME) as mc_G33,max(b.NAME) as mc_H34
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L3) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：14毫秒（开始时间：2021-06-27 02:25:06.492；结束时间：2021-06-27 02:25:06.506）；其中生成SQL耗时10毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时6毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C4 as C4,a.K4 as K4,b.D4 as D4,b.E4 as E4,b.F4 as F4,b.G4 as G4,b.H4 as H4,b.I4 as I4,a.L4 as L4,a.mc_C40 as mc_C40,b.mc_E41 as mc_E41,b.mc_F42 as mc_F42,b.mc_G43 as mc_G43,b.mc_H44 as mc_H44
from (
select a.USERID_ as C4,a.TABLEID_ as K4,a.USERID_||a.TABLEID_ as L4,b.NAME as mc_C40
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_KHXX_DGKHXX'))) a
,(
select MAX(a.LOGINID_) as D4,MAX(a.SAVEFLAG_) as E4,MAX(a.REPORTFLAG_) as F4,MAX(a.AUDITFLAG_) as G4,MAX(a.LOCKFLAG_) as H4,MAX(a.LOCKTIME_) as I4,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E41,max(d.NAME) as mc_F42,max(c.NAME) as mc_G43,max(b.NAME) as mc_H44
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L4) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：10毫秒（开始时间：2021-06-27 02:25:06.507；结束时间：2021-06-27 02:25:06.517）；其中生成SQL耗时6毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时6毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C5 as C5,a.K5 as K5,b.D5 as D5,b.E5 as E5,b.F5 as F5,b.G5 as G5,b.H5 as H5,b.I5 as I5,a.L5 as L5,a.mc_C50 as mc_C50,b.mc_E51 as mc_E51,b.mc_F52 as mc_F52,b.mc_G53 as mc_G53,b.mc_H54 as mc_H54
from (
select a.USERID_ as C5,a.TABLEID_ as K5,a.USERID_||a.TABLEID_ as L5,b.NAME as mc_C50
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_JGXX_JGFRXX'))) a
,(
select MAX(a.LOGINID_) as D5,MAX(a.SAVEFLAG_) as E5,MAX(a.REPORTFLAG_) as F5,MAX(a.AUDITFLAG_) as G5,MAX(a.LOCKFLAG_) as H5,MAX(a.LOCKTIME_) as I5,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E51,max(d.NAME) as mc_F52,max(c.NAME) as mc_G53,max(b.NAME) as mc_H54
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L5) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：10毫秒（开始时间：2021-06-27 02:25:06.517；结束时间：2021-06-27 02:25:06.527）；其中生成SQL耗时6毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C6 as C6,a.K6 as K6,b.D6 as D6,b.E6 as E6,b.F6 as F6,b.G6 as G6,b.H6 as H6,b.I6 as I6,a.L6 as L6,a.mc_C60 as mc_C60,b.mc_E61 as mc_E61,b.mc_F62 as mc_F62,b.mc_G63 as mc_G63,b.mc_H64 as mc_H64
from (
select a.USERID_ as C6,a.TABLEID_ as K6,a.USERID_||a.TABLEID_ as L6,b.NAME as mc_C60
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_JGXX_JGFZXX'))) a
,(
select MAX(a.LOGINID_) as D6,MAX(a.SAVEFLAG_) as E6,MAX(a.REPORTFLAG_) as F6,MAX(a.AUDITFLAG_) as G6,MAX(a.LOCKFLAG_) as H6,MAX(a.LOCKTIME_) as I6,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E61,max(d.NAME) as mc_F62,max(c.NAME) as mc_G63,max(b.NAME) as mc_H64
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L6) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.527；结束时间：2021-06-27 02:25:06.538）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时9毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C7 as C7,a.K7 as K7,b.D7 as D7,b.E7 as E7,b.F7 as F7,b.G7 as G7,b.H7 as H7,b.I7 as I7,a.L7 as L7,a.mc_C70 as mc_C70,b.mc_E71 as mc_E71,b.mc_F72 as mc_F72,b.mc_G73 as mc_G73,b.mc_H74 as mc_H74
from (
select a.USERID_ as C7,a.TABLEID_ as K7,a.USERID_||a.TABLEID_ as L7,b.NAME as mc_C70
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_GRDKJC'))) a
,(
select MAX(a.LOGINID_) as D7,MAX(a.SAVEFLAG_) as E7,MAX(a.REPORTFLAG_) as F7,MAX(a.AUDITFLAG_) as G7,MAX(a.LOCKFLAG_) as H7,MAX(a.LOCKTIME_) as I7,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E71,max(d.NAME) as mc_F72,max(c.NAME) as mc_G73,max(b.NAME) as mc_H74
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L7) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：13毫秒（开始时间：2021-06-27 02:25:06.539；结束时间：2021-06-27 02:25:06.552）；其中生成SQL耗时9毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时6毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C8 as C8,a.K8 as K8,b.D8 as D8,b.E8 as E8,b.F8 as F8,b.G8 as G8,b.H8 as H8,b.I8 as I8,a.L8 as L8,a.mc_C80 as mc_C80,b.mc_E81 as mc_E81,b.mc_F82 as mc_F82,b.mc_G83 as mc_G83,b.mc_H84 as mc_H84
from (
select a.USERID_ as C8,a.TABLEID_ as K8,a.USERID_||a.TABLEID_ as L8,b.NAME as mc_C80
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_GRDKYE'))) a
,(
select MAX(a.LOGINID_) as D8,MAX(a.SAVEFLAG_) as E8,MAX(a.REPORTFLAG_) as F8,MAX(a.AUDITFLAG_) as G8,MAX(a.LOCKFLAG_) as H8,MAX(a.LOCKTIME_) as I8,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E81,max(d.NAME) as mc_F82,max(c.NAME) as mc_G83,max(b.NAME) as mc_H84
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L8) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：9毫秒（开始时间：2021-06-27 02:25:06.552；结束时间：2021-06-27 02:25:06.561）；其中生成SQL耗时6毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时5毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C9 as C9,a.K9 as K9,b.D9 as D9,b.E9 as E9,b.F9 as F9,b.G9 as G9,b.H9 as H9,b.I9 as I9,a.L9 as L9,a.mc_C90 as mc_C90,b.mc_E91 as mc_E91,b.mc_F92 as mc_F92,b.mc_G93 as mc_G93,b.mc_H94 as mc_H94
from (
select a.USERID_ as C9,a.TABLEID_ as K9,a.USERID_||a.TABLEID_ as L9,b.NAME as mc_C90
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_GRDKFK'))) a
,(
select MAX(a.LOGINID_) as D9,MAX(a.SAVEFLAG_) as E9,MAX(a.REPORTFLAG_) as F9,MAX(a.AUDITFLAG_) as G9,MAX(a.LOCKFLAG_) as H9,MAX(a.LOCKTIME_) as I9,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E91,max(d.NAME) as mc_F92,max(c.NAME) as mc_G93,max(b.NAME) as mc_H94
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L9) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：9毫秒（开始时间：2021-06-27 02:25:06.562；结束时间：2021-06-27 02:25:06.571）；其中生成SQL耗时5毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时5毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C10 as C10,a.K10 as K10,b.D10 as D10,b.E10 as E10,b.F10 as F10,b.G10 as G10,b.H10 as H10,b.I10 as I10,a.L10 as L10,a.mc_C100 as mc_C100,b.mc_E101 as mc_E101,b.mc_F102 as mc_F102,b.mc_G103 as mc_G103,b.mc_H104 as mc_H104
from (
select a.USERID_ as C10,a.TABLEID_ as K10,a.USERID_||a.TABLEID_ as L10,b.NAME as mc_C100
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_dmDKJC'))) a
,(
select MAX(a.LOGINID_) as D10,MAX(a.SAVEFLAG_) as E10,MAX(a.REPORTFLAG_) as F10,MAX(a.AUDITFLAG_) as G10,MAX(a.LOCKFLAG_) as H10,MAX(a.LOCKTIME_) as I10,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E101,max(d.NAME) as mc_F102,max(c.NAME) as mc_G103,max(b.NAME) as mc_H104
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L10) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：9毫秒（开始时间：2021-06-27 02:25:06.571；结束时间：2021-06-27 02:25:06.580）；其中生成SQL耗时5毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C11 as C11,a.K11 as K11,b.D11 as D11,b.E11 as E11,b.F11 as F11,b.G11 as G11,b.H11 as H11,b.I11 as I11,a.L11 as L11,a.mc_C110 as mc_C110,b.mc_E111 as mc_E111,b.mc_F112 as mc_F112,b.mc_G113 as mc_G113,b.mc_H114 as mc_H114
from (
select a.USERID_ as C11,a.TABLEID_ as K11,a.USERID_||a.TABLEID_ as L11,b.NAME as mc_C110
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_dmDKYE'))) a
,(
select MAX(a.LOGINID_) as D11,MAX(a.SAVEFLAG_) as E11,MAX(a.REPORTFLAG_) as F11,MAX(a.AUDITFLAG_) as G11,MAX(a.LOCKFLAG_) as H11,MAX(a.LOCKTIME_) as I11,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E111,max(d.NAME) as mc_F112,max(c.NAME) as mc_G113,max(b.NAME) as mc_H114
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L11) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.581；结束时间：2021-06-27 02:25:06.592）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：3毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C12 as C12,a.K12 as K12,b.D12 as D12,b.E12 as E12,b.F12 as F12,b.G12 as G12,b.H12 as H12,b.I12 as I12,a.L12 as L12,a.mc_C120 as mc_C120,b.mc_E121 as mc_E121,b.mc_F122 as mc_F122,b.mc_G123 as mc_G123,b.mc_H124 as mc_H124
from (
select a.USERID_ as C12,a.TABLEID_ as K12,a.USERID_||a.TABLEID_ as L12,b.NAME as mc_C120
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_dmDKFK'))) a
,(
select MAX(a.LOGINID_) as D12,MAX(a.SAVEFLAG_) as E12,MAX(a.REPORTFLAG_) as F12,MAX(a.AUDITFLAG_) as G12,MAX(a.LOCKFLAG_) as H12,MAX(a.LOCKTIME_) as I12,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E121,max(d.NAME) as mc_F122,max(c.NAME) as mc_G123,max(b.NAME) as mc_H124
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L12) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.594；结束时间：2021-06-27 02:25:06.605）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：3毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时5毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C13 as C13,a.K13 as K13,b.D13 as D13,b.E13 as E13,b.F13 as F13,b.G13 as G13,b.H13 as H13,b.I13 as I13,a.L13 as L13,a.mc_C130 as mc_C130,b.mc_E131 as mc_E131,b.mc_F132 as mc_F132,b.mc_G133 as mc_G133,b.mc_H134 as mc_H134
from (
select a.USERID_ as C13,a.TABLEID_ as K13,a.USERID_||a.TABLEID_ as L13,b.NAME as mc_C130
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_TZYWYE'))) a
,(
select MAX(a.LOGINID_) as D13,MAX(a.SAVEFLAG_) as E13,MAX(a.REPORTFLAG_) as F13,MAX(a.AUDITFLAG_) as G13,MAX(a.LOCKFLAG_) as H13,MAX(a.LOCKTIME_) as I13,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E131,max(d.NAME) as mc_F132,max(c.NAME) as mc_G133,max(b.NAME) as mc_H134
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L13) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：9毫秒（开始时间：2021-06-27 02:25:06.605；结束时间：2021-06-27 02:25:06.614）；其中生成SQL耗时5毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时6毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C14 as C14,a.K14 as K14,b.D14 as D14,b.E14 as E14,b.F14 as F14,b.G14 as G14,b.H14 as H14,b.I14 as I14,a.L14 as L14,a.mc_C140 as mc_C140,b.mc_E141 as mc_E141,b.mc_F142 as mc_F142,b.mc_G143 as mc_G143,b.mc_H144 as mc_H144
from (
select a.USERID_ as C14,a.TABLEID_ as K14,a.USERID_||a.TABLEID_ as L14,b.NAME as mc_C140
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_TZYWJY'))) a
,(
select MAX(a.LOGINID_) as D14,MAX(a.SAVEFLAG_) as E14,MAX(a.REPORTFLAG_) as F14,MAX(a.AUDITFLAG_) as G14,MAX(a.LOCKFLAG_) as H14,MAX(a.LOCKTIME_) as I14,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E141,max(d.NAME) as mc_F142,max(c.NAME) as mc_G143,max(b.NAME) as mc_H144
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L14) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：10毫秒（开始时间：2021-06-27 02:25:06.615；结束时间：2021-06-27 02:25:06.625）；其中生成SQL耗时6毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时5毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C15 as C15,a.K15 as K15,b.D15 as D15,b.E15 as E15,b.F15 as F15,b.G15 as G15,b.H15 as H15,b.I15 as I15,a.L15 as L15,a.mc_C150 as mc_C150,b.mc_E151 as mc_E151,b.mc_F152 as mc_F152,b.mc_G153 as mc_G153,b.mc_H154 as mc_H154
from (
select a.USERID_ as C15,a.TABLEID_ as K15,a.USERID_||a.TABLEID_ as L15,b.NAME as mc_C150
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_TZYWZD'))) a
,(
select MAX(a.LOGINID_) as D15,MAX(a.SAVEFLAG_) as E15,MAX(a.REPORTFLAG_) as F15,MAX(a.AUDITFLAG_) as G15,MAX(a.LOCKFLAG_) as H15,MAX(a.LOCKTIME_) as I15,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E151,max(d.NAME) as mc_F152,max(c.NAME) as mc_G153,max(b.NAME) as mc_H154
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L15) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：9毫秒（开始时间：2021-06-27 02:25:06.626；结束时间：2021-06-27 02:25:06.635）；其中生成SQL耗时5毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：3毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时6毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C16 as C16,a.K16 as K16,b.D16 as D16,b.E16 as E16,b.F16 as F16,b.G16 as G16,b.H16 as H16,b.I16 as I16,a.L16 as L16,a.mc_C160 as mc_C160,b.mc_E161 as mc_E161,b.mc_F162 as mc_F162,b.mc_G163 as mc_G163,b.mc_H164 as mc_H164
from (
select a.USERID_ as C16,a.TABLEID_ as K16,a.USERID_||a.TABLEID_ as L16,b.NAME as mc_C160
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_TZYWFQ'))) a
,(
select MAX(a.LOGINID_) as D16,MAX(a.SAVEFLAG_) as E16,MAX(a.REPORTFLAG_) as F16,MAX(a.AUDITFLAG_) as G16,MAX(a.LOCKFLAG_) as H16,MAX(a.LOCKTIME_) as I16,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E161,max(d.NAME) as mc_F162,max(c.NAME) as mc_G163,max(b.NAME) as mc_H164
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L16) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：10毫秒（开始时间：2021-06-27 02:25:06.635；结束时间：2021-06-27 02:25:06.645）；其中生成SQL耗时6毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C17 as C17,a.K17 as K17,b.D17 as D17,b.E17 as E17,b.F17 as F17,b.G17 as G17,b.H17 as H17,b.I17 as I17,a.L17 as L17,a.mc_C170 as mc_C170,b.mc_E171 as mc_E171,b.mc_F172 as mc_F172,b.mc_G173 as mc_G173,b.mc_H174 as mc_H174
from (
select a.USERID_ as C17,a.TABLEID_ as K17,a.USERID_||a.TABLEID_ as L17,b.NAME as mc_C170
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_WTDKJC'))) a
,(
select MAX(a.LOGINID_) as D17,MAX(a.SAVEFLAG_) as E17,MAX(a.REPORTFLAG_) as F17,MAX(a.AUDITFLAG_) as G17,MAX(a.LOCKFLAG_) as H17,MAX(a.LOCKTIME_) as I17,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E171,max(d.NAME) as mc_F172,max(c.NAME) as mc_G173,max(b.NAME) as mc_H174
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L17) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.646；结束时间：2021-06-27 02:25:06.657）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C18 as C18,a.K18 as K18,b.D18 as D18,b.E18 as E18,b.F18 as F18,b.G18 as G18,b.H18 as H18,b.I18 as I18,a.L18 as L18,a.mc_C180 as mc_C180,b.mc_E181 as mc_E181,b.mc_F182 as mc_F182,b.mc_G183 as mc_G183,b.mc_H184 as mc_H184
from (
select a.USERID_ as C18,a.TABLEID_ as K18,a.USERID_||a.TABLEID_ as L18,b.NAME as mc_C180
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_WTDKYE'))) a
,(
select MAX(a.LOGINID_) as D18,MAX(a.SAVEFLAG_) as E18,MAX(a.REPORTFLAG_) as F18,MAX(a.AUDITFLAG_) as G18,MAX(a.LOCKFLAG_) as H18,MAX(a.LOCKTIME_) as I18,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E181,max(d.NAME) as mc_F182,max(c.NAME) as mc_G183,max(b.NAME) as mc_H184
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L18) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.658；结束时间：2021-06-27 02:25:06.669）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C19 as C19,a.K19 as K19,b.D19 as D19,b.E19 as E19,b.F19 as F19,b.G19 as G19,b.H19 as H19,b.I19 as I19,a.L19 as L19,a.mc_C190 as mc_C190,b.mc_E191 as mc_E191,b.mc_F192 as mc_F192,b.mc_G193 as mc_G193,b.mc_H194 as mc_H194
from (
select a.USERID_ as C19,a.TABLEID_ as K19,a.USERID_||a.TABLEID_ as L19,b.NAME as mc_C190
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_DKYW_WTDKFK'))) a
,(
select MAX(a.LOGINID_) as D19,MAX(a.SAVEFLAG_) as E19,MAX(a.REPORTFLAG_) as F19,MAX(a.AUDITFLAG_) as G19,MAX(a.LOCKFLAG_) as H19,MAX(a.LOCKTIME_) as I19,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E191,max(d.NAME) as mc_F192,max(c.NAME) as mc_G193,max(b.NAME) as mc_H194
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L19) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.670；结束时间：2021-06-27 02:25:06.681）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C20 as C20,a.K20 as K20,b.D20 as D20,b.E20 as E20,b.F20 as F20,b.G20 as G20,b.H20 as H20,b.I20 as I20,a.L20 as L20,a.mc_C200 as mc_C200,b.mc_E201 as mc_E201,b.mc_F202 as mc_F202,b.mc_G203 as mc_G203,b.mc_H204 as mc_H204
from (
select a.USERID_ as C20,a.TABLEID_ as K20,a.USERID_||a.TABLEID_ as L20,b.NAME as mc_C200
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_CKYW_GRCKJC'))) a
,(
select MAX(a.LOGINID_) as D20,MAX(a.SAVEFLAG_) as E20,MAX(a.REPORTFLAG_) as F20,MAX(a.AUDITFLAG_) as G20,MAX(a.LOCKFLAG_) as H20,MAX(a.LOCKTIME_) as I20,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E201,max(d.NAME) as mc_F202,max(c.NAME) as mc_G203,max(b.NAME) as mc_H204
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L20) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.682；结束时间：2021-06-27 02:25:06.693）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：3毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C21 as C21,a.K21 as K21,b.D21 as D21,b.E21 as E21,b.F21 as F21,b.G21 as G21,b.H21 as H21,b.I21 as I21,a.L21 as L21,a.mc_C210 as mc_C210,b.mc_E211 as mc_E211,b.mc_F212 as mc_F212,b.mc_G213 as mc_G213,b.mc_H214 as mc_H214
from (
select a.USERID_ as C21,a.TABLEID_ as K21,a.USERID_||a.TABLEID_ as L21,b.NAME as mc_C210
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_CKYW_GRCKYE'))) a
,(
select MAX(a.LOGINID_) as D21,MAX(a.SAVEFLAG_) as E21,MAX(a.REPORTFLAG_) as F21,MAX(a.AUDITFLAG_) as G21,MAX(a.LOCKFLAG_) as H21,MAX(a.LOCKTIME_) as I21,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E211,max(d.NAME) as mc_F212,max(c.NAME) as mc_G213,max(b.NAME) as mc_H214
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L21) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：12毫秒（开始时间：2021-06-27 02:25:06.693；结束时间：2021-06-27 02:25:06.705）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：3毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C22 as C22,a.K22 as K22,b.D22 as D22,b.E22 as E22,b.F22 as F22,b.G22 as G22,b.H22 as H22,b.I22 as I22,a.L22 as L22,a.mc_C220 as mc_C220,b.mc_E221 as mc_E221,b.mc_F222 as mc_F222,b.mc_G223 as mc_G223,b.mc_H224 as mc_H224
from (
select a.USERID_ as C22,a.TABLEID_ as K22,a.USERID_||a.TABLEID_ as L22,b.NAME as mc_C220
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_CKYW_GRCKFS'))) a
,(
select MAX(a.LOGINID_) as D22,MAX(a.SAVEFLAG_) as E22,MAX(a.REPORTFLAG_) as F22,MAX(a.AUDITFLAG_) as G22,MAX(a.LOCKFLAG_) as H22,MAX(a.LOCKTIME_) as I22,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E221,max(d.NAME) as mc_F222,max(c.NAME) as mc_G223,max(b.NAME) as mc_H224
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L22) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.706；结束时间：2021-06-27 02:25:06.717）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时6毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C23 as C23,a.K23 as K23,b.D23 as D23,b.E23 as E23,b.F23 as F23,b.G23 as G23,b.H23 as H23,b.I23 as I23,a.L23 as L23,a.mc_C230 as mc_C230,b.mc_E231 as mc_E231,b.mc_F232 as mc_F232,b.mc_G233 as mc_G233,b.mc_H234 as mc_H234
from (
select a.USERID_ as C23,a.TABLEID_ as K23,a.USERID_||a.TABLEID_ as L23,b.NAME as mc_C230
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_CKYW_dmCKJC'))) a
,(
select MAX(a.LOGINID_) as D23,MAX(a.SAVEFLAG_) as E23,MAX(a.REPORTFLAG_) as F23,MAX(a.AUDITFLAG_) as G23,MAX(a.LOCKFLAG_) as H23,MAX(a.LOCKTIME_) as I23,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E231,max(d.NAME) as mc_F232,max(c.NAME) as mc_G233,max(b.NAME) as mc_H234
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L23) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：10毫秒（开始时间：2021-06-27 02:25:06.717；结束时间：2021-06-27 02:25:06.727）；其中生成SQL耗时6毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：3毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C24 as C24,a.K24 as K24,b.D24 as D24,b.E24 as E24,b.F24 as F24,b.G24 as G24,b.H24 as H24,b.I24 as I24,a.L24 as L24,a.mc_C240 as mc_C240,b.mc_E241 as mc_E241,b.mc_F242 as mc_F242,b.mc_G243 as mc_G243,b.mc_H244 as mc_H244
from (
select a.USERID_ as C24,a.TABLEID_ as K24,a.USERID_||a.TABLEID_ as L24,b.NAME as mc_C240
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_CKYW_dmCKYE'))) a
,(
select MAX(a.LOGINID_) as D24,MAX(a.SAVEFLAG_) as E24,MAX(a.REPORTFLAG_) as F24,MAX(a.AUDITFLAG_) as G24,MAX(a.LOCKFLAG_) as H24,MAX(a.LOCKTIME_) as I24,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E241,max(d.NAME) as mc_F242,max(c.NAME) as mc_G243,max(b.NAME) as mc_H244
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L24) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.727；结束时间：2021-06-27 02:25:06.738）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C25 as C25,a.K25 as K25,b.D25 as D25,b.E25 as E25,b.F25 as F25,b.G25 as G25,b.H25 as H25,b.I25 as I25,a.L25 as L25,a.mc_C250 as mc_C250,b.mc_E251 as mc_E251,b.mc_F252 as mc_F252,b.mc_G253 as mc_G253,b.mc_H254 as mc_H254
from (
select a.USERID_ as C25,a.TABLEID_ as K25,a.USERID_||a.TABLEID_ as L25,b.NAME as mc_C250
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_CKYW_dmCKFS'))) a
,(
select MAX(a.LOGINID_) as D25,MAX(a.SAVEFLAG_) as E25,MAX(a.REPORTFLAG_) as F25,MAX(a.AUDITFLAG_) as G25,MAX(a.LOCKFLAG_) as H25,MAX(a.LOCKTIME_) as I25,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E251,max(d.NAME) as mc_F252,max(c.NAME) as mc_G253,max(b.NAME) as mc_H254
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L25) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.739；结束时间：2021-06-27 02:25:06.750）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C26 as C26,a.K26 as K26,b.D26 as D26,b.E26 as E26,b.F26 as F26,b.G26 as G26,b.H26 as H26,b.I26 as I26,a.L26 as L26,a.mc_C260 as mc_C260,b.mc_E261 as mc_E261,b.mc_F262 as mc_F262,b.mc_G263 as mc_G263,b.mc_H264 as mc_H264
from (
select a.USERID_ as C26,a.TABLEID_ as K26,a.USERID_||a.TABLEID_ as L26,b.NAME as mc_C260
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_TYYW_TYCKJC'))) a
,(
select MAX(a.LOGINID_) as D26,MAX(a.SAVEFLAG_) as E26,MAX(a.REPORTFLAG_) as F26,MAX(a.AUDITFLAG_) as G26,MAX(a.LOCKFLAG_) as H26,MAX(a.LOCKTIME_) as I26,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E261,max(d.NAME) as mc_F262,max(c.NAME) as mc_G263,max(b.NAME) as mc_H264
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L26) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.751；结束时间：2021-06-27 02:25:06.762）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C27 as C27,a.K27 as K27,b.D27 as D27,b.E27 as E27,b.F27 as F27,b.G27 as G27,b.H27 as H27,b.I27 as I27,a.L27 as L27,a.mc_C270 as mc_C270,b.mc_E271 as mc_E271,b.mc_F272 as mc_F272,b.mc_G273 as mc_G273,b.mc_H274 as mc_H274
from (
select a.USERID_ as C27,a.TABLEID_ as K27,a.USERID_||a.TABLEID_ as L27,b.NAME as mc_C270
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_TYYW_TYCKYE'))) a
,(
select MAX(a.LOGINID_) as D27,MAX(a.SAVEFLAG_) as E27,MAX(a.REPORTFLAG_) as F27,MAX(a.AUDITFLAG_) as G27,MAX(a.LOCKFLAG_) as H27,MAX(a.LOCKTIME_) as I27,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E271,max(d.NAME) as mc_F272,max(c.NAME) as mc_G273,max(b.NAME) as mc_H274
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L27) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.763；结束时间：2021-06-27 02:25:06.774）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C28 as C28,a.K28 as K28,b.D28 as D28,b.E28 as E28,b.F28 as F28,b.G28 as G28,b.H28 as H28,b.I28 as I28,a.L28 as L28,a.mc_C280 as mc_C280,b.mc_E281 as mc_E281,b.mc_F282 as mc_F282,b.mc_G283 as mc_G283,b.mc_H284 as mc_H284
from (
select a.USERID_ as C28,a.TABLEID_ as K28,a.USERID_||a.TABLEID_ as L28,b.NAME as mc_C280
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_TYYW_TYCKFS'))) a
,(
select MAX(a.LOGINID_) as D28,MAX(a.SAVEFLAG_) as E28,MAX(a.REPORTFLAG_) as F28,MAX(a.AUDITFLAG_) as G28,MAX(a.LOCKFLAG_) as H28,MAX(a.LOCKTIME_) as I28,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E281,max(d.NAME) as mc_F282,max(c.NAME) as mc_G283,max(b.NAME) as mc_H284
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L28) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.775；结束时间：2021-06-27 02:25:06.786）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时5毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C29 as C29,a.K29 as K29,b.D29 as D29,b.E29 as E29,b.F29 as F29,b.G29 as G29,b.H29 as H29,b.I29 as I29,a.L29 as L29,a.mc_C290 as mc_C290,b.mc_E291 as mc_E291,b.mc_F292 as mc_F292,b.mc_G293 as mc_G293,b.mc_H294 as mc_H294
from (
select a.USERID_ as C29,a.TABLEID_ as K29,a.USERID_||a.TABLEID_ as L29,b.NAME as mc_C290
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_TYYW_TYJDJC'))) a
,(
select MAX(a.LOGINID_) as D29,MAX(a.SAVEFLAG_) as E29,MAX(a.REPORTFLAG_) as F29,MAX(a.AUDITFLAG_) as G29,MAX(a.LOCKFLAG_) as H29,MAX(a.LOCKTIME_) as I29,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E291,max(d.NAME) as mc_F292,max(c.NAME) as mc_G293,max(b.NAME) as mc_H294
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L29) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：9毫秒（开始时间：2021-06-27 02:25:06.786；结束时间：2021-06-27 02:25:06.795）；其中生成SQL耗时5毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C30 as C30,a.K30 as K30,b.D30 as D30,b.E30 as E30,b.F30 as F30,b.G30 as G30,b.H30 as H30,b.I30 as I30,a.L30 as L30,a.mc_C300 as mc_C300,b.mc_E301 as mc_E301,b.mc_F302 as mc_F302,b.mc_G303 as mc_G303,b.mc_H304 as mc_H304
from (
select a.USERID_ as C30,a.TABLEID_ as K30,a.USERID_||a.TABLEID_ as L30,b.NAME as mc_C300
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_TYYW_TYJDYE'))) a
,(
select MAX(a.LOGINID_) as D30,MAX(a.SAVEFLAG_) as E30,MAX(a.REPORTFLAG_) as F30,MAX(a.AUDITFLAG_) as G30,MAX(a.LOCKFLAG_) as H30,MAX(a.LOCKTIME_) as I30,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E301,max(d.NAME) as mc_F302,max(c.NAME) as mc_G303,max(b.NAME) as mc_H304
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L30) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.796；结束时间：2021-06-27 02:25:06.807）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：3毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时5毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C31 as C31,a.K31 as K31,b.D31 as D31,b.E31 as E31,b.F31 as F31,b.G31 as G31,b.H31 as H31,b.I31 as I31,a.L31 as L31,a.mc_C310 as mc_C310,b.mc_E311 as mc_E311,b.mc_F312 as mc_F312,b.mc_G313 as mc_G313,b.mc_H314 as mc_H314
from (
select a.USERID_ as C31,a.TABLEID_ as K31,a.USERID_||a.TABLEID_ as L31,b.NAME as mc_C310
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_TYYW_TYJDFS'))) a
,(
select MAX(a.LOGINID_) as D31,MAX(a.SAVEFLAG_) as E31,MAX(a.REPORTFLAG_) as F31,MAX(a.AUDITFLAG_) as G31,MAX(a.LOCKFLAG_) as H31,MAX(a.LOCKTIME_) as I31,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E311,max(d.NAME) as mc_F312,max(c.NAME) as mc_G313,max(b.NAME) as mc_H314
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L31) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：9毫秒（开始时间：2021-06-27 02:25:06.807；结束时间：2021-06-27 02:25:06.816）；其中生成SQL耗时5毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时6毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C32 as C32,a.K32 as K32,b.D32 as D32,b.E32 as E32,b.F32 as F32,b.G32 as G32,b.H32 as H32,b.I32 as I32,a.L32 as L32,a.mc_C320 as mc_C320,b.mc_E321 as mc_E321,b.mc_F322 as mc_F322,b.mc_G323 as mc_G323,b.mc_H324 as mc_H324
from (
select a.USERID_ as C32,a.TABLEID_ as K32,a.USERID_||a.TABLEID_ as L32,b.NAME as mc_C320
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_TYYW_MRFSJC'))) a
,(
select MAX(a.LOGINID_) as D32,MAX(a.SAVEFLAG_) as E32,MAX(a.REPORTFLAG_) as F32,MAX(a.AUDITFLAG_) as G32,MAX(a.LOCKFLAG_) as H32,MAX(a.LOCKTIME_) as I32,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E321,max(d.NAME) as mc_F322,max(c.NAME) as mc_G323,max(b.NAME) as mc_H324
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L32) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：10毫秒（开始时间：2021-06-27 02:25:06.818；结束时间：2021-06-27 02:25:06.828）；其中生成SQL耗时6毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C33 as C33,a.K33 as K33,b.D33 as D33,b.E33 as E33,b.F33 as F33,b.G33 as G33,b.H33 as H33,b.I33 as I33,a.L33 as L33,a.mc_C330 as mc_C330,b.mc_E331 as mc_E331,b.mc_F332 as mc_F332,b.mc_G333 as mc_G333,b.mc_H334 as mc_H334
from (
select a.USERID_ as C33,a.TABLEID_ as K33,a.USERID_||a.TABLEID_ as L33,b.NAME as mc_C330
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_TYYW_MRFSYE'))) a
,(
select MAX(a.LOGINID_) as D33,MAX(a.SAVEFLAG_) as E33,MAX(a.REPORTFLAG_) as F33,MAX(a.AUDITFLAG_) as G33,MAX(a.LOCKFLAG_) as H33,MAX(a.LOCKTIME_) as I33,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E331,max(d.NAME) as mc_F332,max(c.NAME) as mc_G333,max(b.NAME) as mc_H334
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L33) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.829；结束时间：2021-06-27 02:25:06.840）；其中生成SQL耗时7毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C34 as C34,a.K34 as K34,b.D34 as D34,b.E34 as E34,b.F34 as F34,b.G34 as G34,b.H34 as H34,b.I34 as I34,a.L34 as L34,a.mc_C340 as mc_C340,b.mc_E341 as mc_E341,b.mc_F342 as mc_F342,b.mc_G343 as mc_G343,b.mc_H344 as mc_H344
from (
select a.USERID_ as C34,a.TABLEID_ as K34,a.USERID_||a.TABLEID_ as L34,b.NAME as mc_C340
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_TYYW_MRFSFS'))) a
,(
select MAX(a.LOGINID_) as D34,MAX(a.SAVEFLAG_) as E34,MAX(a.REPORTFLAG_) as F34,MAX(a.AUDITFLAG_) as G34,MAX(a.LOCKFLAG_) as H34,MAX(a.LOCKTIME_) as I34,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E341,max(d.NAME) as mc_F342,max(c.NAME) as mc_G343,max(b.NAME) as mc_H344
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L34) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.841；结束时间：2021-06-27 02:25:06.852）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C35 as C35,a.K35 as K35,b.D35 as D35,b.E35 as E35,b.F35 as F35,b.G35 as G35,b.H35 as H35,b.I35 as I35,a.L35 as L35,a.mc_C350 as mc_C350,b.mc_E351 as mc_E351,b.mc_F352 as mc_F352,b.mc_G353 as mc_G353,b.mc_H354 as mc_H354
from (
select a.USERID_ as C35,a.TABLEID_ as K35,a.USERID_||a.TABLEID_ as L35,b.NAME as mc_C350
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_PJRZ_PJTXJC'))) a
,(
select MAX(a.LOGINID_) as D35,MAX(a.SAVEFLAG_) as E35,MAX(a.REPORTFLAG_) as F35,MAX(a.AUDITFLAG_) as G35,MAX(a.LOCKFLAG_) as H35,MAX(a.LOCKTIME_) as I35,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E351,max(d.NAME) as mc_F352,max(c.NAME) as mc_G353,max(b.NAME) as mc_H354
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L35) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.853；结束时间：2021-06-27 02:25:06.864）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C36 as C36,a.K36 as K36,b.D36 as D36,b.E36 as E36,b.F36 as F36,b.G36 as G36,b.H36 as H36,b.I36 as I36,a.L36 as L36,a.mc_C360 as mc_C360,b.mc_E361 as mc_E361,b.mc_F362 as mc_F362,b.mc_G363 as mc_G363,b.mc_H364 as mc_H364
from (
select a.USERID_ as C36,a.TABLEID_ as K36,a.USERID_||a.TABLEID_ as L36,b.NAME as mc_C360
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_PJRZ_PJTXYE'))) a
,(
select MAX(a.LOGINID_) as D36,MAX(a.SAVEFLAG_) as E36,MAX(a.REPORTFLAG_) as F36,MAX(a.AUDITFLAG_) as G36,MAX(a.LOCKFLAG_) as H36,MAX(a.LOCKTIME_) as I36,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E361,max(d.NAME) as mc_F362,max(c.NAME) as mc_G363,max(b.NAME) as mc_H364
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L36) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.865；结束时间：2021-06-27 02:25:06.876）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：3毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时5毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C37 as C37,a.K37 as K37,b.D37 as D37,b.E37 as E37,b.F37 as F37,b.G37 as G37,b.H37 as H37,b.I37 as I37,a.L37 as L37,a.mc_C370 as mc_C370,b.mc_E371 as mc_E371,b.mc_F372 as mc_F372,b.mc_G373 as mc_G373,b.mc_H374 as mc_H374
from (
select a.USERID_ as C37,a.TABLEID_ as K37,a.USERID_||a.TABLEID_ as L37,b.NAME as mc_C370
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_PJRZ_PJTXFS'))) a
,(
select MAX(a.LOGINID_) as D37,MAX(a.SAVEFLAG_) as E37,MAX(a.REPORTFLAG_) as F37,MAX(a.AUDITFLAG_) as G37,MAX(a.LOCKFLAG_) as H37,MAX(a.LOCKTIME_) as I37,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E371,max(d.NAME) as mc_F372,max(c.NAME) as mc_G373,max(b.NAME) as mc_H374
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L37) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：9毫秒（开始时间：2021-06-27 02:25:06.876；结束时间：2021-06-27 02:25:06.885）；其中生成SQL耗时5毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时6毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C38 as C38,a.K38 as K38,b.D38 as D38,b.E38 as E38,b.F38 as F38,b.G38 as G38,b.H38 as H38,b.I38 as I38,a.L38 as L38,a.mc_C380 as mc_C380,b.mc_E381 as mc_E381,b.mc_F382 as mc_F382,b.mc_G383 as mc_G383,b.mc_H384 as mc_H384
from (
select a.USERID_ as C38,a.TABLEID_ as K38,a.USERID_||a.TABLEID_ as L38,b.NAME as mc_C380
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_FTPDJ_FTPDJB'))) a
,(
select MAX(a.LOGINID_) as D38,MAX(a.SAVEFLAG_) as E38,MAX(a.REPORTFLAG_) as F38,MAX(a.AUDITFLAG_) as G38,MAX(a.LOCKFLAG_) as H38,MAX(a.LOCKTIME_) as I38,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E381,max(d.NAME) as mc_F382,max(c.NAME) as mc_G383,max(b.NAME) as mc_H384
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L38) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：10毫秒（开始时间：2021-06-27 02:25:06.886；结束时间：2021-06-27 02:25:06.896）；其中生成SQL耗时6毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06 正在生成SQL...
2021-06-27 02:25:06 计算表格GRID1
2021-06-27 02:25:06 生成SQL耗时7毫秒
2021-06-27 02:25:06 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C39 as C39,a.K39 as K39,b.D39 as D39,b.E39 as E39,b.F39 as F39,b.G39 as G39,b.H39 as H39,b.I39 as I39,a.L39 as L39,a.mc_C390 as mc_C390,b.mc_E391 as mc_E391,b.mc_F392 as mc_F392,b.mc_G393 as mc_G393,b.mc_H394 as mc_H394
from (
select a.USERID_ as C39,a.TABLEID_ as K39,a.USERID_||a.TABLEID_ as L39,b.NAME as mc_C390
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND ((a.HZUSERID_ is null or a.HZUSERID_='')) AND (a.TABLEID_ = 'LVBB_LCXC_LCXCTJ'))) a
,(
select MAX(a.LOGINID_) as D39,MAX(a.SAVEFLAG_) as E39,MAX(a.REPORTFLAG_) as F39,MAX(a.AUDITFLAG_) as G39,MAX(a.LOCKFLAG_) as H39,MAX(a.LOCKTIME_) as I39,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E391,max(d.NAME) as mc_F392,max(c.NAME) as mc_G393,max(b.NAME) as mc_H394
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and ((a.BBQ_ is null or a.BBQ_=''))
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L39) )row_ where rownum <= 1000
2021-06-27 02:25:06 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 02:25:06.897；结束时间：2021-06-27 02:25:06.908）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 02:25:06.908 在并行计算线程池中，完成计算表格GRID1第1个分析区（0.2.12.39）！
================GRID1 END================
2021-06-27 02:25:06.914 执行查询耗时590毫秒。（内存情况：FREE=172.5M TOTAL=754M MAX=3.5G）
2021-06-27 02:25:06.951 构造结果表耗时37毫秒。
2021-06-27 02:25:06.951 计算“LVBB_HZ”耗时628毫秒。（内存情况：FREE=162.9M TOTAL=754M MAX=3.5G）

图中分析表没有设置浮动，直接计算不影响的。

分析表删减下，只保留计算没数据的表元再计算看看。保留表元太多，不方便找到没有数据表元的sql。

2021-06-27 04:10:50.018 开始计算报表：LVBB_HZ（内存情况：FREE=72M TOTAL=517M MAX=3.5G）
2021-06-27 04:10:50.020 引用的主题表： 报表填报机构配置表, 报表上报情况说明
2021-06-27 04:10:50.020 查询的数据级次范围：汇总户|办公室|计划财务部|业务综合部|风险管理部|金融市场部|业务一部|业务二部|业务三部|业务四部|业务五部|业务六部|业务七部|船舶业务部|厂商业务部|新能源业务部|人力资源部|航空业务部|系统数据。
================GRID1================
2021-06-27 04:10:50.020 在并行计算线程池中，开始计算表格GRID1的第1个分析区（0.2.12.5）！
2021-06-27 04:10:50 正在生成SQL...
2021-06-27 04:10:50 计算表格GRID1
2021-06-27 04:10:50 生成SQL耗时9毫秒
2021-06-27 04:10:50 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C3 as C3,a.K3 as K3,b.D3 as D3,b.E3 as E3,b.F3 as F3,b.G3 as G3,b.H3 as H3,b.I3 as I3,a.L3 as L3,a.mc_C30 as mc_C30,b.mc_E31 as mc_E31,b.mc_F32 as mc_F32,b.mc_G33 as mc_G33,b.mc_H34 as mc_H34
from (
select a.USERID_ as C3,a.TABLEID_ as K3,a.USERID_||a.TABLEID_ as L3,b.NAME as mc_C30
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND (a.HZUSERID_ = '000000') AND (a.TABLEID_ = 'LVBB_DKYW_dmDKJC'))) a
,(
select MAX(a.LOGINID_) as D3,MAX(a.SAVEFLAG_) as E3,MAX(a.REPORTFLAG_) as F3,MAX(a.AUDITFLAG_) as G3,MAX(a.LOCKFLAG_) as H3,MAX(a.LOCKTIME_) as I3,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E31,max(d.NAME) as mc_F32,max(c.NAME) as mc_G33,max(b.NAME) as mc_H34
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and (a.BBQ_ = '20210626')
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L3) )row_ where rownum <= 1000
2021-06-27 04:10:50 SQL执行完毕，查询出0条数据，耗时：13毫秒（开始时间：2021-06-27 04:10:50.032；结束时间：2021-06-27 04:10:50.045）；其中生成SQL耗时9毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 04:10:50 正在生成SQL...
2021-06-27 04:10:50 计算表格GRID1
2021-06-27 04:10:50 生成SQL耗时7毫秒
2021-06-27 04:10:50 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C4 as C4,a.K4 as K4,b.D4 as D4,b.E4 as E4,b.F4 as F4,b.G4 as G4,b.H4 as H4,b.I4 as I4,a.L4 as L4,a.mc_C40 as mc_C40,b.mc_E41 as mc_E41,b.mc_F42 as mc_F42,b.mc_G43 as mc_G43,b.mc_H44 as mc_H44
from (
select a.USERID_ as C4,a.TABLEID_ as K4,a.USERID_||a.TABLEID_ as L4,b.NAME as mc_C40
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND (a.HZUSERID_ = '000000') AND (a.TABLEID_ = 'LVBB_DKYW_dmDKYE'))) a
,(
select MAX(a.LOGINID_) as D4,MAX(a.SAVEFLAG_) as E4,MAX(a.REPORTFLAG_) as F4,MAX(a.AUDITFLAG_) as G4,MAX(a.LOCKFLAG_) as H4,MAX(a.LOCKTIME_) as I4,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E41,max(d.NAME) as mc_F42,max(c.NAME) as mc_G43,max(b.NAME) as mc_H44
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and (a.BBQ_ = '20210626')
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L4) )row_ where rownum <= 1000
2021-06-27 04:10:50 SQL执行完毕，查询出0条数据，耗时：11毫秒（开始时间：2021-06-27 04:10:50.046；结束时间：2021-06-27 04:10:50.057）；其中生成SQL耗时7毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：3毫秒；
2021-06-27 04:10:50 正在生成SQL...
2021-06-27 04:10:50 计算表格GRID1
2021-06-27 04:10:50 生成SQL耗时6毫秒
2021-06-27 04:10:50 当前连接池为【dm】，执行SQL:
select row_.*,rownum from ( select a.C5 as C5,a.K5 as K5,b.D5 as D5,b.E5 as E5,b.F5 as F5,b.G5 as G5,b.H5 as H5,b.I5 as I5,a.L5 as L5,a.mc_C50 as mc_C50,b.mc_E51 as mc_E51,b.mc_F52 as mc_F52,b.mc_G53 as mc_G53,b.mc_H54 as mc_H54
from (
select a.USERID_ as C5,a.TABLEID_ as K5,a.USERID_||a.TABLEID_ as L5,b.NAME as mc_C50
from I_RS_UL_TBJG a
,VIEW_EAST_DIM_BBH_JC b
where (A.USERID_=B.ID(+)) and ((a.TABLETYPE_ = 'LVBB') AND (a.HZUSERID_ = '000000') AND (a.TABLEID_ = 'LVBB_DKYW_dmDKFK'))) a
,(
select MAX(a.LOGINID_) as D5,MAX(a.SAVEFLAG_) as E5,MAX(a.REPORTFLAG_) as F5,MAX(a.AUDITFLAG_) as G5,MAX(a.LOCKFLAG_) as H5,MAX(a.LOCKTIME_) as I5,a.USERID_||a.TABLEID_ as dimLnk0,max(e.NAME) as mc_E51,max(d.NAME) as mc_F52,max(c.NAME) as mc_G53,max(b.NAME) as mc_H54
from I_RS_UL_XXB a
,I_DIM_XXBSDBZ b
,I_DIM_XXBSHBZ c
,I_DIM_XXBSBBZ d
,I_DIM_XXBBCBZ e
where (A.LOCKFLAG_=B.ID(+)) and (A.AUDITFLAG_=C.ID(+)) and (A.REPORTFLAG_=D.ID(+)) and (A.SAVEFLAG_=E.ID(+)) and (a.BBQ_ = '20210626')
group by a.USERID_||a.TABLEID_) b
where (B.DIMLNK0(+)=A.L5) )row_ where rownum <= 1000
2021-06-27 04:10:50 SQL执行完毕，查询出0条数据，耗时：10毫秒（开始时间：2021-06-27 04:10:50.057；结束时间：2021-06-27 04:10:50.067）；其中生成SQL耗时6毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：2毫秒；
2021-06-27 04:10:50.067 在并行计算线程池中，完成计算表格GRID1第1个分析区（0.2.12.5）！
================GRID1 END================
2021-06-27 04:10:50.076 执行查询耗时59毫秒。（内存情况：FREE=60M TOTAL=517M MAX=3.5G）
2021-06-27 04:10:50.090 构造结果表耗时14毫秒。
2021-06-27 04:10:50.090 计算“LVBB_HZ”耗时73毫秒。（内存情况：FREE=58.6M TOTAL=517M MAX=3.5G）

解锁功能报错