1 15:35:35 Log started for: 药房显示系统 2 15:35:35 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 15:35:35 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.6.224','Z',trim(PROGRAM)||'+'||'显示屏系统',SID,serial# ,'20170822','15:35:46','scott@0:C0324AED7E799E98058027B34CD8ED15' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 15:35:35 SQL Data In: ORACLE - Rows affected = 1 5 15:35:35 SQL Execute: ORACLE - Commit 6 15:35:35 SQL Data In: ORACLE - Rows affected = 0 7 15:35:35 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 15:35:35 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222142' 9 15:35:35 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.6.224','Z',trim(PROGRAM)||'+'||'显示屏系统',SID,serial# ,'20170822','15:35:46','sd_hospital@0:0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 10 15:35:35 SQL Data In: ORACLE - Rows affected = 1 11 15:35:35 SQL Execute: ORACLE - Commit 12 15:35:35 SQL Data In: ORACLE - Rows affected = 0 13 15:35:35 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 14 15:35:35 SQL Data In: ORACLE - Rows affected = 0 15 15:35:35 SQL Execute: ORACLE - Commit 16 15:35:35 SQL Data In: ORACLE - Rows affected = 0 17 15:35:35 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 18 15:35:35 SQL Execute: ORACLE - select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=24 and rownum=1 19 15:35:35 SQL Execute: ORACLE - select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=22 and rownum=1 20 15:35:35 SQL Execute: ORACLE - select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=20 and rownum=1 21 15:35:35 SQL Execute: ORACLE - select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=23 and rownum=1 22 15:35:38 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(23),1,1000)),'') XSPXS0 from dual where rownum=1 23 15:35:38 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(20),1,1000)),'') XSPXS0 from dual where rownum=1 24 15:35:38 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(22),1,1000)),'') XSPXS0 from dual where rownum=1 25 15:35:38 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(24),1,1000)),'') XSPXS0 from dual where rownum=1 26 15:35:41 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(20),1,1000)),'') XSPXS0 from dual where rownum=1 27 15:35:41 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(23),1,1000)),'') XSPXS0 from dual where rownum=1 28 15:35:41 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(24),1,1000)),'') XSPXS0 from dual where rownum=1 29 15:35:42 Log started for: 药房显示系统 30 15:35:42 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.6.224','Z',trim(PROGRAM)||'+'||'显示屏系统',SID,serial# ,'20170822','15:35:53','scott@0:C0324AED7E799E98058027B34CD8ED15' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 31 15:35:42 SQL Data In: ORACLE - Rows affected = 1 32 15:35:42 SQL Execute: ORACLE - Commit 33 15:35:42 SQL Data In: ORACLE - Rows affected = 0 34 15:35:42 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 35 15:35:42 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222142' 36 15:35:42 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.6.224','Z',trim(PROGRAM)||'+'||'显示屏系统',SID,serial# ,'20170822','15:35:53','sd_hospital@0:0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 37 15:35:42 SQL Data In: ORACLE - Rows affected = 1 38 15:35:42 SQL Execute: ORACLE - Commit 39 15:35:42 SQL Data In: ORACLE - Rows affected = 0 40 15:35:42 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 41 15:35:42 SQL Data In: ORACLE - Rows affected = 0 42 15:35:42 SQL Execute: ORACLE - Commit 43 15:35:42 SQL Data In: ORACLE - Rows affected = 0 44 15:35:42 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 45 15:35:42 SQL Execute: ORACLE - select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=25 and rownum=1 46 15:35:42 SQL Execute: ORACLE - select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=21 and rownum=1 47 15:35:42 SQL Execute: ORACLE - select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=0 and rownum=1 48 15:35:42 SQL Execute: ORACLE - select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=0 and rownum=1 49 15:35:45 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(21),1,1000)),'') XSPXS0 from dual where rownum=1 50 15:35:45 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(25),1,1000)),'') XSPXS0 from dual where rownum=1 51 15:35:48 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(21),1,1000)),'') XSPXS0 from dual where rownum=1 52 15:35:48 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(25),1,1000)),'') XSPXS0 from dual where rownum=1 53 15:35:51 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(21),1,1000)),'') XSPXS0 from dual where rownum=1 54 15:35:51 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(25),1,1000)),'') XSPXS0 from dual where rownum=1