| SQL Id | SQL Text |
|---|
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 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) |
| 0w53c9wjyhk67 | select t.id, t.usercode, t.userpwd, t.username, t.siteid, t.mngBranch, t.disableFlag, t.startDate, t.endDate, t.isFinalUse, t.userType, t.moblenum, t.extusercode from t_sm_site_user t where t.delflag='0' and t.usercode=:1 |
| 2dybn8g7gacdu | SELECT T_BS_CONT_GRPAPP.id, T_BS_CONT_GRPAPP.contId, T_BS_CONT_GRPAPP.grpId, T_BS_CONT_GRPAPP.occClassCode, T_BS_CONT_GRPAPP.legalCode, T_BS_CONT_GRPAPP.corprep, T_BS_CONT_GRPAPP.contactPsn, T_BS_CONT_GRPAPP.psnCustComuAddr, T_BS_CONT_GRPAPP.psnPostCode, T_BS_CONT_GRPAPP.psnTelePhone, T_BS_CONT_GRPAPP.psnFax, T_BS_CONT_GRPAPP.psnEmailAddress, T_BS_CONT_GRPAPP.psnOccClassCode, T_BS_CONT_GRPAPP.psnOccType, T_BS_CONT_GRPAPP.psnCustNo, T_BS_CONT_GRPAPP.contactPsnIdNo, T_BS_CONT_GRPAPP.primContactWay, T_BS_CONT_GRPAPP.peoples, T_BS_CONT_GRPAPP.onWorkPeoples, T_BS_CONT_GRPAPP.contactMobile, T_BS_CONT_GRPAPP.version, T_BS_CONT_GRPAPP.delFlag, T_BS_CONT_GRPAPP.crtTime, T_BS_CONT_GRPAPP.updTime, T_BS_CONT_GRP.teamName, T_BS_CONT_GRP.certType, T_BS_CONT_GRP.certNo FROM T_BS_CONT_GRPAPP, T_BS_CONT_GRP WHERE T_BS_CONT_GRP.id =T_BS_CONT_GRPAPP.grpid and T_BS_CONT_GRP.DELFLAG ='0' and T_BS_CONT_GRPAPP.contId=:1 |
| 2gfn18pmshb2p | SELECT id, contId, polId, dutyId, insuYear, payIntv, mult, prem, amnt, version, delFlag, crtTime, updTime FROM T_BS_CONT_DUTY WHERE DELFLAG ='0' and contId = :1 |
| 2k51tqtt5cj5d |
SELECT T.id, T.productCode, T.productName, T.productType, T.cardCode, T.mngBranch, T.applApproveFlag, T.poolFlag, T.poolProportion, T.insurPeriod, T.insurPeriodUnit, T.specialPromise, T.productState, T.checkType, T.version, T.delFlag, T.crtTime, T.updTime, PU.id as puId, PU.puCode, PU.puName, PU.puProportion, T.insureType, T.remark, nvl((select 1 from T_PRD_CLAUSE PC WHERE PC.prdId=T.id and PC.delFlag='0' and rownum=1), 0) as hasClause, pg.Prttpletid , pg.doctype, p.tpletclass, p.prttype, pg.id pgId, Tag.tag, tag.id tagId FROM T_SM_SITE_PROD sitePrd LEFT JOIN T_PRD_PRODUCT T ON T.id = sitePrd.prodid LEFT JOIN T_PRD_POOLUNITINFO PU ON PU.prdId=T.id and PU.delFlag='0' left join T_PRD_REFTEMPLET PG ON T.id = PG.PRODUCTID and PG.DELFLAG='0' left join T_PRT_TEMPLETINFO P on Pg.Prttpletid=p.id and p.delflag='0' left join t_tag_use_info TG on T.id=TG.USEID and tg.delflag='0' left join t_tag_base_info Tag on Tg.Tagid=Tag.Id and tag.delflag='0' where sitePrd.siteID=:1 AND sitePrd.storeID=:2 AND
T.delFlag='0' ORDER BY T.id asc, PU.id asc |
| 2nszajb0qbyvp | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN wwv_flow_mail.push_queue(wwv_flow_platform.get_preference('SMTP_HOST_ADDRESS'), wwv_flow_platform.get_preference('SMTP_HOST_PORT')); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 317v5hnvvd49h |
UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LO
B', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat) |
| 32hbap2vtmf53 | select position#, sequence#, level#, argument, type#, charsetid, charsetform, properties, nvl(length, 0), nvl(precision#, 0), nvl(scale, 0), nvl(radix, 0), type_owner, type_name, type_subname, type_linkname, pls_type from argument$ where obj#=:1 and procedure#=:2 order by sequence# desc |
| 39m4sx9k63ba2 | select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# |
| 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 |
| 3vb0gsp27mcvm | SELECT T_BS_CONT_ISD.id, T_BS_CONT_ISD.contId, T_BS_CONT_ISD.custId, T_BS_CONT_ISD.IsdId, T_BS_CONT_ISD.IsdType, T_BS_CONT_ISD.IsdMid, T_BS_CONT_ISD.apprlt, T_BS_CONT_ISD.IsdAddr, T_BS_CONT_ISD.IsdPost, T_BS_CONT_ISD.IsdTel, T_BS_CONT_ISD.IsdMobile, T_BS_CONT_ISD.IsdEmail, T_BS_CONT_ISD.IsdProfCode, T_BS_CONT_ISD.IsdProfType, T_BS_CONT_ISD.IsdHealThnotice, T_BS_CONT_ISD.version, T_BS_CONT_ISD.delFlag, T_BS_CONT_ISD.crtTime, T_BS_CONT_ISD.updTime, T_BS_CONT_CUST.custName, T_BS_CONT_CUST.custSex, T_BS_CONT_CUST.custBirthday, T_BS_CONT_CUST.certType, T_BS_CONT_CUST.certNo FROM T_BS_CONT_ISD, T_BS_CONT_CUST WHERE T_BS_CONT_CUST.id=T_BS_CONT_ISD.custId and T_BS_CONT_ISD.contId = :1 |
| 44c8h21v4x42s | call ORACLE_OCM.MGMT_CONFIG.collect_config ( ) |
| 49s332uhbnsma | declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end; |
| 53txd0pcdmkhx | INSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12) |
| 572fbaj0fdw2b | select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options )) |
| 5gsrhhfvhu465 | select sofar, context, start_time from v$session_longops where (start_time > nvl(:1, sysdate-100) or start_time = nvl(:2, sysdate+100)) and sid = :3 and serial# = :4 and opname like 'RMAN:%' order by start_time desc, context desc |
| 5ms6rbzdnq16t | select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job |
| 5xnhn40m7fhxf | UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = :1 WHERE TRIGGER_NAME = :2 AND TRIGGER_GROUP = :3 AND TRIGGER_STATE = :4 |
| 61f2zhhu4hfcd | SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = :1 AND NEXT_FIRE_TIME < :2 AND (NEXT_FIRE_TIME >= :3) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC |
| 679x4qggryd2v | select smontabv.cnt, smontabv.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt, max(time_mp) time_mp from smon_scn_time) smontabv where smontab.scn = smontabv.scnmax |
| 6wm3n4d7bnddg |
SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGR
OUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WH
ERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC |
| 72cysbbbq91k7 | SELECT SUM(GETS), SUM(MISSES), COUNT(INSTANCE_NUMBER), SUM(INSTANCE_NUMBER) FROM DBA_HIST_LATCH WHERE SNAP_ID = :B3 AND DBID = :B2 AND INSTANCE_NUMBER MEMBER OF :B1 |
| 772s25v1y0x8k | select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice |
| 773s6najxhbp6 | select count(*) count from T_MBFE_SALEITEM a left join T_MBFE_SALEITEM_REP b on a.billcertino=b.billcertino where a.docCancelStatus=0 and ((a.identitytype is not null and a.insuredno is not null) or (b.identitytype is not null and b.insuredno is not null )) |
| 7s21ufnhxbuks | SELECT id, contId, puName, puPrem, version, delFlag, crtTime, updTime FROM T_BS_PU_INFO WHERE DELFLAG ='0' and contId = :1 |
| 85px9dq62dc0q |
INSERT /*+ APPEND LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time , session_id, session_serial#, session_type , flags , user_id , sql_id, sql_child_number, sql_opcode, force_matching_signature , top_level_sql_id, top_level_sql_opcode , sql_plan_hash_value, sql_plan_line_id , sql_plan_operation#, sql_plan_options# , sql_exec_id, sql_exec_start , plsql_entry_object_id, plsql_entry_subprogram_id , plsql_object_id, plsql_subprogram_id , qc_instance_id, qc_session_id, qc_session_serial#, px_flags , event_id, seq#, p1, p2, p3 , wait_time, time_waited , blocking_session, blocking_session_serial#, blocking_inst_id , current_obj#, current_file#, current_block#, current_row# , top_level_call#, consumer_group_id, xid, remote_instance#, time_mo
del , service_hash, program, module, action, client_id, machine, port, ecid , dbreplay_file_id, dbreplay_call_counter , tm_delta_time, tm_delta_cpu_time, tm_delta_db_time, delta_time, delta_read_io_requests, delta_write_io_requests, delta_read_io_bytes, delta_write_io_bytes, delta_interconnect_io_bytes, pga_allocated, temp_space_allocated ) (SELECT /*+ PARAM('_module_action_old_length', 0) */:snap_id, :dbid, :instance_number, a.sample_id, a.sample_time , a.session_id, a.session_serial#, a.session_type , decode(a.flags, 0, to_number(NULL), a.flags) , a.user_id , a.sql_id, a.sql_child_number, a.sql_opcode, a.force_matching_signature , a.top_level_sql_id, a.top_level_sql_opcode , a.sql_plan_hash_value, a.sql_plan_line_id , a.sql_plan_operation#, a.sql_plan_options# , a.sql_exec_id, a.sql_exec_start , a.plsql_entry_object_id, a.plsql_entry_subprogram_id , a.plsql_object_id, a.plsql_subprogram_id , a.qc_instance_id, a.qc_session_id, a.qc_s
ession_serial#, a.px_flags , a.event_id, a.seq#, a.p1, a.p2, a.p3 , a.wait_time, a.time_waited , a.blocking_session, a.blocking_session_serial#, a.blocking_inst_id , a.current_obj#, a.current_file#, a.current_block#, a.current_row# , a.top_level_call#, a.consumer_group_id, a.xid, a.remote_instance# , a.time_model , a.service_hash , substrb(a.program, 1, 64) , a.module, a.action, a.client_id, a.machine, a.port, a.ecid , a.dbreplay_file_id, a.dbreplay_call_counter , decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_cpu_time), decode(a.tm_delta_time, 0, to_number(null), a.tm_delta_db_time), decode(a.delta_time, 0, to_number(null), a.delta_time), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_requests, 0, to_number(null), a.delta_read_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_requests, 0, to_number(null), a.d
elta_write_io_requests)), decode(a.delta_time, 0, to_number(null), decode(a.delta_read_io_bytes, 0, to_number(null), a.delta_read_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_write_io_bytes, 0, to_number(null), a.delta_write_io_bytes)), decode(a.delta_time, 0, to_number(null), decode(a.delta_interconnect_io_bytes, 0, to_number(null), a.delta_interconnect_io_bytes)), decode(a.pga_allocated, 0, to_number(null), a.pga_allocated), decode(a.pga_allocated, 0, to_number(null), decode(a.temp_space_allocated, 0, to_number(null), a.temp_space_allocated)) FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (nlssort(h.is_awr_sample, 'nls_sort=BINARY') = nlssort('Y', 'nls_sort=BINARY')) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id and nlssort(a.need_awr_sample, 'nls_sort=BINARY') = nlssort('Y', 'nls_sort
=BINARY')) |
| 8bdj8sbdyn553 | Select sc.productname productName, Sum(sc.mult) mult from star_prd sc group by sc.productname order by sum(sc.mult) Desc |
| 8d193zy7hbcvn | select au_company.company_name as MNGBRANCHNAME from au_company where au_company.company_flag = :1 |
| 8f1sjvfxuup9w | select t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null |
| 8fycsdmnvn9z6 | SELECT COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE NEXT_FIRE_TIME < :1 AND ((TRIGGER_STATE = :2) OR (TRIGGER_STATE = :3)) |
| 8zayt7u0r6f0u | select * from T_BS_TRAVELACC where id = :1 |
| 9m82p8p2d7z84 |
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.nex
t_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.obj# 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.cla
ss_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.owner# = 0 and f.owner
# = 0 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.owner# = 0 and i.owner# = 0 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 |
| a02dc5j1st112 | SELECT T_BS_CONT_POL.id, T_BS_CONT_POL.contId, T_BS_CONT_POL.polId, T_BS_CONT_POL.insuYear, T_BS_CONT_POL.payIntv, T_BS_CONT_POL.mult, T_BS_CONT_POL.prem, T_BS_CONT_POL.amnt, T_BS_CONT_POL.version, T_BS_CONT_POL.delFlag, T_BS_CONT_POL.crtTime, T_BS_CONT_POL.updTime , T_PRD_POLICY.polcode, T_PRD_POLICY.chiefPolCode, T_PRD_POLICY.polNameChn FROM T_BS_CONT_POL, T_PRD_POLICY WHERE T_BS_CONT_POL.DELFLAG ='0' AND t_bs_cont_pol.polid = T_PRD_POLICY.id and T_PRD_POLICY.delflag ='0' and T_BS_CONT_POL.contId = :1 order by T_BS_CONT_POL.id asc |
| avc77as85uysx | SELECT T_BS_CONT.id, T_BS_CONT.prtNo, T_BS_CONT.contNo, T_BS_CONT.saleChnl, T_BS_CONT.manageCom, T_BS_CONT.storeCode, T_BS_CONT.contType, T_BS_CONT.linkTabId, T_BS_CONT.linkTabName, T_BS_CONT.siteCode, T_BS_CONT.productId, T_BS_CONT.appPeoples, T_BS_CONT.bnfPeoples, T_BS_CONT.insurePeoples, T_BS_CONT.grpName, T_BS_CONT.psnOccClassCode, T_BS_CONT.psnOccType, T_BS_CONT.disputedFlag, T_BS_CONT.payMode, T_BS_CONT.coValiDate, T_BS_CONT.insuYear, T_BS_CONT.payIntv, T_BS_CONT.mult, T_BS_CONT.prem, T_BS_CONT.amnt, T_BS_CONT.polApplyDate, T_BS_CONT.coInValiDate, T_BS_CONT.specDeal, T_BS_CONT.listFlag, T_BS_CONT.disputedContent, T_BS_CONT.operator, T_BS_CONT.state, T_BS_CONT.version, T_BS_CONT.delFlag, T_BS_CONT.crtTime, T_BS_CONT.updTime, T_BS_CONT.appType, T_BS_CONT.puSumPrem, T_BS_CONT.sumPrem, T_BS_CONT.coValiTime, T_BS_CONT.coInValiTime, T_BS_CONT.icNo FROM T_BS_CONT WHERE DELFLAG ='0' and id=:1 |
| aykvshm7zsabd | select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3' |
| bdcknv42zt7u7 | SELECT id, contId, storeId, code, value, result, orderNo, version, delFlag, crtTime, updTime FROM T_BS_CONT_HELDECLARE WHERE DELFLAG ='0' and contId = :1 |
| bm2pwrpcr8ru6 | select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size |
| 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.schedule_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 |
| bxkwuqyra0yqk | SELECT T_BS_CONT_BNF.id, T_BS_CONT_BNF.contId, T_BS_CONT_BNF.custId, T_BS_CONT_BNF.bnfId, T_BS_CONT_BNF.bnfAddr, T_BS_CONT_BNF.bnfPost, T_BS_CONT_BNF.bnfTel, T_BS_CONT_BNF.bnfMoble, T_BS_CONT_BNF.bnfEmail, T_BS_CONT_BNF.bnfIsdrlt, T_BS_CONT_BNF.version, T_BS_CONT_BNF.delFlag, T_BS_CONT_BNF.crtTime, T_BS_CONT_BNF.updTime, T_BS_CONT_CUST.custName, T_BS_CONT_CUST.custSex, T_BS_CONT_CUST.custBirthday, T_BS_CONT_CUST.certType, T_BS_CONT_CUST.certNo FROM T_BS_CONT_BNF, T_BS_CONT_CUST WHERE T_BS_CONT_CUST.id=T_BS_CONT_BNF.custId and T_BS_CONT_BNF.contId = :1 |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# |
| dayq182sk41ks | insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice |
| dp3wxhxnv70mw |
SELECT * FROM(SELECT A.*, rownum as rid FROM( select T_BS_CONT.id, T_BS_CONT.prtNo, T_BS_CONT.contNo, T_BS_CONT.saleChnl, T_BS_CONT.manageCom, T_BS_CONT.storeCode, T_BS_CONT.contType, T_BS_CONT.linkTabId, T_BS_CONT.linkTabName, T_BS_CONT.siteCode, T_BS_CONT.productId, T_BS_CONT.appPeoples, T_BS_CONT.bnfPeoples, T_BS_CONT.insurePeoples, T_BS_CONT.grpName, T_BS_CONT.psnOccClassCode, T_BS_CONT.psnOccType, T_BS_CONT.disputedFlag, T_BS_CONT.payMode, T_BS_CONT.coValiDate, T_BS_CONT.insuYear, T_BS_CONT.payIntv, T_BS_CONT.mult, T_BS_CONT.prem, T_BS_CONT.amnt, T_BS_CONT.polApplyDate, T_BS_CONT.coInValiDate, T_BS_CONT.specDeal, T_BS_CONT.listFlag, T_BS_CONT.disputedContent, T_BS_CONT.operator, T_BS_CONT.version, T_BS_CONT.delFlag, T_BS_CONT.crtTime, T_BS_CONT.updTime, T_BS_CONT.appType, T_BS_CONT.puSumPrem, T_BS_CONT.sumPrem, T_BS_CONT.coValiTime, T_BS_CONT.coInValiTime, T_BS_CONT.icNo, case when t_bs_cont.state='05' and (t_bs_cont.contno is not null or t_bs_cont.contno <>'') then 'sx' el
se t_bs_cont.state end state , prd.productcode, prd.productname, case when apptype = 1 then (select T_BS_CONT_CUST.CUSTNAME || '-' || T_BS_CONT_CUST.Certno from T_BS_CONT_ISD, T_BS_CONT_CUST where T_BS_CONT_ISD.CUSTID = T_BS_CONT_CUST.id and T_BS_CONT_ISD.Contid = t_bs_cont.id ) else (select to_char(insurePeoples) from dual) end other , case when linktabname='T_BS_TRAVELACC' then ( select traTeamNo from T_BS_TRAVELACC where t_bs_cont.linkTabId=T_BS_TRAVELACC.Id ) else( select to_char(doc.docno) from dual ) end docno , (select T_BS_CONT_CUST.CUSTNAME as custname from T_BS_CONT_ISD , T_BS_CONT_CUST where T_BS_CONT_ISD.CUSTID = T_BS_CONT_CUST.id and T_BS_CONT_ISD.Contid = t_bs_cont.id and T_BS_CONT_ISD.isdid='1') as isdCustName from t_bs_cont left join T_PRD_PRODUCT prd on t_bs_cont.productid = prd.Id left join t_doc_documentinf doc on t_bs_cont.id=doc.insurapplid WHERE 1=1 AND siteCode='23983204061001' and operator='2012320400600001017' order by crttime desc) A WHERE rownum<16) WHE
RE rid >0 |
| 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 |
| gcpj8av4kx6j2 |
select event_name , dbms_swrf_report_internal.to_1000s(total_waits) total_waits_str , substr(to_char(decode(to1, 0, to_number(NULL), 100* to1 /total_waits), '999.9MI'), 1, 5) to1 , substr(to_char(decode(to2, 0, to_number(NULL), 100* to2 /total_waits), '999.9MI'), 1, 5) to2 , substr(to_char(decode(to4, 0, to_number(NULL), 100* to4 /total_waits), '999.9MI'), 1, 5) to4 , substr(to_char(decode(to8, 0, to_number(NULL), 100* to8 /total_waits), '999.9MI'), 1, 5) to8 , substr(to_char(decode(to16, 0, to_number(NULL), 100* to16 /total_waits), '999.9MI'), 1, 5) to16 , substr(to_char(decode(to32, 0, to_number(NULL), 100* to32 /total_waits), '999.9MI'), 1, 5) to32 , substr(to_char(decode(to1024, 0, to_number(NULL), 100* to1024 /total_waits), '999.9MI'), 1, 5) to1024 , substr(to_char(decode(over, 0, to_number(NULL), 100* over /total_waits), '999.9MI'), 1, 5) over from (select h.event_name event_name , sum(h.wait_count) total_waits , sum(case when (h.wait_ti
me_milli = 1) then h.wait_count else 0 end) to1 , sum(case when (h.wait_time_milli = 2) then h.wait_count else 0 end) to2 , sum(case when (h.wait_time_milli = 4) then h.wait_count else 0 end) to4 , sum(case when (h.wait_time_milli = 8) then h.wait_count else 0 end) to8 , sum(case when (h.wait_time_milli = 16) then h.wait_count else 0 end) to16 , sum(case when (h.wait_time_milli = 32) then h.wait_count else 0 end) to32 , sum(case when (h.wait_time_milli between 64 and 1024) then h.wait_count else 0 end) to1024 , sum(case when (1024 < h.wait_time_milli) then h.wait_count else 0 end) over , decode(h.wait_class, 'Idle', 99, 0) idle from (select e.event_name, e.wait_class, e.wait_time_milli, e.wait_count - nvl(b.wait_count, 0) as wait_count from dba_hist_event_histogram b, dba_hist_event_histogram e where b.snap_id(+) = :bid and e.snap_id = :eid and b.dbid(+) = :dbid and e.dbid = :dbid and b.instance_number(+) = :inst_num and e.instance_number = :inst_num and b.event_id(+
) = e.event_id and b.wait_time_milli(+) = e.wait_time_milli and e.wait_count > nvl(b.wait_count, 0) ) h group by h.event_name , decode(h.wait_class, 'Idle', 99, 0)) order by idle, event_name |
| gf87bnxzf9raf |
select db.version_time, db.controlfile_change#, db.controlfile_sequence#, dbinc.resetlogs_time, df.last_recid, tf.last_recid, ts.last_recid, rl.last_recid, rm.last_recid, dc.last_recid, al.last_recid, bp.last_recid, do.last_recid, offr.last_recid, pc.last_recid, bs.last_recid, ldbinc.resetlogs_change#, ldbinc.resetlogs_time, ic.last_recid, rt.last_recid, grsp.last_recid, nrsp.last_recid, bcr.last_recid, decode(dc.records_used, 0, 0, dc.last_recid - dc.records_used + 1), decode(al.records_used, 0, 0, al.last_recid - al.records_used + 1), decode(bp.records_used, 0, 0, bp.last_recid - bp.records_used + 1), decode(bs.records_used, 0, 0, bs.last_recid - bs.records_used + 1), decode(do.records_used, 0, 0, do.last_recid - do.records_used + 1), decode(offr.records_used, 0, 0, offr.last_recid - offr.records_used + 1), decode(pc.records_used, 0, 0, pc.last_recid - pc.records_used + 1)into :vertime, :cfscn, :cfseq, :rltime, :dfhwm, :tfhwm, :
tshwm, :rlhwm, :rmhwm, :dchwm, :alhwm, :bphwm, :dohwm, :offrhwm, :pchwm, :bshwm, :lrstscn, :lrsttime, :ichwm, :rthwm, :grsphwm, :nrsphwm, :bcrhwm, :dclwm, :allwm, :bplwm, :bslwm, :dolwm, :offrlwm, :pclwm from v$database db, v$controlfile_record_section df, v$controlfile_record_section tf, v$controlfile_record_section ts, v$controlfile_record_section rt, v$controlfile_record_section rl, v$controlfile_record_section rm, v$controlfile_record_section dc, v$controlfile_record_section al, v$controlfile_record_section bp, v$controlfile_record_section do, v$controlfile_record_section offr, v$controlfile_record_section pc, v$controlfile_record_section bs, v$controlfile_record_section ic, v$controlfile_record_section grsp, v$controlfile_record_section nrsp, v$controlfile_record_section bcr, v$database_incarnation dbinc, v$database_incarnation ldbinc where df.type = 'DATAFILE' and tf.type = 'TEMPORARY FILENAME' and ts.type = 'TABLESPACE' and rt.type = 'RE
DO THREAD' and rl.type = 'REDO LOG' and rm.type = 'RMAN CONFIGURATION' and dc.type = 'DATAFILE COPY' and al.type = 'ARCHIVED LOG' and bp.type = 'BACKUP PIECE' and do.type = 'DELETED OBJECT' and offr.type = 'OFFLINE RANGE' and pc.type = 'PROXY COPY' and bs.type = 'BACKUP SET' and ic.type = 'DATABASE INCARNATION' and grsp.type = 'GUARANTEED RESTORE POINT' and nrsp.type = 'RESTORE POINT' and bcr.type = 'DATABASE BLOCK CORRUPTION' and dbinc.incarnation#=db.recovery_target_incarnation# and ldbinc.incarnation#=db.last_open_incarnation# |
| grwydz59pu6mc | select text from view$ where rowid=:1 |