1 10:59:03 Log started for: 易联众医院信息综合管理平台 2 10:59:03 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 3 10:59:03 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000) select '172.16.40.107','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 10:59:03 SQL Data In: ORACLE - Rows affected = 1 5 10:59:03 SQL Execute: ORACLE - Commit 6 10:59:03 SQL Data In: ORACLE - Rows affected = 0 7 10:59:04 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 8 10:59:04 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='99999' and CZBZ00 in ('0','1') 9 10:59:04 SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = '99999' and YCLBBZ ='0' and CLBZ00 = '0' 10 10:59:04 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS' 11 10:59:04 SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from VW_XT_YHBMQX_EXT where YGBH00=1 and XTDM00 not in ('OE','MC') order by XTDM00 12 10:59:04 SQL Execute: ORACLE - Select SYSDATE from Dual 13 10:59:04 SQL Execute: ORACLE - Select SYSDATE from Dual 14 10:59:04 SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 1 15 10:59:04 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 1 16 10:59:04 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1') 17 10:59:06 SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 18 10:59:06 SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 19 10:59:06 SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital') 20 10:59:06 SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE 21 10:59:06 SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 1 22 10:59:06 SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 1 23 10:59:06 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '172.16.40.107' 24 10:59:06 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ' 25 10:59:07 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 1 and RowNum <= 10 order by DLRQSJ DESC 26 10:59:07 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1 and XTDM00='0' order by BMPLXH,BMBH00 27 10:59:09 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1 and XTDM00='D' order by BMPLXH,BMBH00 28 10:59:09 SQL Execute: ORACLE - select * from VW_XT_XTKJMK where XTDM00='D' and KJLB00 ='3' 29 10:59:09 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS,MKDYCS from VW_XT_XTKJMK where XTDM00 = 'D' and KJLB00 < '3' order by XH0000 30 10:59:09 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'D'||',')>0 31 10:59:10 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 1 and XTDM00 = 'D' 32 10:59:10 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = 'D' 33 10:59:10 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 284 and FLAG00 like '0' order by decode(CKBH00,202,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 34 10:59:10 SQL Execute: ORACLE - select * from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)) 35 10:59:10 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00) select '172.16.40.107','D',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 36 10:59:10 SQL Data In: ORACLE - Rows affected = 1 37 10:59:10 SQL Execute: ORACLE - Commit 38 10:59:10 SQL Data In: ORACLE - Rows affected = 0 39 10:59:10 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 40 10:59:10 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(SERIAL#) from V$session where AUDSID= userenv('SESSIONID')) 41 10:59:10 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(1479827,1,'LINGXIANYUN','D',nvl('3416150',' '),'172.16.40.107#246:16887@appYLZHis.exe',284,'172.16.40.107') 42 10:59:10 SQL Data In: ORACLE - Rows affected = 1 43 10:59:10 SQL Execute: ORACLE - Commit 44 10:59:10 SQL Data In: ORACLE - Rows affected = 0 45 10:59:10 SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK where YGBH00=1 and XTDM00='D' 46 10:59:10 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '172.16.40.107' and NAME00 = 'QDXTJZ' 47 10:59:10 SQL Execute: ORACLE - select JGID00,MKNBMC,MKWBMC,XTDM00,MKDLL0,JGLB00,FJGID0,XH0000,MKFGF0,XSLB00,TBSYH0 from ( select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00, -1 as TBSYH0 from XT_MKJG00 a where a.JGLB00+0 =0 and a.XTDM00 = 'D' union all select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00,a.TBSYH0 from VW_PT_YHCDMK_JG a where YGBH00 = 1 and XTDM00 = 'D') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 48 10:59:10 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 1 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 49 10:59:10 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=1 and XTDM00='D' order by XH0000 50 10:59:10 SQL Misc: ORACLE - Set stored procedure on or off 51 10:59:10 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 52 10:59:10 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 284.000000 53 10:59:10 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 54 10:59:10 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 55 10:59:10 SQL Misc: ORACLE - Set stored procedure on or off 56 10:59:10 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 57 10:59:10 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 284.000000 58 10:59:10 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3999845.000000 59 10:59:10 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 60 10:59:10 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1 and CZXH00 = 3999845.00) 61 10:59:10 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 62 10:59:10 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000) select '172.16.40.107','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 63 10:59:10 SQL Data In: ORACLE - Rows affected = 1 64 10:59:10 SQL Execute: ORACLE - Commit 65 10:59:10 SQL Data In: ORACLE - Rows affected = 0 66 10:59:10 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='99999' and CZBZ00 in ('0','1') 67 10:59:10 SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = '99999' and YCLBBZ ='0' and CLBZ00 = '0' 68 10:59:10 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS' 69 10:59:10 SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from VW_XT_YHBMQX_EXT where YGBH00=1 and XTDM00 not in ('OE','MC') order by XTDM00 70 10:59:10 SQL Execute: ORACLE - Select SYSDATE from Dual 71 10:59:10 SQL Execute: ORACLE - Select SYSDATE from Dual 72 10:59:10 SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 1 73 10:59:10 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 1 74 10:59:10 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1') 75 10:59:12 SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 76 10:59:12 SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 77 10:59:12 SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital') 78 10:59:12 SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE 79 10:59:12 SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 1 80 10:59:12 SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 1 81 10:59:12 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '172.16.40.107' 82 10:59:12 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ' 83 10:59:13 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 1 and RowNum <= 10 order by DLRQSJ DESC 84 10:59:13 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1 and XTDM00='0' order by BMPLXH,BMBH00 85 10:59:14 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1 and XTDM00='D' order by BMPLXH,BMBH00 86 10:59:14 SQL Execute: ORACLE - select * from VW_XT_XTKJMK where XTDM00='D' and KJLB00 ='3' 87 10:59:14 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS,MKDYCS from VW_XT_XTKJMK where XTDM00 = 'D' and KJLB00 < '3' order by XH0000 88 10:59:14 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'D'||',')>0 89 10:59:15 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 1 and XTDM00 = 'D' 90 10:59:15 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = 'D' 91 10:59:15 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 284 and FLAG00 like '0' order by decode(CKBH00,202,0,1),decode(CKBH00,202,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 92 10:59:15 SQL Execute: ORACLE - select * from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)) 93 10:59:15 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00) select '172.16.40.107','D',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 94 10:59:15 SQL Data In: ORACLE - Rows affected = 1 95 10:59:15 SQL Execute: ORACLE - Commit 96 10:59:15 SQL Data In: ORACLE - Rows affected = 0 97 10:59:15 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 98 10:59:15 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(SERIAL#) from V$session where AUDSID= userenv('SESSIONID')) 99 10:59:15 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(1479828,1,'LINGXIANYUN','D',nvl('3416150',' '),'172.16.40.107#246:27337@appYLZHis.exe',284,'172.16.40.107') 100 10:59:15 SQL Data In: ORACLE - Rows affected = 1 101 10:59:15 SQL Execute: ORACLE - Commit 102 10:59:15 SQL Data In: ORACLE - Rows affected = 0 103 10:59:15 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '172.16.40.107' and NAME00 = 'QDXTJZ' 104 10:59:15 SQL Execute: ORACLE - select JGID00,MKNBMC,MKWBMC,XTDM00,MKDLL0,JGLB00,FJGID0,XH0000,MKFGF0,XSLB00,TBSYH0 from ( select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00, -1 as TBSYH0 from XT_MKJG00 a where a.JGLB00+0 =0 and a.XTDM00 = 'D' union all select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00,a.TBSYH0 from VW_PT_YHCDMK_JG a where YGBH00 = 1 and XTDM00 = 'D') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 105 10:59:15 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 1 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 106 10:59:15 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=1 and XTDM00='D' order by XH0000 107 10:59:15 SQL Misc: ORACLE - Set stored procedure on or off 108 10:59:15 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 109 10:59:15 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 284.000000 110 10:59:15 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3999846.000000 111 10:59:15 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 112 10:59:15 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1 and CZXH00 = 3999846.00)