| SQL Id | SQL Text |
|---|
| 08andxfxgpws9 |
SELECT T.ZLLYZH AS ZLLYZH, T.ZLFLZH AS ZLFLZH, T.ZLFLJC AS ZLFLJC, T.ZLDSZH AS ZLDSZH, T.ZLDSJC AS ZLDSJC, T.ZLYWLB AS ZLYWLB, T.ZLYWLM AS ZLYWLM, T.ZLJYFX AS ZLJYFX, T.ZLJYFM AS ZLJYFM, T.ZLSJFS AS ZLSJFS, T.ZLSJMS AS ZLSJMS, T.ZLDJFS AS ZLDJFS, T.ZLDJMS AS ZLDJMS, T.ZLSJGR AS ZLSJGR, T.ZLDJGR AS ZLDJGR, T.ZLSZJE AS ZLSZJE, T.ZLDZJE AS ZLDZJE, T.ZLSCJG AS ZLSCJG, T.ZLDQJG AS ZLDQJG, T.ZLMEHJ AS ZLMEHJ, T.ZLZQSM AS ZLZQSM, T.ZLYWBS AS ZLYWBS, T.ZLHGLL AS ZLHGLL, T.ZLGYLL AS ZLGYLL, T.ZLHTH1 AS ZLHTH1, T.ZLHTH2 AS ZLHTH2, T.ZLLXZE AS ZLLXZE, T.ZLYQTS AS ZLYQTS, T.ZLFLBZ AS ZLFLBZ, T.ZLDSBZ AS ZLDSBZ, T.ZLFBXH AS ZLFBXH, T.ZLFBDM AS ZLFBDM, T.ZLFBJC AS ZLFBJC, T.ZLFBME AS ZLFBME, T.ZLFBZJ AS ZLFBZJ, T.ZLDBXH AS ZLDBXH, T.ZLDBDM AS ZLDBDM, T.ZLDBJC AS ZLDBJC, T.ZLDBME AS ZLDBME, T.ZLDBZJ AS ZLDBZJ, T.ZLMEXX AS ZLMEXX, T.ZLZTFS AS ZLZTFS, T.ZLZCYY AS ZLZCYY, T.ZLSYBH AS ZLSYBH, T.ZLZXYY AS ZLZXYY, T.ZLSYMS AS ZLSYMS, T.ZLZTSQ AS ZLZTSQ, T.ZLDYHT AS ZLDYHT, T.ZLDYZL AS ZLDYZL, T.ZLXDQR AS ZLXDQR, T.ZLZRZH AS ZLZRZH, T.ZLZCZH AS ZLZCZH, T.ZLCZY AS ZLCZY, T.ZLFHY AS ZLFHY, T.ZLQRY AS ZLQRY, T.ZLZLLY AS ZLZLLY, T.ZLJSSJ AS ZLJSSJ, T.ZLFHSJ AS ZLFHSJ, T.ZLQRSJ AS ZLQRSJ, T.ZLZT AS ZLZT, T.ZLFLQR AS ZLFLQR, T.ZLDSQR AS ZLDSQR, T.ZLCWCS AS ZLCWCS, T.ZLBY1 AS ZLBY1, T.ZLBY2 AS ZLBY2, T.ZLQLBZ AS ZLQLBZ, T.ZLGXSJ AS ZLGXSJ, T.ZLFBGD AS ZLFBGD, T.Z
LSBGD AS ZLSBGD, T.S_JZSJ AS S_JZSJ, T.S_SCBS AS S_SCBS, T.S_YWSJ AS S_YWSJ, T.ZLBH AS ZLBH FROM BJ_ZLCLB T, BJ_ZLCLB_TMP T1
WHERE T.ZLBH = T1.ZLBH
AND (T.ZLSJGR >=
(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD')
FROM WF_SRC_CTL
WHERE FD_NAME = 'mapping_day_opds_ards'
AND WF_NAME = 'WF_JYZW_ZL1_DAY_OPAR') AND
T.ZLSJGR <=
(SELECT TO_CHAR(END_DATE, 'YYYYMMDD')
FROM WF_SRC_CTL
WHERE FD_NAME = 'mapping_day_opds_ards'
AND WF_NAME = 'WF_JYZW_ZL1_DAY_OPAR'))
OR T.ZLSJGR <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD')
FROM WF_SRC_CTL
WHERE FD_NAME = 'mapping_day_opds_ards'
AND WF_NAME = 'WF_JYZW_ZL1_DAY_OPAR'
AND CLEAR_FLAG = 1
AND STATUS = 0) ORDER BY ZLBH, ZLLYZH, ZLFLZH, ZLFLJC, ZLDSZH, ZLDSJC, ZLYWLB, ZLYWLM, ZLJYFX, ZLJYFM, ZLSJFS, ZLSJMS, ZLDJFS, ZLDJMS, ZLSJGR, ZLDJGR, ZLSZJE, ZLDZJE, ZLSCJG, ZLDQJG, ZLMEHJ, ZLZQSM, ZLYWBS, ZLHGLL, ZLGYLL, ZLHTH1, ZLHTH2, ZLLXZE, ZLYQTS, ZLFLBZ, ZLDSBZ, ZLFBXH, ZLFBDM, ZLFBJC, ZLFBME, ZLFBZJ, ZLDBXH, ZLDBDM, ZLDBJC, ZLDBME, ZLDBZJ, ZLMEXX, ZLZTFS, ZLZCYY, ZLSYBH, ZLZXYY, ZLSYMS, ZLZTSQ, ZLDYHT, ZLDYZL, ZLXDQR, ZLZRZH, ZLZCZH, ZLCZY, ZLFHY, ZLQRY, ZLZLLY, ZLJSSJ, ZLFHSJ, ZLQRSJ, ZLZT, ZLFLQR, ZLDSQR, ZLCWCS, ZLBY1, ZLBY2, ZLQLBZ, ZLGXSJ, ZLFBGD, ZLSBGD, S_JZSJ, S_SCBS, S_YWSJ
|
| 0ckrmm4c7ya1h |
SELECT ZJ_ZJJYLS.JJFQQH AS JJFQQH, ZJ_ZJJYLS.JJJYYH AS JJJYYH, ZJ_ZJJYLS.JJJYSJ AS JJJYSJ, ZJ_ZJJYLS.JJJYXB AS JJJYXB, ZJ_ZJJYLS.JJJFZH AS JJJFZH, ZJ_ZJJYLS.JJDFZH AS JJDFZH, ZJ_ZJJYLS.JJHTHA AS JJHTHA, ZJ_ZJJYLS.JJDJQQ AS JJDJQQ, ZJ_ZJJYLS.JJZFJX AS JJZFJX, ZJ_ZJJYLS.JJFFQQ AS JJFFQQ, ZJ_ZJJYLS.JJJYBZ AS JJJYBZ, ZJ_ZJJYLS.JJJYB2 AS JJJYB2, ZJ_ZJJYLS.JJZYAO AS JJZYAO, ZJ_ZJJYLS.JJYWZL AS JJYWZL, ZJ_ZJJYLS.JJJYMA AS JJJYMA, ZJ_ZJJYLS.JJKJFM AS JJKJFM, ZJ_ZJJYLS.JJJYJE AS JJJYJE, ZJ_ZJJYLS.JJJYJ2 AS JJJYJ2, ZJ_ZJJYLS.JJJYZT AS JJJYZT, ZJ_ZJJYLS.JJCZBZ AS JJCZBZ, ZJ_ZJJYLS.JJFHRE AS JJFHRE, ZJ_ZJJYLS.JJDATE AS JJDATE, ZJ_ZJJYLS.JJYJYR AS JJYJYR, ZJ_ZJJYLS.JJYLSH AS JJYLSH, ZJ_ZJJYLS.JJJYFY AS JJJYFY, ZJ_ZJJYLS.JJJYFY2 AS JJJYFY2, ZJ_ZJJYLS.JJYWLB AS JJYWLB, ZJ_ZJJYLS.JJZQDM AS JJZQDM, ZJ_ZJJYLS.JJZQDM2 AS JJZQDM2, ZJ_ZJJYLS.JJQCJE AS JJQCJE, ZJ_ZJJYLS.JJQQHA AS JJQQHA, ZJ_ZJJYLS.JJBYZ1 AS JJBYZ1, ZJ_ZJJYLS.JJBYZ2 AS JJBYZ2, ZJ_ZJJYLS.S_SCBS AS S_SCBS, ZJ_ZJJYLS.S_JZSJ AS S_JZSJ, ZJ_ZJJYLS.S_YWSJ AS S_YWSJ, ZJ_ZJJYLS.JJJYLS AS JJJYLS, ZJ_ZJJYLS.JJJYRQ AS JJJYRQ, ZJ_ZJJYLS.JJWTRQ AS JJWTRQ FROM ZJ_ZJJYLS WHERE (ZJ_ZJJYLS.JJJYRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND ZJ_ZJJYLS.JJJYRQ <= (SELECT TO_CHAR( END_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' A
ND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR ZJ_ZJJYLS.JJJYRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY JJJYLS, JJJYRQ, JJWTRQ, JJFQQH, JJJYYH, JJJYSJ, JJJYXB, JJJFZH, JJDFZH, JJHTHA, JJDJQQ, JJZFJX, JJFFQQ, JJJYBZ, JJJYB2, JJZYAO, JJYWZL, JJJYMA, JJKJFM, JJJYJE, JJJYJ2, JJJYZT, JJCZBZ, JJFHRE, JJDATE, JJYJYR, JJYLSH, JJJYFY, JJJYFY2, JJYWLB, JJZQDM, JJZQDM2, JJQCJE, JJQQHA, JJBYZ1, JJBYZ2, S_SCBS, S_JZSJ, S_YWSJ |
| 0dnmypnrq1f92 | LOCK TABLE SYS.KU_UTLUSE IN EXCLUSIVE MODE |
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0kkhhb2w93cx0 | update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3 |
| 0v3dvmc22qnam | insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time) |
| 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') |
| 19j3n6rja3r1x | select fhscn, to_date(fhtim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), fhcrs, fhrls, to_date(fhrlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), fhafs, fhrfs, fhrft, hxerr, fhfsz, fhsta, fhdbi, fhfdbi, fhplus, fhtyp into :ckpscn, :ckptime, :crescn, :rlgscn, :rlgtime, :afzscn, :rfzscn, :rfztime, :hxerr, :blocks, :fhsta, :fhdbi, :fhfdbi, :fhplus, :fhtyp from x$kcvfhall where hxfil = :fno |
| 19x1189chq3xd | ** SQL Text Not Available ** |
| 1cq3qr774cu45 |
insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
|
| 1rpfpftz06w67 | SELECT FX_FJWMXB.JMXH AS JMXH, FX_FJWMXB.JMNSYL AS JMNSYL, FX_FJWMXB.JMBC AS JMBC, FX_FJWMXB.JMBZ AS JMBZ, FX_FJWMXB.JMZDSL AS JMZDSL, FX_FJWMXB.JMZGSL AS JMZGSL, FX_FJWMXB.JMFXBZ AS JMFXBZ, FX_FJWMXB.JMJYY AS JMJYY, FX_FJWMXB.JMLRR AS JMLRR, FX_FJWMXB.JMFHR AS JMFHR, FX_FJWMXB.S_YWSJ AS S_YWSJ, FX_FJWMXB.S_SCBS AS S_SCBS, FX_FJWMXB.S_JZSJ AS S_JZSJ, FX_FJWMXB.JMTBW AS JMTBW, FX_FJWMXB.JMZBSH AS JMZBSH FROM FX_FJWMXB WHERE EXISTS (SELECT 1 FROM FX_FZBS B WHERE B.ZBSXH = FX_FJWMXB.JMZBSH
AND ((B.ZBKSR >= (SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL2_DAY_OPAR')
AND B.ZBKSR <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL2_DAY_OPAR')
) OR B.ZBKSR <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL2_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) )) ORDER BY JMTBW, JMZBSH, JMXH, JMNSYL, JMBC, JMBZ, JMZDSL, JMZGSL, JMFXBZ, JMJYY, JMLRR, JMFHR, S_YWSJ, S_SCBS, S_JZSJ |
| 1xq5v90rudp30 |
SELECT ZQ_ZQFDTZ.S_YWSJ AS S_YWSJ, ZQ_ZQFDTZ.TZLTSC AS TZLTSC, ZQ_ZQFDTZ.TZFXZH AS TZFXZH, ZQ_ZQFDTZ.TZFXQC AS TZFXQC, ZQ_ZQFDTZ.TZFXJC AS TZFXJC, ZQ_ZQFDTZ.TZDLZH AS TZDLZH, ZQ_ZQFDTZ.TZKHQC AS TZKHQC, ZQ_ZQFDTZ.TZKHJC AS TZKHJC, ZQ_ZQFDTZ.TZZHBS AS TZZHBS, ZQ_ZQFDTZ.TZSFDL AS TZSFDL, ZQ_ZQFDTZ.TZTGYE AS TZTGYE, ZQ_ZQFDTZ.TZZCYE AS TZZCYE, ZQ_ZQFDTZ.TZFZYE AS TZFZYE, ZQ_ZQFDTZ.TZBQBJ AS TZBQBJ, ZQ_ZQFDTZ.TZDFBJ AS TZDFBJ, ZQ_ZQFDTZ.TZXQBJ AS TZXQBJ, ZQ_ZQFDTZ.TZDFBL AS TZDFBL, ZQ_ZQFDTZ.TZZCJE AS TZZCJE, ZQ_ZQFDTZ.TZZCLX AS TZZCLX, ZQ_ZQFDTZ.TZZCHJ AS TZZCHJ, ZQ_ZQFDTZ.TZFZJE AS TZFZJE, ZQ_ZQFDTZ.TZFZLX AS TZFZLX, ZQ_ZQFDTZ.TZFZHJ AS TZFZHJ, ZQ_ZQFDTZ.TZJEHJ AS TZJEHJ, ZQ_ZQFDTZ.TZLXHJ AS TZLXHJ, ZQ_ZQFDTZ.TZSXF AS TZSXF, ZQ_ZQFDTZ.TZPMLL AS TZPMLL, ZQ_ZQFDTZ.TZZXLL AS TZZXLL, ZQ_ZQFDTZ.TZLXBH AS TZLXBH, ZQ_ZQFDTZ.TZBJBH AS TZBJBH, ZQ_ZQFDTZ.TZBHYY AS TZBHYY, ZQ_ZQFDTZ.TZJSBZ AS TZJSBZ, ZQ_ZQFDTZ.TZZFRQ AS TZZFRQ, ZQ_ZQFDTZ.TZZXZQ AS TZZXZQ, ZQ_ZQFDTZ.TZZXWC AS TZZXWC, ZQ_ZQFDTZ.TZCZRQ AS TZCZRQ, ZQ_ZQFDTZ.TZJYDM AS TZJYDM, ZQ_ZQFDTZ.TZQRZT AS TZQRZT, ZQ_ZQFDTZ.TZBY1 AS TZBY1, ZQ_ZQFDTZ.TZBY2 AS TZBY2, ZQ_ZQFDTZ.TZCZY AS TZCZY, ZQ_ZQFDTZ.TZFHY AS TZFHY, ZQ_ZQFDTZ.TZGXSJ AS TZGXSJ, ZQ_ZQFDTZ.S_JZSJ AS S_JZSJ, ZQ_ZQFDTZ.S_SCBS AS S_SCBS, ZQ_ZQFDTZ.TZZQDM AS TZZQDM, ZQ_ZQFDTZ.TZTZLB AS TZTZLB, ZQ_ZQFDTZ.TZTGZH AS TZTGZH, ZQ_ZQFDTZ.TZJLZT AS TZJLZT, ZQ_ZQFDTZ.TZFDCS AS TZFDCS, ZQ
_ZQFDTZ.TZFDRQ AS TZFDRQ FROM ZQ_ZQFDTZ WHERE (ZQ_ZQFDTZ.TZCZRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL2_DAY_OPAR')
AND ZQ_ZQFDTZ.TZCZRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL2_DAY_OPAR')
) OR ZQ_ZQFDTZ.TZCZRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL2_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY TZZQDM, TZTZLB, TZTGZH, TZJLZT, TZFDCS, TZFDRQ, S_YWSJ, TZLTSC, TZFXZH, TZFXQC, TZFXJC, TZDLZH, TZKHQC, TZKHJC, TZZHBS, TZSFDL, TZTGYE, TZZCYE, TZFZYE, TZBQBJ, TZDFBJ, TZXQBJ, TZDFBL, TZZCJE, TZZCLX, TZZCHJ, TZFZJE, TZFZLX, TZFZHJ, TZJEHJ, TZLXHJ, TZSXF, TZPMLL, TZZXLL, TZLXBH, TZBJBH, TZBHYY, TZJSBZ, TZZFRQ, TZZXZQ, TZZXWC, TZCZRQ, TZJYDM, TZQRZT, TZBY1, TZBY2, TZCZY, TZFHY, TZGXSJ, S_JZSJ, S_SCBS |
| 350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
| 3c1kubcdjnppq | update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln |
| 3d0537zmn35rz |
insert into wrh$_sess_time_stats (snap_id, dbid, instance_number, session_type, min_logon_time, sum_cpu_time, sum_sys_io_wait, sum_user_io_wait) select :snap_id, :dbid, :instance_number, type, min(logon_time) min_logon_time, sum(cpu_time) cpu_time, sum(sys_io_wait) sys_io_wait, sum(user_io_wait) user_io_wait from (select sid, serial#, max(type) type, max(logon_time) logon_time, max(cpu_time) cpu_time, sum(case when kslcsclsname = 'System I/O' then kslcstim else 0 end) as sys_io_wait, sum(case when kslcsclsname ='User I/O' then kslcstim else 0 end) as user_io_wait from (select /*+ ordered */ allsids.sid sid, allsids.serial# serial#, max(type) type, max(logon_time) logon_time, sum(kewsval) cpu_time from (select type, allsids.sid, sess.ksuseser as serial#, sess.ksuseltm as logon_time from (select /*+ ordered index(p) */ s.indx as sid, decode(l.role, 'reader', 'Logminer Reader', 'preparer', 'Logminer Preparer', 'builder', 'Logminer Builder') as type from x$logmnr_process l, x$ksupr p, x$ksuse s where l.role in ('reader', 'preparer', 'builder') and l.pid = p.indx and bitand(p.ksspaflg, 1)!=0 and p.ksuprpid = s.ksusepid union all select sid
_knst as sid, decode(type_knst, 8, 'STREAMS Capture', 7, 'STREAMS Apply Reader', 2, 'STREAMS Apply Server', 1, 'STREAMS Apply Coordinator') as type from x$knstcap where type_knst in (8, 7, 2, 1) union all select indx as sid, (case when ksusepnm like '%(Q00%)' then 'QMON Slaves' else 'QMON Coordinator' end) as type from x$ksuse where ksusepnm like '%(Q00%)' or ksusepnm like '%(QMNC)' union all select kwqpssid as sid, 'Propagation Sender' as type from x$kwqps union all select kwqpdsid as sid, 'Propagation Receiver' as type from x$kwqpd union all select proxy_sid_knstasl as sid, 'Apply Network Receiver' as type from x$knstasl a where type_knst = 7 and proxy_sid_knstasl is not null and not exists (select 1 from x$knstcap x where type_knst = 8 and x.sid_knst = a.proxy_sid_knstasl) ) allsids, x$ksuse sess where bitand(sess.ksspaflg, 1) != 0 and bitand(sess.ksuseflg, 1) != 0 and allsids.sid = sess.indx) allsids, x$kewssesv sesv, x$kewssmap map where allsids.sid = sesv.ksusenum and sesv.kewsnum = map.soffst and map.aggid = 1 and (map.stype = 2 or map.stype = 3) and map.sname in ('DB CPU', 'background cpu time') group by sid, seria
l#) allaggr, x$kslcs allio where allaggr.sid = allio.kslcssid(+) and allio.kslcsclsname in ('System I/O', 'User I/O') group by allaggr.sid, allaggr.serial#) group by type |
| 459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
| 4d1cpsvtkdhnq |
SELECT ZJ_ZJKMZX.ZXKMYE AS ZXKMYE, ZJ_ZJKMZX.ZXJFFE AS ZXJFFE, ZJ_ZJKMZX.ZXDFFE AS ZXDFFE, ZJ_ZJKMZX.ZXJFFS AS ZXJFFS, ZJ_ZJKMZX.ZXDFFS AS ZXDFFS, ZJ_ZJKMZX.ZXJFYE AS ZXJFYE, ZJ_ZJKMZX.ZXDFYE AS ZXDFYE, ZJ_ZJKMZX.ZXSJYE AS ZXSJYE, ZJ_ZJKMZX.ZXSDYE AS ZXSDYE, ZJ_ZJKMZX.ZXBYDA AS ZXBYDA, ZJ_ZJKMZX.ZXBYDB AS ZXBYDB, ZJ_ZJKMZX.ZXBYDC AS ZXBYDC, ZJ_ZJKMZX.S_SCBS AS S_SCBS, ZJ_ZJKMZX.S_YWSJ AS S_YWSJ, ZJ_ZJKMZX.S_JZSJ AS S_JZSJ, ZJ_ZJKMZX.ZXTGZH AS ZXTGZH, ZJ_ZJKMZX.ZXDATE AS ZXDATE, ZJ_ZJKMZX.ZXHBMA AS ZXHBMA, ZJ_ZJKMZX.ZXKMMA AS ZXKMMA, ZJ_ZJKMZX.ZXKMJB AS ZXKMJB FROM ZJ_ZJKMZX WHERE (ZJ_ZJKMZX.ZXDATE >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND ZJ_ZJKMZX.ZXDATE <= (SELECT TO_CHAR( END_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR ZJ_ZJKMZX.ZXDATE <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY ZXTGZH, ZXDATE, ZXHBMA, ZXKMMA, ZXKMJB, ZXKMYE, ZXJFFE, ZXDFFE, ZXJFFS, ZXDFFS, ZXJFYE, ZXDFYE, ZXSJYE, ZXSDYE, ZXBYDA, ZXBYDB, ZXBYDC, S_SCBS, S_YWSJ, S_JZSJ
|
| 4rj7hcm28z0yk |
SELECT ZJ_ZJLZLS.LZQQBH AS LZQQBH, ZJ_ZJLZLS.LZWTRQ AS LZWTRQ, ZJ_ZJLZLS.LZJYLS AS LZJYLS, ZJ_ZJLZLS.LZJYMA AS LZJYMA, ZJ_ZJLZLS.LZYWZL AS LZYWZL, ZJ_ZJLZLS.LZYWZL3 AS LZYWZL3, ZJ_ZJLZLS.LZBWLX AS LZBWLX, ZJ_ZJLZLS.LZYWZL2 AS LZYWZL2, ZJ_ZJLZLS.LZYJZL AS LZYJZL, ZJ_ZJLZLS.LZZFFK AS LZZFFK, ZJ_ZJLZLS.LZQSHH AS LZQSHH, ZJ_ZJLZLS.LZQSJG AS LZQSJG, ZJ_ZJLZLS.LZFQHH AS LZFQHH, ZJ_ZJLZLS.LZJSHH AS LZJSHH, ZJ_ZJLZLS.LZTHHH AS LZTHHH, ZJ_ZJLZLS.LZFKHH AS LZFKHH, ZJ_ZJLZLS.LZFKZH AS LZFKZH, ZJ_ZJLZLS.LZFKMC AS LZFKMC, ZJ_ZJLZLS.LZFKDZ AS LZFKDZ, ZJ_ZJLZLS.LZSKHH AS LZSKHH, ZJ_ZJLZLS.LZSKZH AS LZSKZH, ZJ_ZJLZLS.LZSKMC AS LZSKMC, ZJ_ZJLZLS.LZSKDZ AS LZSKDZ, ZJ_ZJLZLS.LZHBFH AS LZHBFH, ZJ_ZJLZLS.LZJE17 AS LZJE17, ZJ_ZJLZLS.LZYHHH AS LZYHHH, ZJ_ZJLZLS.LZSQCH AS LZSQCH, ZJ_ZJLZLS.LZSQH AS LZSQH, ZJ_ZJLZLS.LZYSQR AS LZYSQR, ZJ_ZJLZLS.LZCSYD AS LZCSYD, ZJ_ZJLZLS.LZTHYD AS LZTHYD, ZJ_ZJLZLS.LZTBFK AS LZTBFK, ZJ_ZJLZLS.LZTBHY AS LZTBHY, ZJ_ZJLZLS.LZTBFY AS LZTBFY, ZJ_ZJLZLS.LZCLXX AS LZCLXX, ZJ_ZJLZLS.LZFY62 AS LZFY62, ZJ_ZJLZLS.LZFY82 AS LZFY82, ZJ_ZJLZLS.LZFBDM AS LZFBDM, ZJ_ZJLZLS.LZHYBZ AS LZHYBZ, ZJ_ZJLZLS.LZBWZT AS LZBWZT, ZJ_ZJLZLS.LZYWTRQ AS LZYWTRQ, ZJ_ZJLZLS.LZYBWLX AS LZYBWLX, ZJ_ZJLZLS.LZYYWZL2 AS LZYYWZL2, ZJ_ZJLZLS.LZYYJXH AS LZYYJXH, ZJ_ZJLZLS.LZYQQHA AS LZYQQHA, ZJ_ZJLZLS.S_JZSJ AS S_JZSJ, ZJ_ZJLZLS.S_YWSJ AS S_YWSJ, ZJ_ZJLZLS.S_SCBS AS S_SCBS, ZJ_ZJLZLS.LZJLRS AS LZJLRS, ZJ_ZJLZL
S.LZYJXH AS LZYJXH, ZJ_ZJLZLS.LZQQHA AS LZQQHA FROM ZJ_ZJLZLS WHERE (ZJ_ZJLZLS.LZWTRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD')||' ' FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND ZJ_ZJLZLS.LZWTRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD')||' ' FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR ZJ_ZJLZLS.LZWTRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD')||' ' FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY LZJLRS, LZYJXH, LZQQHA, LZQQBH, LZWTRQ, LZJYLS, LZJYMA, LZYWZL, LZYWZL3, LZBWLX, LZYWZL2, LZYJZL, LZZFFK, LZQSHH, LZQSJG, LZFQHH, LZJSHH, LZTHHH, LZFKHH, LZFKZH, LZFKMC, LZFKDZ, LZSKHH, LZSKZH, LZSKMC, LZSKDZ, LZHBFH, LZJE17, LZYHHH, LZSQCH, LZSQH, LZYSQR, LZCSYD, LZTHYD, LZTBFK, LZTBHY, LZTBFY, LZCLXX, LZFY62, LZFY82, LZFBDM, LZHYBZ, LZBWZT, LZYWTRQ, LZYBWLX, LZYYWZL2, LZYYJXH, LZYQQHA, S_JZSJ, S_YWSJ, S_SCBS |
| 4vs91dcv7u1p6 | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36) |
| 4x0g24gwgqfub | SELECT GT_MXBDB.MBSCRQ AS MBSCRQ, GT_MXBDB.MBYE AS MBYE, GT_MXBDB.MBBYY1 AS MBBYY1, GT_MXBDB.MBBYY2 AS MBBYY2, GT_MXBDB.MBBYY3 AS MBBYY3, GT_MXBDB.S_JZSJ AS S_JZSJ, GT_MXBDB.S_YWSJ AS S_YWSJ, GT_MXBDB.S_SCBS AS S_SCBS, GT_MXBDB.MBCLBZ AS MBCLBZ, GT_MXBDB.MBTGZH AS MBTGZH, GT_MXBDB.MBYWRQ AS MBYWRQ, GT_MXBDB.MBZQDM AS MBZQDM, GT_MXBDB.MBJYSH AS MBJYSH FROM GT_MXBDB WHERE (GT_MXBDB.MBYWRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND GT_MXBDB.MBYWRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR GT_MXBDB.MBYWRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY MBCLBZ, MBTGZH, MBYWRQ, MBZQDM, MBJYSH, MBSCRQ, MBYE, MBBYY1, MBBYY2, MBBYY3, S_JZSJ, S_YWSJ, S_SCBS |
| 5s34t44u10q4g | SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1 |
| 5u5026wguvy5z | SELECT BJ_YEB.YEJF AS YEJF, BJ_YEB.YEDF AS YEDF, BJ_YEB.YEJY AS YEJY, BJ_YEB.S_JZSJ AS S_JZSJ, BJ_YEB.S_YWSJ AS S_YWSJ, BJ_YEB.S_SCBS AS S_SCBS, BJ_YEB.YEZQXH AS YEZQXH, BJ_YEB.YEZH AS YEZH, BJ_YEB.YERQ AS YERQ, BJ_YEB.YEKM AS YEKM FROM BJ_YEB WHERE (BJ_YEB.YERQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
AND BJ_YEB.YERQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
) OR (BJ_YEB.YERQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) AND BJ_YEB.YERQ >= (SELECT TO_CHAR(CLEAR_BDATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ) ORDER BY YEZQXH, YEZH, YERQ, YEKM, YEJF, YEDF, YEJY, S_JZSJ, S_YWSJ, S_SCBS |
| 5ur69atw3vfhj | select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1 |
| 5uvsbqnnnw4j9 | SELECT BJ_JGDZQ.JQZQDM AS JQZQDM, BJ_JGDZQ.JQZQJC AS JQZQJC, BJ_JGDZQ.JQZQME AS JQZQME, BJ_JGDZQ.JQZQSX AS JQZQSX, BJ_JGDZQ.JQZQJG AS JQZQJG, BJ_JGDZQ.JQZYBL AS JQZYBL, BJ_JGDZQ.JQCRBZ AS JQCRBZ, BJ_JGDZQ.JQYJLX AS JQYJLX, BJ_JGDZQ.JQYJXE AS JQYJXE, BJ_JGDZQ.JQBY1 AS JQBY1, BJ_JGDZQ.JQBY2 AS JQBY2, BJ_JGDZQ.JQQLBZ AS JQQLBZ, BJ_JGDZQ.JQGXSJ AS JQGXSJ, BJ_JGDZQ.S_SCBS AS S_SCBS, BJ_JGDZQ.S_YWSJ AS S_YWSJ, BJ_JGDZQ.S_JZSJ AS S_JZSJ, BJ_JGDZQ.JQHTH AS JQHTH, BJ_JGDZQ.JQZQXH AS JQZQXH FROM BJ_JGDZQ WHERE EXISTS (SELECT 1 FROM BJ_HTCLB B WHERE B.HCHTH = BJ_JGDZQ.JQHTH
AND ((B.HCJGR >= (SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
AND B.HCJGR <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
) OR B.HCJGR <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) )) ORDER BY JQHTH, JQZQXH, JQZQDM, JQZQJC, JQZQME, JQZQSX, JQZQJG, JQZYBL, JQCRBZ, JQYJLX, JQYJXE, JQBY1, JQBY2, JQQLBZ, JQGXSJ, S_SCBS, S_YWSJ, S_JZSJ |
| 5vrtcy6a4cczx |
SELECT ZJ_ZJBJQQ.QQYWLB AS QQYWLB, ZJ_ZJBJQQ.QQTGZH AS QQTGZH, ZJ_ZJBJQQ.QQDLZH AS QQDLZH, ZJ_ZJBJQQ.QQFQZH AS QQFQZH, ZJ_ZJBJQQ.QQFQJF AS QQFQJF, ZJ_ZJBJQQ.QQFQJE AS QQFQJE, ZJ_ZJBJQQ.QQFQBB AS QQFQBB, ZJ_ZJBJQQ.QQFFZH AS QQFFZH, ZJ_ZJBJQQ.QQFFMC AS QQFFMC, ZJ_ZJBJQQ.QQSQZH AS QQSQZH, ZJ_ZJBJQQ.QQSQJF AS QQSQJF, ZJ_ZJBJQQ.QQSQJE AS QQSQJE, ZJ_ZJBJQQ.QQSQBB AS QQSQBB, ZJ_ZJBJQQ.QQSFZH AS QQSFZH, ZJ_ZJBJQQ.QQSFMC AS QQSFMC, ZJ_ZJBJQQ.QQZHZT AS QQZHZT, ZJ_ZJBJQQ.QQQQLB AS QQQQLB, ZJ_ZJBJQQ.QQDJXH AS QQDJXH, ZJ_ZJBJQQ.QQJSZL AS QQJSZL, ZJ_ZJBJQQ.QQZQDM AS QQZQDM, ZJ_ZJBJQQ.QQZQMC AS QQZQMC, ZJ_ZJBJQQ.QQZQJC AS QQZQJC, ZJ_ZJBJQQ.QQZQXZ AS QQZQXZ, ZJ_ZJBJQQ.QQZQME AS QQZQME, ZJ_ZJBJQQ.QQJJJE AS QQJJJE, ZJ_ZJBJQQ.QQZQLX AS QQZQLX, ZJ_ZJBJQQ.QQSFJE AS QQSFJE, ZJ_ZJBJQQ.QQHGJE AS QQHGJE, ZJ_ZJBJQQ.QQHGDQ AS QQHGDQ, ZJ_ZJBJQQ.QQHGLX AS QQHGLX, ZJ_ZJBJQQ.QQJYBB AS QQJYBB, ZJ_ZJBJQQ.QQFYZL AS QQFYZL, ZJ_ZJBJQQ.QQJFBH AS QQJFBH, ZJ_ZJBJQQ.QQJFQKR AS QQJFQKR, ZJ_ZJBJQQ.QQJFQJR AS QQJFQJR, ZJ_ZJBJQQ.QQJFKR AS QQJFKR, ZJ_ZJBJQQ.QQJFJR AS QQJFJR, ZJ_ZJBJQQ.QQFXZH AS QQFXZH, ZJ_ZJBJQQ.QQFXMC AS QQFXMC, ZJ_ZJBJQQ.QQCYMC AS QQCYMC, ZJ_ZJBJQQ.QQHFBZ AS QQHFBZ, ZJ_ZJBJQQ.QQZLBM AS QQZLBM, ZJ_ZJBJQQ.QQCYME AS QQCYME, ZJ_ZJBJQQ.QQKHQC AS QQKHQC, ZJ_ZJBJQQ.QQKHJC AS QQKHJC, ZJ_ZJBJQQ.QQCYLB AS QQCYLB, ZJ_ZJBJQQ.QQKHBH AS QQKHBH, ZJ_ZJBJQQ.QQHETH AS QQHETH, ZJ_ZJBJQQ.QQJBBH AS QQJBBH, ZJ_ZJBJQQ.QQJBYH A
S QQJBYH, ZJ_ZJBJQQ.QQJBXM AS QQJBXM, ZJ_ZJBJQQ.QQZJLB AS QQZJLB, ZJ_ZJBJQQ.QQZJHM AS QQZJHM, ZJ_ZJBJQQ.QQJBLE AS QQJBLE, ZJ_ZJBJQQ.QQJBJS AS QQJBJS, ZJ_ZJBJQQ.QQJBZT AS QQJBZT, ZJ_ZJBJQQ.QQJYFY AS QQJYFY, ZJ_ZJBJQQ.QQJLZT AS QQJLZT, ZJ_ZJBJQQ.QQJLRS AS QQJLRS, ZJ_ZJBJQQ.S_JZSJ AS S_JZSJ, ZJ_ZJBJQQ.S_SCBS AS S_SCBS, ZJ_ZJBJQQ.S_YWSJ AS S_YWSJ, ZJ_ZJBJQQ.QQJYLS AS QQJYLS, ZJ_ZJBJQQ.QQJYMA AS QQJYMA, ZJ_ZJBJQQ.QQQQHA AS QQQQHA, ZJ_ZJBJQQ.QQYWZL AS QQYWZL, ZJ_ZJBJQQ.QQWTRQ AS QQWTRQ FROM ZJ_ZJBJQQ WHERE (ZJ_ZJBJQQ.QQWTRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND ZJ_ZJBJQQ.QQWTRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR ZJ_ZJBJQQ.QQWTRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY QQJYLS, QQJYMA, QQQQHA, QQYWZL, QQWTRQ, QQYWLB, QQTGZH, QQDLZH, QQFQZH, QQFQJF, QQFQJE, QQFQBB, QQFFZH, QQFFMC, QQSQZH, QQSQJF, QQSQJE, QQSQBB, QQSFZH, QQSFMC, QQZHZT, QQQQLB, QQDJXH, QQJSZL, QQZQDM, QQZQMC, QQZQJC, QQZQXZ, QQZQME, QQJJJE, QQZQLX, QQSFJE, QQHGJE, QQHGDQ, QQHGLX, QQJYBB, QQFYZL, QQJFBH, QQJFQKR, QQJFQJR, QQJFKR, QQJFJR, QQFXZH, QQFXMC, QQCYMC, QQHFBZ, QQZLBM, QQCYME, QQKHQC, QQKHJC, QQCYL
B, QQKHBH, QQHETH, QQJBBH, QQJBYH, QQJBXM, QQZJLB, QQZJHM, QQJBLE, QQJBJS, QQJBZT, QQJYFY, QQJLZT, QQJLRS, S_JZSJ, S_SCBS, S_YWSJ |
| 658mn0bchnnug | SELECT GT_ZYZHDZB.ZDWXE AS ZDWXE, GT_ZYZHDZB.ZDJBED AS ZDJBED, GT_ZYZHDZB.ZDYXE AS ZDYXE, GT_ZYZHDZB.ZDTDE AS ZDTDE, GT_ZYZHDZB.ZDZTDE AS ZDZTDE, GT_ZYZHDZB.ZDZYZE AS ZDZYZE, GT_ZYZHDZB.ZDBZYZE AS ZDBZYZE, GT_ZYZHDZB.ZDGXSJ AS ZDGXSJ, GT_ZYZHDZB.S_SCBS AS S_SCBS, GT_ZYZHDZB.S_YWSJ AS S_YWSJ, GT_ZYZHDZB.S_JZSJ AS S_JZSJ, GT_ZYZHDZB.ZDZQDM AS ZDZQDM, GT_ZYZHDZB.ZDRQ AS ZDRQ, GT_ZYZHDZB.ZDJYSH AS ZDJYSH FROM GT_ZYZHDZB WHERE (GT_ZYZHDZB.ZDRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND GT_ZYZHDZB.ZDRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR GT_ZYZHDZB.ZDRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY ZDZQDM, ZDRQ, ZDJYSH, ZDWXE, ZDJBED, ZDYXE, ZDTDE, ZDZTDE, ZDZYZE, ZDBZYZE, ZDGXSJ, S_SCBS, S_YWSJ, S_JZSJ |
| 69k5bhm12sz98 | ** SQL Text Not Available ** |
| 6awh7zft2c5rh | SELECT BJ_FHMXB.FHJYRQ AS FHJYRQ, BJ_FHMXB.FHJYSJ AS FHJYSJ, BJ_FHMXB.FHYWLB AS FHYWLB, BJ_FHMXB.FHZH AS FHZH, BJ_FHMXB.FHKM AS FHKM, BJ_FHMXB.FHZQXH AS FHZQXH, BJ_FHMXB.FHFSE AS FHFSE, BJ_FHMXB.FHZYXH AS FHZYXH, BJ_FHMXB.FHJDFX AS FHJDFX, BJ_FHMXB.FHYE AS FHYE, BJ_FHMXB.FHHTH AS FHHTH, BJ_FHMXB.FHKJSX AS FHKJSX, BJ_FHMXB.FHFLH AS FHFLH, BJ_FHMXB.S_JZSJ AS S_JZSJ, BJ_FHMXB.S_YWSJ AS S_YWSJ, BJ_FHMXB.S_SCBS AS S_SCBS, BJ_FHMXB.FHLSH AS FHLSH FROM BJ_FHMXB WHERE (BJ_FHMXB.FHJYRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
AND BJ_FHMXB.FHJYRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
) OR BJ_FHMXB.FHJYRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY FHLSH, FHJYRQ, FHJYSJ, FHYWLB, FHZH, FHKM, FHZQXH, FHFSE, FHZYXH, FHJDFX, FHYE, FHHTH, FHKJSX, FHFLH, S_JZSJ, S_YWSJ, S_SCBS |
| 6dv0dpznx0dg9 | select VALUE from NLS_SESSION_PARAMETERS where PARAMETER='NLS_LENGTH_SEMANTICS' |
| 6xvp6nxs4a9n4 | select nvl(sum(space), 0) from recyclebin$ where ts# = :1 |
| 76cckj4yysvua | select time_mp, scn, num_mappings, tim_scn_map from smon_scn_time where scn = (select max(scn) from smon_scn_time where scn <= :1) |
| 76yj9jrkj39cu | ** SQL Text Not Available ** |
| 794zsrxp0th92 | SELECT GT_DXEDB.DTJBED AS DTJBED, GT_DXEDB.DTJDE AS DTJDE, GT_DXEDB.DTTJDE AS DTTJDE, GT_DXEDB.DTYXE AS DTYXE, GT_DXEDB.DTGXSJ AS DTGXSJ, GT_DXEDB.DTBZ AS DTBZ, GT_DXEDB.S_SCBS AS S_SCBS, GT_DXEDB.S_JZSJ AS S_JZSJ, GT_DXEDB.S_YWSJ AS S_YWSJ, GT_DXEDB.DTTDE AS DTTDE, GT_DXEDB.DTJYSH AS DTJYSH, GT_DXEDB.DTZQDM AS DTZQDM, GT_DXEDB.DTRQ AS DTRQ FROM GT_DXEDB WHERE (GT_DXEDB.DTRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND GT_DXEDB.DTRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR GT_DXEDB.DTRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY DTJYSH, DTZQDM, DTRQ, DTJBED, DTJDE, DTTJDE, DTYXE, DTGXSJ, DTBZ, S_SCBS, S_JZSJ, S_YWSJ, DTTDE |
| 7gzxf61vj6wq4 | SELECT ID FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY, :B2 ) = :B2 AND A.OWNER# = :B1 |
| 7z0xq8hvq6sff |
SELECT A.ZLRQ AS ZLRQ, A.ZLSRYE AS ZLSRYE, A.ZLIRGE AS ZLIRGE, A.ZLIRGB AS ZLIRGB, A.ZLORGE AS ZLORGE, A.ZLORGB AS ZLORGB, A.ZLIMRE AS ZLIMRE, A.ZLIMRB AS ZLIMRB, A.ZLOMRE AS ZLOMRE, A.ZLOMRB AS ZLOMRB, A.ZLIMCE AS ZLIMCE, A.ZLIMCB AS ZLIMCB, A.ZLOMCE AS ZLOMCE, A.ZLOMCB AS ZLOMCB, A.ZLISHE AS ZLISHE, A.ZLISHB AS ZLISHB, A.ZLOSHE AS ZLOSHE, A.ZLOSHB AS ZLOSHB, A.ZLIHGE AS ZLIHGE, A.ZLIHGB AS ZLIHGB, A.ZLOHGE AS ZLOHGE, A.ZLOHGB AS ZLOHGB, A.ZLICJE AS ZLICJE, A.ZLICJB AS ZLICJB, A.ZLOCJE AS ZLOCJE, A.ZLOCJB AS ZLOCJB, A.ZLIRJE AS ZLIRJE, A.ZLIRJB AS ZLIRJB, A.ZLORJE AS ZLORJE, A.ZLORJB AS ZLORJB, A.ZLIFH AS ZLIFH, A.ZLIJE AS ZLIJE, A.ZLOFH AS ZLOFH, A.ZLOJE AS ZLOJE, A.ZLIGZH AS ZLIGZH, A.ZLIGZE AS ZLIGZE, A.ZLOGZH AS ZLOGZH, A.ZLOGZE AS ZLOGZE, A.ZLIFJE AS ZLIFJE, A.ZLIFJB AS ZLIFJB, A.ZLOFJE AS ZLOFJE, A.ZLOFJB AS ZLOFJB, A.ZLIZYE AS ZLIZYE, A.ZLIZYB AS ZLIZYB, A.ZLOZYE AS ZLOZYE, A.ZLOZYB AS ZLOZYB, A.ZLIJYE AS ZLIJYE, A.ZLIJYB AS ZLIJYB, A.ZLOJYE AS ZLOJYE, A.ZLOJYB AS ZLOJYB, A.ZLIDJE AS ZLIDJE, A.ZLIDJB AS ZLIDJB, A.ZLODJE AS ZLODJE, A.ZLODJB AS ZLODJB, A.ZLIJDE AS ZLIJDE, A.ZLIJDB AS ZLIJDB, A.ZLOJDE AS ZLOJDE, A.ZLOJDB AS ZLOJDB, A.ZLICBE AS ZLICBE, A.ZLIBBE AS ZLIBBE, A.ZLICBB AS ZLICBB, A.ZLIBBB AS ZLIBBB, A.ZLOCBE AS ZLOCBE, A.ZLOBBE AS ZLOBBE, A.ZLOCBB AS ZLOCBB, A.Z
LOBBB AS ZLOBBB, A.ZLISQE AS ZLISQE, A.ZLISQB AS ZLISQB, A.ZLOSQE AS ZLOSQE, A.ZLOSQB AS ZLOSQB, A.ZLOSSE AS ZLOSSE, A.ZLOSSB AS ZLOSSB, A.ZLIRSBE AS ZLIRSBE, A.ZLIRSBB AS ZLIRSBB, A.ZLORMSB AS ZLORMSB, A.ZLORBSB AS ZLORBSB, A.ZLOSBCE AS ZLOSBCE, A.ZLOSBCB AS ZLOSBCB, A.ZLOSBRE AS ZLOSBRE, A.ZLOSBRB AS ZLOSBRB, A.ZLBRYE AS ZLBRYE, A.ZLBDHZ AS ZLBDHZ, A.ZLDZCH AS ZLDZCH, A.ZLDZCE AS ZLDZCE, A.ZLMKYJ AS ZLMKYJ, A.ZLRGYX AS ZLRGYX, A.ZLMRYX AS ZLMRYX, A.ZLMCYX AS ZLMCYX, A.ZLSHYX AS ZLSHYX, A.ZLHGYX AS ZLHGYX, A.ZLGZYX AS ZLGZYX, A.ZLZCYX AS ZLZCYX, A.ZLZRYX AS ZLZRYX, A.ZLFJYX AS ZLFJYX, A.ZLZYYX AS ZLZYYX, A.ZLJYYX AS ZLJYYX, A.ZLDJYX AS ZLDJYX, A.ZLJDYX AS ZLJDYX, A.ZLSQYX AS ZLSQYX, A.ZLCLBZ AS ZLCLBZ, A.ZLFKBZ AS ZLFKBZ, A.ZLRGJE AS ZLRGJE, A.ZLMCJE AS ZLMCJE, A.ZLSHJE AS ZLSHJE, A.ZLHGJE AS ZLHGJE, A.ZLMRJE AS ZLMRJE, A.S_YWSJ AS S_YWSJ, A.S_SCBS AS S_SCBS, A.S_JZSJ AS S_JZSJ, A.ZLSCRQ AS ZLSCRQ, A.ZLZQDH AS ZLZQDH, A.ZLJYSH AS ZLJYSH FROM GT_ZLHZB A
WHERE (A.ZLRQ >=
(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD')
FROM WF_SRC_CTL
WHERE FD_NAME = 'mapping_day_opds_ards'
AND WF_NAME = 'WF_JYZW_ZL5_DAY_OPAR') AND
A.ZLRQ <=
(SELECT TO_CHAR(END_DATE, 'YYYYMMDD')
FROM WF_SRC_CTL
WHERE FD_NAME = 'mapping_day_opds_ards'
AND WF_NAME = 'WF_JYZW_ZL5_DAY_OPAR'
))
OR (A.ZLRQ >= (SELECT TO_CHAR(CLEAR_BDATE, 'YYYYMMDD')
FROM WF_SRC_CTL
WHERE FD_NAME = 'mapping_day_opds_ards'
AND WF_NAME = 'WF_JYZW_ZL5_DAY_OPAR'
AND CLEAR_FLAG = 1
AND STATUS = 0) AND
A.ZLRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD')
FROM WF_SRC_CTL
WHERE FD_NAME = 'mapping_day_opds_ards'
AND WF_NAME = 'WF_JYZW_ZL5_DAY_OPAR'
AND CLEAR_FLAG = 1
AND STATUS = 0)) ORDER BY A.ZLSCRQ, A.ZLZQDH, A.ZLJYSH -- ORDER BY ZLSCRQ, ZLZQDH, ZLJYSH, ZLRQ, ZLSRYE, ZLIRGE, ZLIRGB, ZLORGE, ZLORGB, ZLIMRE, ZLIMRB, ZLOMRE, ZLOMRB, ZLIMCE, ZLIMCB, ZLOMCE, ZLOMCB, ZLISHE, ZLISHB, ZLOSHE, ZLOSHB, ZLIHGE, ZLIHGB, ZLOHGE, ZLOHGB, ZLICJE, ZLICJB, ZLOCJE, ZLOCJB, ZLIRJE, ZLIRJB, ZLORJE, ZLORJB, ZLIFH, ZLIJE, ZLOFH, ZLOJE, ZLIGZH, ZLIGZE, ZLOGZH, ZLOGZE, ZLIFJE, ZLIFJB, ZLOFJE, ZLOFJB, ZLIZYE, ZLIZYB, ZLOZYE, ZLOZYB, ZLIJYE, ZLIJYB, ZLOJYE, ZLOJYB, ZLIDJE, ZLIDJB, ZLODJE, ZLODJB, ZLIJDE, ZLIJDB, ZLOJDE, ZLOJDB, ZLICBE, ZLIBBE, ZLICBB, ZLIBBB, ZLOCBE, ZLOBBE, ZLOCBB, ZLOBBB, ZLISQE, ZLISQB, ZLOSQE, ZLOSQB, ZLOSSE, ZLOSSB, ZLIRSBE, ZLIRSBB, ZLORMSB, ZLORBSB, ZLOSBCE, ZLOSBCB, ZLOSBRE, ZLOSBRB, ZLBRYE, ZLBDHZ, ZLDZCH, ZLDZCE, ZLMKYJ, ZLRGYX, ZLMRYX, ZLMCYX, ZLSHYX, ZLHGYX, ZLGZYX, ZLZCYX, ZLZR
YX, ZLFJYX, ZLZYYX, ZLJYYX, ZLDJYX, ZLJDYX, ZLSQYX, ZLCLBZ, ZLFKBZ, ZLRGJE, ZLMCJE, ZLSHJE, ZLHGJE, ZLMRJE, S_YWSJ, S_SCBS, S_JZSJ |
| 8agwdqgvnpqzh | ** SQL Text Not Available ** |
| 8qyg4gs9k8w0b | SELECT MYYE, MYSRYE, MYBYY1, MYBYY2, MYBYY3, S_SCBS, S_JZSJ, S_YWSJ, MYJYSH, MYRQ, MYTGZH, MYZQDM FROM GT_MXYEB ORDER BY MYJYSH, MYRQ, MYTGZH, MYZQDM |
| 8zzhtsm1jh8vg | SELECT GT_YEDZB.YEKYYE AS YEKYYE, GT_YEDZB.YEZYYE AS YEZYYE, GT_YEDZB.YEDJYE AS YEDJYE, GT_YEDZB.YEDSYE AS YEDSYE, GT_YEDZB.YETDYE AS YETDYE, GT_YEDZB.YEZYE AS YEZYE, GT_YEDZB.YEBJYE AS YEBJYE, GT_YEDZB.YECE AS YECE, GT_YEDZB.S_SCBS AS S_SCBS, GT_YEDZB.S_YWSJ AS S_YWSJ, GT_YEDZB.S_JZSJ AS S_JZSJ, GT_YEDZB.YEJYSH AS YEJYSH, GT_YEDZB.YERQ AS YERQ, GT_YEDZB.YEZQDM AS YEZQDM FROM GT_YEDZB WHERE (GT_YEDZB.YERQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND GT_YEDZB.YERQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR GT_YEDZB.YERQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY YEJYSH, YERQ, YEZQDM, YEKYYE, YEZYYE, YEDJYE, YEDSYE, YETDYE, YEZYE, YEBJYE, YECE, S_SCBS, S_YWSJ, S_JZSJ |
| 92ucvzctw9jug |
SELECT ZJ_ZJCPLS.CPZJZH AS CPZJZH, ZJ_ZJCPLS.CPZMA AS CPZMA, ZJ_ZJCPLS.CPKMMA AS CPKMMA, ZJ_ZJCPLS.CPHBMA AS CPHBMA, ZJ_ZJCPLS.CPYHHA AS CPYHHA, ZJ_ZJCPLS.CPJYJE AS CPJYJE, ZJ_ZJCPLS.CPCZBJ AS CPCZBJ, ZJ_ZJCPLS.CPZYAO AS CPZYAO, ZJ_ZJCPLS.CPHUIL AS CPHUIL, ZJ_ZJCPLS.CPDEHB AS CPDEHB, ZJ_ZJCPLS.CPDEHJ AS CPDEHJ, ZJ_ZJCPLS.CPDYKM AS CPDYKM, ZJ_ZJCPLS.CPHTHA AS CPHTHA, ZJ_ZJCPLS.CPDQLS AS CPDQLS, ZJ_ZJCPLS.CPZFJL AS CPZFJL, ZJ_ZJCPLS.CPSQGY AS CPSQGY, ZJ_ZJCPLS.CPJYHH AS CPJYHH, ZJ_ZJCPLS.CPZHHH AS CPZHHH, ZJ_ZJCPLS.CPQSHH AS CPQSHH, ZJ_ZJCPLS.CPCPSF AS CPCPSF, ZJ_ZJCPLS.CPJLZT AS CPJLZT, ZJ_ZJCPLS.CPJLSJ AS CPJLSJ, ZJ_ZJCPLS.CPJYBJ AS CPJYBJ, ZJ_ZJCPLS.CPJDBJ AS CPJDBJ, ZJ_ZJCPLS.CPZHYE AS CPZHYE, ZJ_ZJCPLS.CPZQDM AS CPZQDM, ZJ_ZJCPLS.S_SCBS AS S_SCBS, ZJ_ZJCPLS.S_YWSJ AS S_YWSJ, ZJ_ZJCPLS.S_JZSJ AS S_JZSJ, ZJ_ZJCPLS.CPDCNS AS CPDCNS, ZJ_ZJCPLS.CPJLRQ AS CPJLRQ, ZJ_ZJCPLS.CPJYMA AS CPJYMA, ZJ_ZJCPLS.CPDCTS AS CPDCTS FROM ZJ_ZJCPLS WHERE (ZJ_ZJCPLS.CPJLRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND ZJ_ZJCPLS.CPJLRQ <= (SELECT TO_CHAR( END_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR ZJ_ZJCPLS.CPJLRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_
NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY CPDCNS, CPJLRQ, CPJYMA, CPDCTS, CPZJZH, CPZMA, CPKMMA, CPHBMA, CPYHHA, CPJYJE, CPCZBJ, CPZYAO, CPHUIL, CPDEHB, CPDEHJ, CPDYKM, CPHTHA, CPDQLS, CPZFJL, CPSQGY, CPJYHH, CPZHHH, CPQSHH, CPCPSF, CPJLZT, CPJLSJ, CPJYBJ, CPJDBJ, CPZHYE, CPZQDM, S_SCBS, S_YWSJ, S_JZSJ |
| 9n8xc314xdm0t |
insert into wrh$_shared_server_summary (snap_id, dbid, instance_number, num_samples, sample_time, sampled_total_conn, sampled_active_conn, sampled_total_srv, sampled_active_srv, sampled_total_disp, sampled_active_disp, srv_busy, srv_idle, srv_in_net, srv_out_net, srv_messages, srv_bytes, cq_wait, cq_totalq, dq_totalq) select :snap_id, :dbid, :instance_number, a.kmmsasnum, a.kmmsastime, a.kmmsastvc, a.kmmsasavc, a.kmmsastsrv, a.kmmsasasrv, a.kmmsastdisp, a.kmmsasadisp, s.busy, s.idle, s.in_net, s.out_net, s.messages, s.bytes, cq.wait, cq.totalq, dq.totalq from x$kmmsas a, (select sum(wait) as wait, sum(totalq) as totalq from v$queue where type = 'COMMON') cq, (select sum(busy) as busy, sum(idle) as idle, sum(in_net) as in_net, sum(out_net) as out_net, sum(messages) as messages, sum(bytes) as bytes from (select sum(busy) as busy, sum(idle) as idle, sum(in_net) as in_net, sum(out_net) as out_net, sum(messages) as messages, sum(bytes) as bytes from v$shared_server union select kmmhstsbsy, kmmhstsidl, kmmhstsneti, kmmhstsneto, kmmhstsnmg, kmmhstsnmb from x$kmmhst)) s, (select sum(totalq) as totalq from (select sum(totalq) as totalq from v$q
ueue where type = 'DISPATCHER' union select kmmhstdqtnc from x$kmmhst)) dq |
| ab3swhv5g138y |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY'
)) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob
j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj#
and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
| ak5crjygnpk60 | ** SQL Text Not Available ** |
| apubj18q5rdaa |
SELECT ZJ_ZJBJYD.YDWTRQ AS YDWTRQ, ZJ_ZJBJYD.YDJYLS AS YDJYLS, ZJ_ZJBJYD.YDJYMA AS YDJYMA, ZJ_ZJBJYD.YDYWZL AS YDYWZL, ZJ_ZJBJYD.YDYQQH AS YDYQQH, ZJ_ZJBJYD.YDDJXH AS YDDJXH, ZJ_ZJBJYD.YDJYXH AS YDJYXH, ZJ_ZJBJYD.YDYWLB AS YDYWLB, ZJ_ZJBJYD.YDFYZL AS YDFYZL, ZJ_ZJBJYD.YDFQZH AS YDFQZH, ZJ_ZJBJYD.YDFQFX AS YDFQFX, ZJ_ZJBJYD.YDFQJE AS YDFQJE, ZJ_ZJBJYD.YDSQZH AS YDSQZH, ZJ_ZJBJYD.YDSQFX AS YDSQFX, ZJ_ZJBJYD.YDSQJE AS YDSQJE, ZJ_ZJBJYD.YDJSZL AS YDJSZL, ZJ_ZJBJYD.YDJFBH AS YDJFBH, ZJ_ZJBJYD.YDHFBZ AS YDHFBZ, ZJ_ZJBJYD.YDJYLB AS YDJYLB, ZJ_ZJBJYD.YDHETH AS YDHETH, ZJ_ZJBJYD.YDHYMA AS YDHYMA, ZJ_ZJBJYD.YDHYXX AS YDHYXX, ZJ_ZJBJYD.YDJLZT AS YDJLZT, ZJ_ZJBJYD.YDJLRS AS YDJLRS, ZJ_ZJBJYD.S_JZSJ AS S_JZSJ, ZJ_ZJBJYD.S_SCBS AS S_SCBS, ZJ_ZJBJYD.S_YWSJ AS S_YWSJ, ZJ_ZJBJYD.YDQQHA AS YDQQHA FROM ZJ_ZJBJYD WHERE (ZJ_ZJBJYD.YDWTRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND ZJ_ZJBJYD.YDWTRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR ZJ_ZJBJYD.YDWTRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY YDQQHA, YDWTRQ, YDJYLS, YDJYMA, YDYWZL, YDYQQH, YDDJXH, YDJYXH, YDYWLB, YDFYZL, Y
DFQZH, YDFQFX, YDFQJE, YDSQZH, YDSQFX, YDSQJE, YDJSZL, YDJFBH, YDHFBZ, YDJYLB, YDHETH, YDHYMA, YDHYXX, YDJLZT, YDJLRS, S_JZSJ, S_SCBS, S_YWSJ |
| as8ubd7wvtrw3 |
SELECT ZJ_ZJWZLS.WZQQBH AS WZQQBH, ZJ_ZJWZLS.WZWTRQ AS WZWTRQ, ZJ_ZJWZLS.WZJYLS AS WZJYLS, ZJ_ZJWZLS.WZJYMA AS WZJYMA, ZJ_ZJWZLS.WZYWZL AS WZYWZL, ZJ_ZJWZLS.WZBWLX AS WZBWLX, ZJ_ZJWZLS.WZYWZL2 AS WZYWZL2, ZJ_ZJWZLS.WZYWZL3 AS WZYWZL3, ZJ_ZJWZLS.WZYJZL AS WZYJZL, ZJ_ZJWZLS.WZYJXH AS WZYJXH, ZJ_ZJWZLS.WZJYPC AS WZJYPC, ZJ_ZJWZLS.WZFQHH AS WZFQHH, ZJ_ZJWZLS.WZJSHH AS WZJSHH, ZJ_ZJWZLS.WZFHHH AS WZFHHH, ZJ_ZJWZLS.WZYHHH AS WZYHHH, ZJ_ZJWZLS.WZJJHH AS WZJJHH, ZJ_ZJWZLS.WZFKHH AS WZFKHH, ZJ_ZJWZLS.WZFKZH AS WZFKZH, ZJ_ZJWZLS.WZFKTG AS WZFKTG, ZJ_ZJWZLS.WZFKMC AS WZFKMC, ZJ_ZJWZLS.WZFKDZ AS WZFKDZ, ZJ_ZJWZLS.WZDJHH AS WZDJHH, ZJ_ZJWZLS.WZSKHH AS WZSKHH, ZJ_ZJWZLS.WZSKZH AS WZSKZH, ZJ_ZJWZLS.WZSKTG AS WZSKTG, ZJ_ZJWZLS.WZSKMC AS WZSKMC, ZJ_ZJWZLS.WZSKDZ AS WZSKDZ, ZJ_ZJWZLS.WZHBFH AS WZHBFH, ZJ_ZJWZLS.WZJE15 AS WZJE15, ZJ_ZJWZLS.WZJE17 AS WZJE17, ZJ_ZJWZLS.WZZQDM AS WZZQDM, ZJ_ZJWZLS.WZJSZL AS WZJSZL, ZJ_ZJWZLS.WZZQME AS WZZQME, ZJ_ZJWZLS.WZJJJE AS WZJJJE, ZJ_ZJWZLS.WZZQLX AS WZZQLX, ZJ_ZJWZLS.WZHGJS AS WZHGJS, ZJ_ZJWZLS.WZHGDQ AS WZHGDQ, ZJ_ZJWZLS.WZHGLX AS WZHGLX, ZJ_ZJWZLS.WZRZBJ AS WZRZBJ, ZJ_ZJWZLS.WZRZLX AS WZRZLX, ZJ_ZJWZLS.WZSQH AS WZSQH, ZJ_ZJWZLS.WZYSTQ AS WZYSTQ, ZJ_ZJWZLS.WZTHYD AS WZTHYD, ZJ_ZJWZLS.WZFY AS WZFY, ZJ_ZJWZLS.WZBWZT AS WZBWZT, ZJ_ZJWZLS.WZJLRS AS WZJLRS, ZJ_ZJWZLS.WZYWTRQ AS WZYWTRQ, ZJ_ZJWZLS.WZYBWLX AS WZYBWLX, ZJ_ZJWZLS.WZYFQHH AS WZYFQHH, ZJ_ZJWZLS.WZYYJXH
AS WZYYJXH, ZJ_ZJWZLS.WZYQQHA AS WZYQQHA, ZJ_ZJWZLS.S_JZSJ AS S_JZSJ, ZJ_ZJWZLS.S_SCBS AS S_SCBS, ZJ_ZJWZLS.S_YWSJ AS S_YWSJ, ZJ_ZJWZLS.WZQQHA AS WZQQHA FROM ZJ_ZJWZLS WHERE (ZJ_ZJWZLS.WZWTRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND ZJ_ZJWZLS.WZWTRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR ZJ_ZJWZLS.WZWTRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY WZQQHA, WZQQBH, WZWTRQ, WZJYLS, WZJYMA, WZYWZL, WZBWLX, WZYWZL2, WZYWZL3, WZYJZL, WZYJXH, WZJYPC, WZFQHH, WZJSHH, WZFHHH, WZYHHH, WZJJHH, WZFKHH, WZFKZH, WZFKTG, WZFKMC, WZFKDZ, WZDJHH, WZSKHH, WZSKZH, WZSKTG, WZSKMC, WZSKDZ, WZHBFH, WZJE15, WZJE17, WZZQDM, WZJSZL, WZZQME, WZJJJE, WZZQLX, WZHGJS, WZHGDQ, WZHGLX, WZRZBJ, WZRZLX, WZSQH, WZYSTQ, WZTHYD, WZFY, WZBWZT, WZJLRS, WZYWTRQ, WZYBWLX, WZYFQHH, WZYYJXH, WZYQQHA, S_JZSJ, S_SCBS, S_YWSJ |
| b2gnxm5z6r51n | lock table sys.col_usage$ in exclusive mode nowait |
| bn4b3vjw2mj3u |
SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s
chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR
BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1 |
| bsa0wjtftg3uw | select file# from file$ where ts#=:1 |
| c22pshh085h9u |
SELECT GT_YJQSB.QSRGME AS QSRGME, GT_YJQSB.QSRGBS AS QSRGBS, GT_YJQSB.QSMRME AS QSMRME, GT_YJQSB.QSMRBS AS QSMRBS, GT_YJQSB.QSMCME AS QSMCME, GT_YJQSB.QSMCBS AS QSMCBS, GT_YJQSB.QSMMJH AS QSMMJH, GT_YJQSB.QSMMJE AS QSMMJE, GT_YJQSB.QSHGME AS QSHGME, GT_YJQSB.QSHGBS AS QSHGBS, GT_YJQSB.QSSHME AS QSSHME, GT_YJQSB.QSSHBS AS QSSHBS, GT_YJQSB.QSHGJH AS QSHGJH, GT_YJQSB.QSHGJE AS QSHGJE, GT_YJQSB.QSJEFH AS QSJEFH, GT_YJQSB.QSJE AS QSJE, GT_YJQSB.QSGZFH AS QSGZFH, GT_YJQSB.QSGZME AS QSGZME, GT_YJQSB.QSLSH AS QSLSH, GT_YJQSB.QSFKBZ AS QSFKBZ, GT_YJQSB.S_YWSJ AS S_YWSJ, GT_YJQSB.S_SCBS AS S_SCBS, GT_YJQSB.S_JZSJ AS S_JZSJ, GT_YJQSB.QSRGJE AS QSRGJE, GT_YJQSB.QSMRJE AS QSMRJE, GT_YJQSB.QSMCJE AS QSMCJE, GT_YJQSB.QSHBJE AS QSHBJE, GT_YJQSB.QSSHJE AS QSSHJE, GT_YJQSB.QSJYSH AS QSJYSH, GT_YJQSB.QSZQDH AS QSZQDH, GT_YJQSB.QSRQ AS QSRQ FROM GT_YJQSB WHERE (GT_YJQSB.QSRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND GT_YJQSB.QSRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR GT_YJQSB.QSRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY QSJYSH, QSZQDH, QSRQ, QSRGME, QSRGBS, QSMR
ME, QSMRBS, QSMCME, QSMCBS, QSMMJH, QSMMJE, QSHGME, QSHGBS, QSSHME, QSSHBS, QSHGJH, QSHGJE, QSJEFH, QSJE, QSGZFH, QSGZME, QSLSH, QSFKBZ, S_YWSJ, S_SCBS, S_JZSJ, QSRGJE, QSMRJE, QSMCJE, QSHBJE, QSSHJE |
| c8gnrhxma4tas | SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1 |
| ch4y9zz79b9tv | begin sys.dbms_backup_restore.createRmanOutputRow( l0row_id => :l0row_id, l0row_stamp => :l0row_stamp, row_id => :row_id, row_stamp => :row_stamp, txt => :txt, sameline => :i_sameline); end; |
| ch6rbrp8b6t2q |
SELECT GT_JZLSB.JZJYSH AS JZJYSH, GT_JZLSB.JZZQDM AS JZZQDM, GT_JZLSB.JZKMH AS JZKMH, GT_JZLSB.JZZYDM AS JZZYDM, GT_JZLSB.JZQSH AS JZQSH, GT_JZLSB.JZDLZL AS JZDLZL, GT_JZLSB.JZZYZL AS JZZYZL, GT_JZLSB.JZHTXH AS JZHTXH, GT_JZLSB.JZFSBS AS JZFSBS, GT_JZLSB.JZSFME AS JZSFME, GT_JZLSB.JZFFME AS JZFFME, GT_JZLSB.JZBZ AS JZBZ, GT_JZLSB.JZFHBZ AS JZFHBZ, GT_JZLSB.JZSJ AS JZSJ, GT_JZLSB.JZCZY AS JZCZY, GT_JZLSB.JZFHY AS JZFHY, GT_JZLSB.JZMEMO AS JZMEMO, GT_JZLSB.JZBYY1 AS JZBYY1, GT_JZLSB.JZBYY2 AS JZBYY2, GT_JZLSB.JZBYY3 AS JZBYY3, GT_JZLSB.S_JZSJ AS S_JZSJ, GT_JZLSB.S_YWSJ AS S_YWSJ, GT_JZLSB.S_SCBS AS S_SCBS, GT_JZLSB.JZLSH AS JZLSH, GT_JZLSB.JZRQ AS JZRQ, GT_JZLSB.JZZLSH AS JZZLSH FROM GT_JZLSB WHERE (GT_JZLSB.JZRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND GT_JZLSB.JZRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR GT_JZLSB.JZRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY JZLSH, JZRQ, JZZLSH, JZJYSH, JZZQDM, JZKMH, JZZYDM, JZQSH, JZDLZL, JZZYZL, JZHTXH, JZFSBS, JZSFME, JZFFME, JZBZ, JZFHBZ, JZSJ, JZCZY, JZFHY, JZMEMO, JZBYY1, JZBYY2, JZBYY3, S_JZSJ, S_YWSJ, S_SCBS
|
| cktbhhas52hw4 | declare first boolean := FALSE; bhistoryRec dbms_rcvman.bhistoryRec_t; begin if (:first > 0) THEN first := TRUE; end if; dbms_rcvman.getDfBackupHistory( backedUpDev => :devtype, first => first, bhistoryRec => bhistoryRec, recentbackup => TRUE, doingCmd => :backup, keepTag => :tag, toDest1 => :todest1, toDest2 => :todest2, toDest3 => :todest3, toDest4 => :todest4 ); :fileno := bhistoryRec.dfNumber; :crescn := bhistoryRec.create_scn; :rlgscn := bhistoryRec.reset_scn; :rlgtime := bhistoryRec.reset_time; :nbackups := bhistoryRec.nbackups; :compTime := bhistoryRec.compTime; :ckpscn := bhistoryRec.ckp_scn; :pluginSCN := bhistoryRec.pluginSCN; :pluginRlgSCN := bhistoryRec.pluginRlgSCN; :pluginRlgTime := bhistoryRec.pluginRlgTime; end; |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| csnp95dz2r8ss | select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0 |
| d1d0zksfckbvz |
SELECT BJ_ZLFZB.LFZQDM AS LFZQDM, BJ_ZLFZB.LFZQJC AS LFZQJC, BJ_ZLFZB.LFZQME AS LFZQME, BJ_ZLFZB.LFZQJG AS LFZQJG, BJ_ZLFZB.LFZQBL AS LFZQBL, BJ_ZLFZB.LFBY1 AS LFBY1, BJ_ZLFZB.LFBY2 AS LFBY2, BJ_ZLFZB.LFQLBZ AS LFQLBZ, BJ_ZLFZB.LFYJLX AS LFYJLX, BJ_ZLFZB.LFYJXE AS LFYJXE, BJ_ZLFZB.LFGXSJ AS LFGXSJ, BJ_ZLFZB.S_JZSJ AS S_JZSJ, BJ_ZLFZB.S_SCBS AS S_SCBS, BJ_ZLFZB.S_YWSJ AS S_YWSJ, BJ_ZLFZB.LFCRBZ AS LFCRBZ, BJ_ZLFZB.LFZLBH AS LFZLBH, BJ_ZLFZB.LFZQSX AS LFZQSX, BJ_ZLFZB.LFZQXH AS LFZQXH FROM BJ_ZLFZB WHERE EXISTS (SELECT 1 FROM BJ_ZLCLB B WHERE B.ZLBH = BJ_ZLFZB.LFZLBH
AND ((B.ZLSJGR >= (SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
AND B.ZLSJGR <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
) OR B.ZLSJGR <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) )) ORDER BY LFCRBZ, LFZLBH, LFZQSX, LFZQXH, LFZQDM, LFZQJC, LFZQME, LFZQJG, LFZQBL, LFBY1, LFBY2, LFQLBZ, LFYJLX, LFYJXE, LFGXSJ, S_JZSJ, S_SCBS, S_YWSJ
|
| d44910zsqskn0 |
SELECT ZJ_ZJYELS.S_YWSJ AS S_YWSJ, ZJ_ZJYELS.S_SCBS AS S_SCBS, ZJ_ZJYELS.S_JZSJ AS S_JZSJ, ZJ_ZJYELS.LJJLRQ AS LJJLRQ, ZJ_ZJYELS.LJTGZH AS LJTGZH, ZJ_ZJYELS.LJHUOB AS LJHUOB, ZJ_ZJYELS.LJKMMA AS LJKMMA, ZJ_ZJYELS.LJZJZH AS LJZJZH, ZJ_ZJYELS.LJZMYE AS LJZMYE, ZJ_ZJYELS.LJYXYE AS LJYXYE, ZJ_ZJYELS.LJZHZT AS LJZHZT, ZJ_ZJYELS.LJRJFE AS LJRJFE, ZJ_ZJYELS.LJRDFE AS LJRDFE, ZJ_ZJYELS.LJRJFS AS LJRJFS, ZJ_ZJYELS.LJRDFS AS LJRDFS, ZJ_ZJYELS.LJYLJE AS LJYLJE, ZJ_ZJYELS.LJYLDE AS LJYLDE, ZJ_ZJYELS.LJYLJS AS LJYLJS, ZJ_ZJYELS.LJYLDS AS LJYLDS, ZJ_ZJYELS.LJNLJE AS LJNLJE, ZJ_ZJYELS.LJNLDE AS LJNLDE, ZJ_ZJYELS.LJNLJS AS LJNLJS, ZJ_ZJYELS.LJNLDS AS LJNLDS, ZJ_ZJYELS.LJJLZT AS LJJLZT, ZJ_ZJYELS.LJJFYE AS LJJFYE, ZJ_ZJYELS.LJDFYE AS LJDFYE FROM ZJ_ZJYELS WHERE (ZJ_ZJYELS.LJJLRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND ZJ_ZJYELS.LJJLRQ <= (SELECT TO_CHAR( END_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR ZJ_ZJYELS.LJJLRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYY-MM-DD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY LJJLRQ, LJTGZH, LJHUOB, LJKMMA, LJZJZH, LJZMYE, LJYXYE, LJZHZT, LJRJFE, LJRDFE, LJRJFS, LJRDFS, LJYLJE, LJYLDE, LJYLJS, LJYLDS, LJNLJE,
LJNLDE, LJNLJS, LJNLDS, LJJLZT, LJJFYE, LJDFYE, S_YWSJ, S_SCBS, S_JZSJ |
| d9cu9g4q8fd4n |
SELECT ZQ_ZQZJHF.HFHFBZ AS HFHFBZ, ZQ_ZQZJHF.S_YWSJ AS S_YWSJ, ZQ_ZQZJHF.HFFXZH AS HFFXZH, ZQ_ZQZJHF.HFFXQC AS HFFXQC, ZQ_ZQZJHF.HFFXJC AS HFFXJC, ZQ_ZQZJHF.HFKHQC AS HFKHQC, ZQ_ZQZJHF.HFKHJC AS HFKHJC, ZQ_ZQZJHF.HFYFJE AS HFYFJE, ZQ_ZQZJHF.HFSFJE AS HFSFJE, ZQ_ZQZJHF.HFYFME AS HFYFME, ZQ_ZQZJHF.HFSFME AS HFSFME, ZQ_ZQZJHF.HFSFDL AS HFSFDL, ZQ_ZQZJHF.HFZFRQ AS HFZFRQ, ZQ_ZQZJHF.HFJSBZ AS HFJSBZ, ZQ_ZQZJHF.HFBWXH AS HFBWXH, ZQ_ZQZJHF.HFZFXH AS HFZFXH, ZQ_ZQZJHF.HFHYBZ AS HFHYBZ, ZQ_ZQZJHF.HFHKRQ AS HFHKRQ, ZQ_ZQZJHF.HFSCRQ AS HFSCRQ, ZQ_ZQZJHF.HFBY1 AS HFBY1, ZQ_ZQZJHF.HFBY2 AS HFBY2, ZQ_ZQZJHF.HFCZY AS HFCZY, ZQ_ZQZJHF.HFFHY AS HFFHY, ZQ_ZQZJHF.HFGXSJ AS HFGXSJ, ZQ_ZQZJHF.S_JZSJ AS S_JZSJ, ZQ_ZQZJHF.S_SCBS AS S_SCBS, ZQ_ZQZJHF.HFFDCS AS HFFDCS, ZQ_ZQZJHF.HFTGZH AS HFTGZH, ZQ_ZQZJHF.HFTZLB AS HFTZLB, ZQ_ZQZJHF.HFZJLB AS HFZJLB, ZQ_ZQZJHF.HFZQDM AS HFZQDM, ZQ_ZQZJHF.HFZHLB AS HFZHLB, ZQ_ZQZJHF.HFJLZT AS HFJLZT FROM ZQ_ZQZJHF WHERE (ZQ_ZQZJHF.HFZFRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL2_DAY_OPAR')
AND ZQ_ZQZJHF.HFZFRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL2_DAY_OPAR')
) OR ZQ_ZQZJHF.HFZFRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZ
W_ZL2_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY HFFDCS, HFTGZH, HFTZLB, HFZJLB, HFZQDM, HFZHLB, HFJLZT, HFHFBZ, S_YWSJ, HFFXZH, HFFXQC, HFFXJC, HFKHQC, HFKHJC, HFYFJE, HFSFJE, HFYFME, HFSFME, HFSFDL, HFZFRQ, HFJSBZ, HFBWXH, HFZFXH, HFHYBZ, HFHKRQ, HFSCRQ, HFBY1, HFBY2, HFCZY, HFFHY, HFGXSJ, S_JZSJ, S_SCBS |
| dvfquazb718b3 | SELECT GT_MXLSB.MLSCRQ AS MLSCRQ, GT_MXLSB.MLYE AS MLYE, GT_MXLSB.MLBYY1 AS MLBYY1, GT_MXLSB.MLBYY2 AS MLBYY2, GT_MXLSB.MLBYY3 AS MLBYY3, GT_MXLSB.S_SCBS AS S_SCBS, GT_MXLSB.S_JZSJ AS S_JZSJ, GT_MXLSB.S_YWSJ AS S_YWSJ, GT_MXLSB.MLJYSH AS MLJYSH, GT_MXLSB.MLZQDM AS MLZQDM, GT_MXLSB.MLTGZH AS MLTGZH, GT_MXLSB.MLRQ AS MLRQ FROM GT_MXLSB WHERE (GT_MXLSB.MLRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
AND GT_MXLSB.MLRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR')
) OR GT_MXLSB.MLRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL5_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY MLJYSH, MLZQDM, MLTGZH, MLRQ, MLSCRQ, MLYE, MLBYY1, MLBYY2, MLBYY3, S_SCBS, S_JZSJ, S_YWSJ |
| f2p32kt88jssr | SELECT BJ_PZLSB.PZYWLB AS PZYWLB, BJ_PZLSB.PZZYXH AS PZZYXH, BJ_PZLSB.PZZQXH AS PZZQXH, BJ_PZLSB.PZFSE AS PZFSE, BJ_PZLSB.PZJZBZ AS PZJZBZ, BJ_PZLSB.PZJYRQ AS PZJYRQ, BJ_PZLSB.PZJYSJ AS PZJYSJ, BJ_PZLSB.PZKM AS PZKM, BJ_PZLSB.PZZH AS PZZH, BJ_PZLSB.PZJDFX AS PZJDFX, BJ_PZLSB.PZFLH AS PZFLH, BJ_PZLSB.PZHTH AS PZHTH, BJ_PZLSB.PZBZ AS PZBZ, BJ_PZLSB.PZLSJY AS PZLSJY, BJ_PZLSB.KJSXXH AS KJSXXH, BJ_PZLSB.S_SCBS AS S_SCBS, BJ_PZLSB.S_YWSJ AS S_YWSJ, BJ_PZLSB.S_JZSJ AS S_JZSJ, BJ_PZLSB.PZLSH AS PZLSH FROM BJ_PZLSB WHERE (BJ_PZLSB.PZJYRQ >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
AND BJ_PZLSB.PZJYRQ <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
) OR BJ_PZLSB.PZJYRQ <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY PZLSH, PZYWLB, PZZYXH, PZZQXH, PZFSE, PZJZBZ, PZJYRQ, PZJYSJ, PZKM, PZZH, PZJDFX, PZFLH, PZHTH, PZBZ, PZLSJY, KJSXXH, S_SCBS, S_YWSJ, S_JZSJ |
| f711myt0q6cma | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22) |
| fsbqktj5vw6n9 |
select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca
st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1 |
| fsw3j4wmcmwau |
SELECT BJ_YZRTZ.YRRRZH AS YRRRZH, BJ_YZRTZ.YRRCZH AS YRRCZH, BJ_YZRTZ.YRFSRQ AS YRFSRQ, BJ_YZRTZ.YRYWLB AS YRYWLB, BJ_YZRTZ.YRZQME AS YRZQME, BJ_YZRTZ.YRDQR AS YRDQR, BJ_YZRTZ.YRLL AS YRLL, BJ_YZRTZ.YRQXTZ AS YRQXTZ, BJ_YZRTZ.YRZHCS AS YRZHCS, BJ_YZRTZ.YRZQCS AS YRZQCS, BJ_YZRTZ.YRJQCS AS YRJQCS, BJ_YZRTZ.YRTZHT AS YRTZHT, BJ_YZRTZ.YRLB AS YRLB, BJ_YZRTZ.YRBY1 AS YRBY1, BJ_YZRTZ.YRBY2 AS YRBY2, BJ_YZRTZ.YRQLBZ AS YRQLBZ, BJ_YZRTZ.YRGXSJ AS YRGXSJ, BJ_YZRTZ.S_YWSJ AS S_YWSJ, BJ_YZRTZ.S_SCBS AS S_SCBS, BJ_YZRTZ.S_JZSJ AS S_JZSJ, BJ_YZRTZ.YRWC AS YRWC, BJ_YZRTZ.YRZQXH AS YRZQXH, BJ_YZRTZ.YRHTH AS YRHTH FROM BJ_YZRTZ WHERE EXISTS (SELECT 1 FROM BJ_HTCLB B WHERE B.HCHTH = BJ_YZRTZ.YRHTH
AND ((B.HCJGR >= (SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
AND B.HCJGR <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
) OR B.HCJGR <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) )) ORDER BY YRWC, YRZQXH, YRHTH, YRRRZH, YRRCZH, YRFSRQ, YRYWLB, YRZQME, YRDQR, YRLL, YRQXTZ, YRZHCS, YRZQCS, YRJQCS, YRTZHT, YRLB, YRBY1, YRBY2, YRQLBZ, YRGXSJ, S_YWSJ, S_SCBS, S_JZSJ
|
| g00cj285jmgsw | update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn |
| gdn3ysuyssf82 | SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1 |
| gqjgc8npbw5a3 |
SELECT BJ_HTCLB.HCLYZH AS HCLYZH, BJ_HTCLB.HCFQZH AS HCFQZH, BJ_HTCLB.HCFQJC AS HCFQJC, BJ_HTCLB.HCSQZH AS HCSQZH, BJ_HTCLB.HCSQJC AS HCSQJC, BJ_HTCLB.HCTYCJ AS HCTYCJ, BJ_HTCLB.HCYWLB AS HCYWLB, BJ_HTCLB.HCYWLM AS HCYWLM, BJ_HTCLB.HCJSFS AS HCJSFS, BJ_HTCLB.HCJSMS AS HCJSMS, BJ_HTCLB.HCFBXH AS HCFBXH, BJ_HTCLB.HCFBDM AS HCFBDM, BJ_HTCLB.HCFBJC AS HCFBJC, BJ_HTCLB.HCFBME AS HCFBME, BJ_HTCLB.HCFBZJ AS HCFBZJ, BJ_HTCLB.HCSBXH AS HCSBXH, BJ_HTCLB.HCSBDM AS HCSBDM, BJ_HTCLB.HCSBJC AS HCSBJC, BJ_HTCLB.HCSBME AS HCSBME, BJ_HTCLB.HCSBZJ AS HCSBZJ, BJ_HTCLB.HCMEXX AS HCMEXX, BJ_HTCLB.HCZQSM AS HCZQSM, BJ_HTCLB.HCZQZE AS HCZQZE, BJ_HTCLB.HCHTJE AS HCHTJE, BJ_HTCLB.HCHGLL AS HCHGLL, BJ_HTCLB.HCGYLL AS HCGYLL, BJ_HTCLB.HCJSJE AS HCJSJE, BJ_HTCLB.HCJGR AS HCJGR, BJ_HTCLB.HCZLBH AS HCZLBH, BJ_HTCLB.HCDYHH AS HCDYHH, BJ_HTCLB.HCDYZH AS HCDYZH, BJ_HTCLB.HCXDQR AS HCXDQR, BJ_HTCLB.HCFQZT AS HCFQZT, BJ_HTCLB.HCFBZQ AS HCFBZQ, BJ_HTCLB.HCSQZT AS HCSQZT, BJ_HTCLB.HCSBZQ AS HCSBZQ, BJ_HTCLB.HCZJZT AS HCZJZT, BJ_HTCLB.HCDJZT AS HCDJZT, BJ_HTCLB.HCGHSJ AS HCGHSJ, BJ_HTCLB.HCSBYY AS HCSBYY, BJ_HTCLB.HCZT AS HCZT, BJ_HTCLB.HCJYQR AS HCJYQR, BJ_HTCLB.HCBWXH AS HCBWXH, BJ_HTCLB.HCHYBZ AS HCHYBZ, BJ_HTCLB.HCSCSJ AS HCSCSJ, BJ_HTCLB.HCQTCS AS HCQTCS, BJ_HTCLB.HCZHCS AS HCZHCS, BJ_HTCLB.HCZLLY AS HCZLLY, BJ_HTCLB.HCBY1 AS HCBY1, BJ_HTCLB.HCBY2 AS HCBY2, BJ_HTCLB.HCQLBZ AS HCQLBZ, BJ_HTCLB.HCGXSJ AS HCGX
SJ, BJ_HTCLB.HCFBZT AS HCFBZT, BJ_HTCLB.HCSBZT AS HCSBZT, BJ_HTCLB.HCFBGD AS HCFBGD, BJ_HTCLB.HCSBGD AS HCSBGD, BJ_HTCLB.HCQDBZ AS HCQDBZ, BJ_HTCLB.S_JZSJ AS S_JZSJ, BJ_HTCLB.S_YWSJ AS S_YWSJ, BJ_HTCLB.S_SCBS AS S_SCBS, BJ_HTCLB.HCHTH AS HCHTH FROM BJ_HTCLB WHERE (BJ_HTCLB.HCJGR >=(SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
AND BJ_HTCLB.HCJGR <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR')
) OR BJ_HTCLB.HCJGR <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL1_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) ORDER BY HCHTH, HCLYZH, HCFQZH, HCFQJC, HCSQZH, HCSQJC, HCTYCJ, HCYWLB, HCYWLM, HCJSFS, HCJSMS, HCFBXH, HCFBDM, HCFBJC, HCFBME, HCFBZJ, HCSBXH, HCSBDM, HCSBJC, HCSBME, HCSBZJ, HCMEXX, HCZQSM, HCZQZE, HCHTJE, HCHGLL, HCGYLL, HCJSJE, HCJGR, HCZLBH, HCDYHH, HCDYZH, HCXDQR, HCFQZT, HCFBZQ, HCSQZT, HCSBZQ, HCZJZT, HCDJZT, HCGHSJ, HCSBYY, HCZT, HCJYQR, HCBWXH, HCHYBZ, HCSCSJ, HCQTCS, HCZHCS, HCZLLY, HCBY1, HCBY2, HCQLBZ, HCGXSJ, HCFBZT, HCSBZT, HCFBGD, HCSBGD, HCQDBZ, S_JZSJ, S_YWSJ, S_SCBS
|
| gs5ufxdsk02a8 | SELECT FX_CFTBMXB.TMTBW AS TMTBW, FX_CFTBMXB.TMNSYL AS TMNSYL, FX_CFTBMXB.TMTBSL AS TMTBSL, FX_CFTBMXB.TMMXBZ AS TMMXBZ, FX_CFTBMXB.TMHYXX AS TMHYXX, FX_CFTBMXB.TMLRR AS TMLRR, FX_CFTBMXB.TMFHR AS TMFHR, FX_CFTBMXB.TMKYSL AS TMKYSL, FX_CFTBMXB.TMBYY1 AS TMBYY1, FX_CFTBMXB.TMBYY2 AS TMBYY2, FX_CFTBMXB.TMBYY3 AS TMBYY3, FX_CFTBMXB.S_YWSJ AS S_YWSJ, FX_CFTBMXB.S_JZSJ AS S_JZSJ, FX_CFTBMXB.S_SCBS AS S_SCBS, FX_CFTBMXB.TMTBR AS TMTBR, FX_CFTBMXB.TMZBSH AS TMZBSH, FX_CFTBMXB.TMTBXH AS TMTBXH FROM FX_CFTBMXB WHERE EXISTS (SELECT 1 FROM FX_CFZBS B WHERE B.ZBSXH = FX_CFTBMXB.TMZBSH
AND ((B.ZBKSR >= (SELECT TO_CHAR(BEGIN_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL2_DAY_OPAR')
AND B.ZBKSR <= (SELECT TO_CHAR( END_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL2_DAY_OPAR')
) OR B.ZBKSR <= (SELECT TO_CHAR(CLEAR_DATE, 'YYYYMMDD') FROM WF_SRC_CTL WHERE FD_NAME='mapping_day_opds_ards' AND WF_NAME='WF_JYZW_ZL2_DAY_OPAR' AND CLEAR_FLAG = 1 AND STATUS = 0) )) ORDER BY TMTBR, TMZBSH, TMTBXH, TMTBW, TMNSYL, TMTBSL, TMMXBZ, TMHYXX, TMLRR, TMFHR, TMKYSL, TMBYY1, TMBYY2, TMBYY3, S_YWSJ, S_JZSJ, S_SCBS |