1 09:49:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110809 2 09:49:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110809 3 09:49:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 62.000000 4 09:49:00 SQL Execute: ORACLE - select * from vw_gy_kswply where (ZT0000=1 OR ZT0000=2 OR ZT0000=3 OR ZT0000=4) AND QLRQ00 BETWEEN ? AND ? AND QLKSBH=? 5 09:49:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 51152 6 09:49:00 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 7 09:49:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 51152 8 09:49:00 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 9 09:49:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 51158 10 09:49:00 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 11 09:49:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 51158 12 09:49:00 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 13 09:49:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 51152 14 09:49:00 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 15 09:49:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 51152 16 09:49:00 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 17 09:49:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 51152 18 09:49:00 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 19 09:49:53 Log started for: Gysystem 20 09:49:53 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20110809','09:49:53','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 21 09:49:53 SQL Data In: ORACLE - Rows affected = 1 22 09:49:53 SQL Execute: ORACLE - Commit 23 09:49:53 SQL Data In: ORACLE - Rows affected = 0 24 09:49:53 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 25 09:49:53 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 26 09:49:53 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 27 09:49:53 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20110809','09:49:53','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 28 09:49:53 SQL Data In: ORACLE - Rows affected = 1 29 09:49:53 SQL Execute: ORACLE - Commit 30 09:49:53 SQL Data In: ORACLE - Rows affected = 0 31 09:49:53 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 32 09:49:53 SQL Data In: ORACLE - Rows affected = 0 33 09:49:53 SQL Execute: ORACLE - Commit 34 09:49:53 SQL Data In: ORACLE - Rows affected = 0 35 09:49:53 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F' 36 09:49:53 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 37 09:49:53 SQL Execute: ORACLE - Select SYSDATE from Dual 38 09:49:53 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 39 09:49:53 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 40 09:49:53 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F' 41 09:49:53 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 42 09:49:53 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 43 09:49:53 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','0','1','2','3','4','5','6','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='F' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 44 09:50:03 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'F' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 45 09:50:03 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 46 09:50:03 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 09:50:03 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 48 09:50:03 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 49 09:50:03 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 50 09:50:03 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 SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 51 09:50:03 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2661864,476,'wlzx-2','F',nvl('5568373',' '),'192.168.15.15#402:38263@GYSystem.exe+供应室管理子系统',150) 52 09:50:03 SQL Data In: ORACLE - Rows affected = 1 53 09:50:03 SQL Execute: ORACLE - Commit 54 09:50:03 SQL Data In: ORACLE - Rows affected = 0 55 09:50:03 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 150 56 09:50:03 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 57 09:50:03 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 58 09:50:03 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 59 09:50:03 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 60 09:50:03 SQL Data In: ORACLE - Rows affected = 0 61 09:50:03 SQL Execute: ORACLE - Commit 62 09:50:03 SQL Data In: ORACLE - Rows affected = 0 63 09:50:03 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 150 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 64 09:50:03 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 65 09:50:03 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 66 09:50:04 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 67 09:50:04 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',150,')> 0) and YXQ000>='20110809' 68 09:50:04 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 69 09:50:04 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 70 09:50:04 SQL Execute: ORACLE - select sysdate from dual 71 09:50:04 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID' 72 09:50:04 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID' 73 09:50:04 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED' 74 09:50:04 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 75 09:50:04 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='F' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 76 09:50:04 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'F$%' and A.XTDM00='F' and trim(A.MKDM00)='F$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0' ORDER BY B.F_TEMPTYPE,A.MKDM00 77 09:50:04 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 78 09:50:04 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 79 09:50:04 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 80 09:50:04 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 81 09:50:04 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 476 82 09:50:04 SQL Execute: ORACLE - Select value0,name00 from XT_XTCS00 where name00 in('GY_ZDYYCS','GY_HSQRDYSFAKSFL','GY_WPKCCXFS','GY_YJZWPLYSFZJFF','GY_WPCKTJFS','GY_WPCKTJHJXSSFWL','GY_WPRKSCCJSFYXZJLR','GY_WPHSSFHZ','WZ_SYDJJEBLSWXS','GY_WPLYSFYXBTLXTYD','GY_WPHSQRTHYYHSSFXSSZ', 'GY_WPLYQRHZDY','GY_WPHSQRXSPCXX','GY_WPLYQRSFFKXX','GY_WPDBXDYXQTS','GY_WPCKTJXSSZ','GY_LYWPHSCXSFXSWPTJ' ) 83 09:50:04 SQL Execute: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY' 84 09:50:04 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY' 85 09:50:04 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB' 86 09:50:04 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID' 87 09:50:04 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=476 and name00='GY_QSBRLB' 88 09:50:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 150.000000 89 09:50:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110809 90 09:50:04 SQL Execute: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A Where gyksbh=? and yxq000=? and a.ffrq00<=? and wpxz00 like ? and a.ZT0000 LIKE ? and a.FFKSBH = ? group by a.ffrbh0,a.ffczy0,a.qldh00,a.qlrq00,a.qlsj00,a.qlksmc,wpmc00,wpgg00,wpdw00,wpxzmc,a.ztmc00,a.qlrmc0,a.ffrmc0, a.zt0000,a.ffrq00,a.ffsj00,b.wpbh00 ) a,gy_wpbm00 b where a.wpbh00=b.wpbh00 order by a.qldh00