SQL Id | SQL Text |
0khbp2znt4394 | select tablespace_name, status from dba_tablespaces |
0u3a2gth3r9vw | select sum(bytes)/1024 from DBA_FREE_SPACE |
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') |
12kbqx41uwvdn | select sSubscriberID, sSubscriberNumber, sMainType, sUserType, sUserSort
, sUserState, sServiceActiveFlag, sActiveRoute, sActiveType, nSingleMain
, sBarringFlag, sFeeType, sChargeAccount, sSameCallFlag
from TOTO WHERE sSubscriberID=:sSubscriberID |
1c88bzqws4ga5 | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615359107092' |
1fw5q7qt5q4kb | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615395994089' |
1gfaj4z5hn1kf | delete from dependency$ where d_obj#=:1 |
1gu8t96d0bdmu | select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) |
1qy8g4tp3gxfy | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615306057355' |
20az9juxuc2xm | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615345977023' |
3972rvxu3knn3 | delete from sdo_geor_ddl__table$$ |
3arkx25br7r04 | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615359013429' |
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 |
3uhm3u5jynbak | select sql_text from (select sql_text from v$sqlarea where disk_reads > 5000 * executions order by executions desc) where rownum<6 |
41nh2c90gr1k0 | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615375910786' |
424h0nf7bhqzd |
SELECT sqlset_row(sql_id, force_matching_signature, sql_text, object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, priority, command_type, first_load_time, stat_period, active_stat_period, other, plan_hash_value, sql_plan, bind_list) FROM ( SELECT /*+ first_rows(1) */ sql_id, force_matching_signature, sql_text, cast(NULL as SQL_OBJECTS) object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, NULL priority, command_type, NULL first_load_time, null stat_period, null active_stat_period, xmlelement(
"other_attrs",
xmlelement("parsing_user_id",
parsing_user_id)).getClobVal() other, plan_hash_value, cast(NULL as SQL_PLAN_TABLE_TYPE) sql_plan, cast (NULL as SQL_BINDS) bind_list FROM ((SELECT
t1.sql_id, t1.force_matching_signature, sql_text, module, action,
selap as ELAPSED_TIME, scpu as CPU_TIME, sbgets as BUFFER_GETS,
swrites as DIRECT_WRITES,
sdreads as DISK_READS, srow as ROWS_PROCESSED, sfetches as fetch
es,
sexec as EXECUTIONS, seofc as end_of_fetch_count, optimizer_cost,
optimizer_env, command_type, parsing_schema_name, parsing_user_id,
T1.snap_id, T1.plan_hash_value, T1.dbid, loaded_versions, bind_data
FROM (SELECT sql_id, force_matching_signature, action, module, snap_id,
dbid, loaded_versions, instance_number,
sql_text, command_type, optimizer_env, bind_data,
parsing_schema_name, parsing_user_id, plan_hash_value,
optimizer_cost
FROM (SELECT s.snap_id, s.dbid, s.instance_number,
s.sql_id, s.force_matching_signature, sql_text, t.command_type,
module, action, fetches_delta as FETCHES,
executions_delta as EXECUTIONS,
end_of_fetch_count_delta as END_OF_FETCH_COUNT,
disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES,
buffer_gets_delta as BUFFER_GETS,
optimizer_env, rows_processed_delta as ROWS_PROCESSED,
cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME,
optimizer_cost, s.parsing_schema_name, s.parsing_user_id,
plan_hash_value, loaded_versions, bind_data
FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t,
DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d
WHERE s.sql_id = t.sql_id and s.dbid = t.d
bid and
s.dbid = e.dbid(+) and
s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and
s.dbid = d.dbid and
/* only capture sqls with the full set of execution stats */
bitand(nvl(s.flag, 0), 1) = 0)) T1,
(SELECT sql_id, plan_hash_value,
sum(CPU_TIME) AS scpu,
sum(BUFFER_GETS) AS sbgets,
sum(DISK_READS) AS sdreads,
sum(DIRECT_WRITES) AS swrites,
sum(ROWS_PROCESSED) AS srow,
sum(FETCHES) AS sfetches,
sum(EXECUTIONS) AS sexec,
sum(END_OF_FETCH_COUNT) AS seofc,
sum(ELAPSED_TIME) AS selap,
MAX(SNAP_ID) KEEP (DENSE_RANK LAST
ORDER BY ELAPSED_TIME) AS snap_id,
MAX(INSTANCE_NUMBER) KEEP (DENSE_RANK LAST
ORDER BY ELAPSED_TIME) AS instance_number
FROM (SELECT s.snap_id, s.dbid, s.instance_number,
s.sql_id, s.force_matching_signature, sql_text, t.command_type,
module, action, fetches_delta as FETCHES,
executions_delta as EXECUTIONS,
end_of_fetch_count_delta as END_OF_FETCH_COUNT,
disk_reads_delta AS DISK_READS, direct_writes_delta DIRECT_WRITES,
buffer_gets_delta as BUFFER_GETS,
optimizer_env, row
s_processed_delta as ROWS_PROCESSED,
cpu_time_delta as CPU_TIME, elapsed_time_delta as ELAPSED_TIME,
optimizer_cost, s.parsing_schema_name, s.parsing_user_id,
plan_hash_value, loaded_versions, bind_data
FROM DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t,
DBA_HIST_OPTIMIZER_ENV e, V$DATABASE d
WHERE s.sql_id = t.sql_id and s.dbid = t.dbid and
s.dbid = e.dbid(+) and
s.optimizer_env_hash_value = e.optimizer_env_hash_value(+) and
s.dbid = d.dbid and
/* only capture sqls with the full set of execution stats */
bitand(nvl(s.flag, 0), 1) = 0) WHERE snap_id >= :begin_snap and
snap_id <= :end_snap AND command_type in (1, 2, 3, 6, 7, 189) AND sql_id = :sqlid AND plan_hash_value = :phv GROUP BY sql_id, plan_hash_value) T2
WHERE T1.sql_id = T2.sql_id AND
T1.plan_hash_value = T2.plan_hash_value AND
T1.snap_id = T2.snap_id AND
T1.instance_number = T2.instance_number)) S ) |
459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
49p14jx65u179 | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618059321318' |
4f2m73y9bbjk4 | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615306971679' |
4s52ca35p6gvc | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618960806108' |
520mkxqpf15q8 | select 1 from dual |
59d21tvx4xn3q | update user$ set name=:2, password=:3, datats#=:4, tempts#=:5, type#=:6, defrole=:7, resource$=:8, ptime=DECODE(to_char(:9, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :9), exptime=DECODE(to_char(:10, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :10), ltime=DECODE(to_char(:11, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :11), astatus=:12, lcount=:13, defschclass=:14, spare1=:15, spare4=:16 where user#=:1 |
59p216atzcyfh | select sql_text from (select sql_text from v$sqlarea order by loads desc) where rownum<6 |
5ungsgg5wj7cd | delete from
TOTO_ASSOCIATEDNUM
where
SSUBSCRIBERID = :0 |
6ajkhukk78nsr | begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end; |
6b6qaxupcs4kf | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8613358209016' |
6jbrg916bjmqc | DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; BEGIN DECLARE
ename VARCHAR2(30);
BEGIN
ename := dbms_sqltune.execute_tuning_task(
'SYS_AUTO_SQL_TUNING_TASK');
END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
6kqztxmbnwzht | update TOTO
set
sSubscriberNumber = :0
where
sSubscriberNumber = :1 |
6mcpb06rctk0x | call dbms_space.auto_space_advisor_job_proc ( ) |
6s2jxg0nq736d | delete from TOTOla
where 1=1
and subscriberID = :0 |
6v3dub2363sa5 | select name, open_mode from v$database |
6yj7zd66pd0ff | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618020636076' |
71czant8wzc1g | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618950322153' |
7bdgxpmaqxx89 | update TOTO
set
sSubscriberid = :0
, sUserState = :1
, sActiveType = :2
, nSingleMain = :3
, sActiveRoute = :4
, SCHARGEACCOUNT = :5
where
sSubscriberNumber = :6 |
7br6xgmpmhukc | Select sScreenNumber, sScreenType, sScreenFlow from R_BWList_SubscriberBWList
where nServiceID =:nServiceID
and sSubscriberNumber=:sSubscriberNumber
and sSubscriberNumType=:sSubscriberNumType
and sScreenNumber=:sScreenNumber
and sScreenNumberType=:sScreenNumberType
and sScreenType=:sScreenType
and (sScreenFlow=:sScreenFlow or sScreenFlow=0)
and sSPID=:sSPID
and sMatchType=0
and rownum =1 |
7ng34ruy5awxq | select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# |
803u6vwz0ah1p |
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 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 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 |
8ghxkaspgqdag |
select sql_id, plan_hash_value, bucket_id, begin_snap, end_snap from (select dbid, sql_id, bucket_id, plan_hash_value, begin_snap, end_snap, cpu_plus_io from (select dbid, sql_id, bucket_id, plan_hash_value, begin_snap, end_snap, cpu_plus_io, row_number() over (partition by bucket_id order by cpu_plus_io desc) as within_bucket_rnk from (select dbid, sql_id, bucket_id, max(plan_hash_value) keep (dense_rank last order by cpu_plus_io) plan_hash_value, max(begin_snap) keep (dense_rank last order by cpu_plus_io) begin_snap, max(end_snap) keep (dense_rank last order by cpu_plus_io) end_snap, max(cpu_plus_io) cpu_plus_io from (select dbid, sql_id, plan_hash_value, begin_snap, end_snap, bucket_id, cpu_time + buffer_gets * 10000 as cpu_plus_io from (select dbid, begin_snap, end_snap, sql_id, plan_hash_value, case when bucket_id = 0 then cpu_time / executions else cpu_time end as cpu_time, case when bucket_id
= 0 then buffer_gets / executions else buffer_gets end as buffer_gets, bucket_id from (select dbid, min(snap_id) begin_snap, max(snap_id) end_snap, sql_id, plan_hash_value, sum(cpu_time) cpu_time, sum(buffer_gets) buffer_gets, decode(sum(executions), 0, 1, sum(executions)) executions, decode(grouping_id(snap_id, hour_id, day_id), 3, 0, 5, 1, 6, 2, 3) bucket_id from (select f.dbid, f.snap_id, sql_id, plan_hash_value, to_number(to_char(begin_interval_time + 0, 'DDD')) day_id, (to_number(to_char(begin_interval_time + 0, 'DDD')) - 1)*24 + to_number(to_char(begin_interval_time + 0, 'HH24')) hour_id, cpu_time, buffer_gets, executions from (select v1.* from ( select snap_id, dbid, min_inst_num, sql_id, plan_hash_value, cpu_time, buffer_gets, executions from (select snap_id, dbid, min_inst_num, sql_id, plan_hash_value, cpu_time, buffer_gets, executions, row_number() over(partition by dbid, snap_id order by(cpu_time + buffer_gets * 10000) desc) as within_snap_rnk from (select /*+ cardinality(d 1) */ sq.dbid, sq.snap_id, min(sq.instance_number) min_inst_num, sq.sql_id,
plan_hash_value, sum(cpu_time_delta) cpu_time, sum(buffer_gets_delta) buffer_gets, sum(executions_delta) executions from dba_hist_sqlstat sq, v$database d, dba_hist_sqltext st where sq.dbid = d.dbid and st.dbid = sq.dbid and st.sql_id = sq.sql_id and sq.snap_id between :bid and :eid and st.command_type in (3) and bitand(nvl(sq.flag, 0), 1) = 0 group by sq.dbid, sq.snap_id, sq.sql_id, plan_hash_value)) where within_snap_rnk <= 150 ) v1, (select sq.sql_id from dba_hist_sqlstat sq, v$database d where sq.dbid = d.dbid and sq.snap_id between :bid and :eid group by sq.dbid, sq.sql_id having sum(nvl(executions_delta, 0)) >= 2) v2 where v1.sql_id = v2.sql_id) f, dba_hist_snapshot s where f.snap_id = s.snap_id and f.dbid = s.dbid and s.instance_number = f.min_inst_num) group by grouping sets ((dbid, sql_id, plan_hash_value, snap_id), (dbid, sql_id, plan_hash_value, day_id), (dbid, sql_id, plan_hash_value, hour_id), (dbid, sql_id, plan_hash_value))))) group by dbid, sql_id, bucket_id) where cpu_plus_io >= decode(bucket_id, 0, (10 * 1000000), 1, (60
* 1000000), 2, (240 * 1000000), (480 * 1000000)))where within_bucket_rnk <= 150) order by bucket_id asc, cpu_plus_io desc |
96g93hntrzjtr | select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 |
99xa2xfxq7xmc | select * from (select event, count(*) from v$session_wait group by event order by count(*) desc) where rownum < 6 |
9c3wpx57j8s48 | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8615359113379' |
9cbrztp2kuyth | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8613328952025' |
9f559qjupqp79 |
SELECT dtp.tablespace_name , dtp.status , dtp.contents , dtp.extent_management , dtp.allocation_type , dtp.logging , '' , dtp.initial_extent , dtp.next_extent , dtp.pct_increase , dtp.max_extents , '', dtp.min_extents, dtp.min_extlen, dtp.segment_space_management , dtp.block_size, dtp.bigfile FROM sys.dba_tablespaces dtp, (SELECT tablespace_name, sum(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) ts, (SELECT tablespace_name, sum(bytes) bytes from dba_free_space GROUP BY tablespace_name) f WHERE dtp.tablespace_name = ts.tablespace_name (+) AND dtp.tablespace_name = f.tablespace_name (+) AND NOT (dtp.extent_management LIKE 'LOCAL' AND dtp.contents LIKE 'TEMPORARY') UNION ALL SELECT dtp.tablespace_name , dtp.status , dtp.contents , dtp.extent_management , dtp.allocation_type , dtp.logging , '', dtp.initial_extent , dtp.next_extent , dtp.pct_increase , dtp.max_extents , '', dtp.min_extents, dtp.min_extlen, dtp.segment_space_management , dtp.block_size, dtp.bigfile FROM sys.dba_t
ablespaces dtp, (SELECT tablespace_name, sum(bytes) bytes FROM dba_temp_files GROUP BY tablespace_name) a, (select ss.tablespace_name , sum((ss.used_blocks*ts.blocksize)) bytes from gv$sort_segment ss, sys.ts$ ts where ss.tablespace_name = ts.name group by ss.tablespace_name) t WHERE dtp.tablespace_name = a.tablespace_name (+) AND dtp.tablespace_name = t.tablespace_name (+) AND dtp.extent_management LIKE 'LOCAL' AND dtp.contents LIKE 'TEMPORARY' |
9q741698yf7f7 | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618060306888' |
9r80g3qtwjdwr | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618159931791' |
9tgj4g8y4rwy8 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
a5ks9fhw2v9s1 | select * from dual |
a6u3yjca29nqc | declare
m_stmt varchar2(512);
begin
m_stmt:='delete from sdo_geor_ddl__table$$';
EXECUTE IMMEDIATE m_stmt;
EXCEPTION
WHEN OTHERS THEN
NULL;
end; |
b5vd6xtzncv5v |
MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN STALENESS > LOG(0.01, NVL(LOC_STALE_PCT, :B1 )/100) THEN 128 ELSE 0 END + AFLAGS AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL) WHEN S.TYPE# = 5 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND BITAND
(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O.FLAGS, 128) != 128 AND BITAND(T.PROPERTY, 2147483648) = 0 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME = 'SUMDELTA$') AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMEN
T_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1),
-100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL) * :B6 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) ) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01,
NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 34 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(
M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, SYS.OPTSTAT_USER_PREFS$ P, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T.ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(CM.BOBJ#, :B10 ) IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAG
S, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * CM.ROWCNT))) AND CM.LOCKED = 0 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL) WHEN S.TYPE# = 6 THEN DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS) ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND I.TYPE# = 4 AND I.BO# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE#(+) AND I.BLOCK# = S.BLOCK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BIT
AND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(TP.ROWCNT, (TP.ROWCNT + M.INSERTS - M.DELETES)))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_SPACE_ADMIN.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS) * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OPTSTAT_USER_PREFS$ P WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND O
T.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B2 ) <> 0) AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER
# = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.PART# PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B7 ) <> 0) AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.SUBPART# PART#, I.POBJ# BO#, NULL LOC_STALE_PCT FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(IND.BO#, :B10 ) IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE
_GRANULARITY(IND.BO#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLAGS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0, ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B5 , :B4 , NEW.PART#, NEW.BO#) |
b6usrg82hwsa3 | call dbms_stats.gather_database_stats_job_proc ( ) |
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 |
byzbk6f5n4upz | select sql_text from (select sql_text from v$sqlarea where buffer_gets > 5000 * executions order by executions desc) where rownum<6 |
cd74yg75x2fu2 | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618046061557' |
d2nmbb77yzhm5 | DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; BEGIN BEGIN ORACLE_OCM.MGMT_DB_LL_METRICS.collect_config_metrics('ORACLE_OCM_CONFIG_DIR'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
d98d5kh4u6ufx | select o.sid, o.user_name, osuser, machine, count(*) num_curs from v$open_cursor o, v$session s where o.sid=s.sid group by o.sid, o.user_name, osuser, machine order by o.user_name desc |
dckagq5arxva5 | delete from
t_bme_subscriber
where
resourceNumber = :0 |
dmkz69q5nr108 | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618950331289' |
du3npcpzq82sp | select sSubscriberID, sSubscriberNumber, sAssociatedNum1, sAssociatedNum2, sAssociatedNum3, sAssociatedNum4,
sAssociatedNum5, sAssociatedNum6, sAssociatedNum7, sAssociatedNum8,
sAssociatedNum9, sAssociatedNum10, sAssociatedNumTypeList, sActiveFlagList
from TOTO_AssociatedNum
WHERE sAssociatedNum1 =:sAssociatedNum1 OR
sAssociatedNum2 =:sAssociatedNum2 OR
sAssociatedNum3 =:sAssociatedNum3 OR
sAssociatedNum4 =:sAssociatedNum4 OR
sAssociatedNum5 =:sAssociatedNum5 OR
sAssociatedNum6 =:sAssociatedNum6 OR
sAssociatedNum7 =:sAssociatedNum7 OR
sAssociatedNum8 =:sAssociatedNum8 OR
sAssociatedNum9 =:sAssociatedNum9 OR
sAssociatedNum10 =:sAssociatedNum10 |
f25b2uq9782hs | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8618960985622' |
fg9xkrrvss5h9 | select SUBSCRIBERID, RESOURCENUMBER, NUMBERTYPE, LANGUAGE, AREAID, SUBSCRIBERSTATUS, PASSWORD, ACCOUNTTYPE, ICCID, IMSI, HLRID, SERVICEPROVIDER, REW_OPT_GROUP, CREATEDATE, CREATEOPERID, UPDATEDATE, UPDATEOPERID from T_BME_SUBSCRIBER where rownum < 2 and RESOURCENUMBER = '8613328292207' |
g278wv0zzpn5j | select unique objn from ((select objn from SYS_MFBA_STAGE_RID) union all (select d.objn "OBJN" from SYS_FBA_DL d, SYS_MFBA_TRACKED_TXN t where (d.usn=t.usn) and (d.slot = t.slot))) |