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 F1 WHERE sSubscriberID=:sSubscriberID |
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# (+) |
2y7qjmt522cxk | 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 = '8618960645348' |
3972rvxu3knn3 | delete from sdo_geor_ddl__table$$ |
3uhm3u5jynbak | select sql_text from (select sql_text from v$sqlarea where disk_reads > 5000 * executions order by executions desc) where rownum<6 |
43ruajmwv9fus | insert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue)values(:1, :2, :3, :4, :5, :6, :7) |
459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
47fh8q7arykp9 | select tablespace_name , sum(bytes)/1024 bytes from dba_free_space group by tablespace_name |
4y1y43113gv8f | delete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 |
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
R_BIND_ASSOCIATEDNUM
where
SSUBSCRIBERID = :0 |
63kf3an2j0pkc | insert into sys.wri$_optstat_histgrm_history (obj#, intcol#, savtime, bucket, endpoint, epvalue, colname) select hg.obj#, hg.intcol#, :3, hg.bucket, hg.endpoint, hg.epvalue, :4 from sys.histgrm$ hg where hg.obj# = :1 and hg.intcol# = :2 |
6ajkhukk78nsr | begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end; |
6kqztxmbnwzht | update F1
set
sSubscriberNumber = :0
where
sSubscriberNumber = :1 |
6s2jxg0nq736d | delete from F2la
where 1=1
and subscriberID = :0 |
6v3dub2363sa5 | select name, open_mode from v$database |
7bdgxpmaqxx89 | update F1
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 |
8szmwam7fysa3 | insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE')) |
8wyymnrxrudgd | 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 = '8615375915431' |
8xgd2r1h0kr34 | insert into wri$_adv_sqlt_plans (statement_id, timestamp, operation, options, object_node, object_owner, object_name, object_instance, object_type, search_columns, id, parent_id, position, other, optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space, access_predicates, filter_predicates, projection, time, qblock_name, object_alias, plan_id, depth, remarks, other_xml) values(:1, :2, :3, :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) |
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 |
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; |
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 |
bph1a3spdtg6g | 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 = '8618965065765' |
byzbk6f5n4upz | select sql_text from (select sql_text from v$sqlarea where buffer_gets > 5000 * executions order by executions desc) where rownum<6 |
c0j6cx9kzjf7g | SELECT EXTRACTVALUE(VALUE(T), '/select_list_item/pos') + 1 POS, EXTRACTVALUE(VALUE(T), '/select_list_item/value') RES, EXTRACTVALUE(VALUE(T), '/select_list_item/nonnulls') NONNULLS, EXTRACTVALUE(VALUE(T), '/select_list_item/ndv') NDV, EXTRACTVALUE(VALUE(T), '/select_list_item/split') SPLIT, EXTRACTVALUE(VALUE(T), '/select_list_item/rsize') RSIZE, EXTRACTVALUE(VALUE(T), '/select_list_item/rowcnt') ROWCNT, EXTRACT(VALUE(T), '/select_list_item/hash_val').GETCLOBVAL() HASHVAL FROM TABLE(XMLSEQUENCE(EXTRACT(:B1 , '/process_result/select_list_item'))) T |
cvhk2j2gymzhd | SELECT SU.NAME, SO.NAME, A.STATSTYPE#, C.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU, COLTYPE$ CT, OBJ$ TY WHERE O.OWNER#=U.USER# AND A.OBJ#=TY.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=CT.INTCOL# AND O.OBJ#=CT.OBJ# AND CT.TOID=TY.OID$ AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2 AND O.NAME=:B3 AND U.NAME=:B2 AND C.NAME=:B1 |
d0xmnp08rhfbg | insert into sys.wri$_optstat_histhead_history (obj#, intcol#, savtime, flags, null_cnt, minimum, maximum, distcnt, density, lowval, hival, avgcln, sample_distcnt, sample_size, timestamp#, colname) select h.obj#, h.intcol#, :3, bitand(h.spare2, 7) + 8 + decode(h.cache_cnt, 0, 0, 64), h.null_cnt, h.minimum, h.maximum, h.distcnt, h.density, h.lowval, h.hival, h.avgcln, h.spare1, h.sample_size, h.timestamp#, :4 from sys.hist_head$ h where h.obj# = :1 and h.intcol# = :2 |
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 |
db78fxqxwxt7r | select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket |
dckagq5arxva5 | delete from
t_bme_subscriber
where
resourceNumber = :0 |
du3npcpzq82sp | select sSubscriberID, sSubscriberNumber, sAssociatedNum1, sAssociatedNum2, sAssociatedNum3, sAssociatedNum4,
sAssociatedNum5, sAssociatedNum6, sAssociatedNum7, sAssociatedNum8,
sAssociatedNum9, sAssociatedNum10, sAssociatedNumTypeList, sActiveFlagList
from R_Bind_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 |
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))) |
Statistic | Total | per Second | per Trans |
Batched IO (bound) vector count | 0 | 0.00 | 0.00 |
Batched IO (full) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 0 | 0.00 | 0.00 |
Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
Batched IO double miss count | 0 | 0.00 | 0.00 |
Batched IO same unit count | 0 | 0.00 | 0.00 |
Batched IO single block count | 0 | 0.00 | 0.00 |
Batched IO slow jump count | 0 | 0.00 | 0.00 |
Batched IO vector block count | 0 | 0.00 | 0.00 |
Batched IO vector read count | 0 | 0.00 | 0.00 |
Block Cleanout Optim referenced | 64 | 0.02 | 0.14 |
CCursor + sql area evicted | 1,535 | 0.43 | 3.29 |
CPU used by this session | 15,202 | 4.22 | 32.55 |
CPU used when call started | 11,228 | 3.12 | 24.04 |
CR blocks created | 22 | 0.01 | 0.05 |
Cached Commit SCN referenced | 1,528 | 0.42 | 3.27 |
Commit SCN cached | 11 | 0.00 | 0.02 |
DB time | 278,229 | 77.24 | 595.78 |
DBWR checkpoint buffers written | 5,514 | 1.53 | 11.81 |
DBWR checkpoints | 0 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 114 | 0.03 | 0.24 |
DBWR undo block writes | 2,234 | 0.62 | 4.78 |
Effective IO time | 0 | 0.00 | 0.00 |
HSC Heap Segment Block Changes | 52,971 | 14.71 | 113.43 |
Heap Segment Array Inserts | 640 | 0.18 | 1.37 |
Heap Segment Array Updates | 5 | 0.00 | 0.01 |
IMU CR rollbacks | 9 | 0.00 | 0.02 |
IMU Flushes | 71 | 0.02 | 0.15 |
IMU Redo allocation size | 164,856 | 45.77 | 353.01 |
IMU commits | 363 | 0.10 | 0.78 |
IMU contention | 7 | 0.00 | 0.01 |
IMU ktichg flush | 7 | 0.00 | 0.01 |
IMU pool not allocated | 0 | 0.00 | 0.00 |
IMU recursive-transaction flush | 0 | 0.00 | 0.00 |
IMU undo allocation size | 1,098,360 | 304.93 | 2,351.95 |
IMU- failed to get a private strand | 0 | 0.00 | 0.00 |
LOB table id lookup cache misses | 4 | 0.00 | 0.01 |
Misses for writing mapping | 0 | 0.00 | 0.00 |
Number of read IOs issued | 0 | 0.00 | 0.00 |
RowCR - row contention | 0 | 0.00 | 0.00 |
RowCR attempts | 0 | 0.00 | 0.00 |
RowCR hits | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 370,354 | 102.82 | 793.05 |
active txn count during cleanout | 549 | 0.15 | 1.18 |
application wait time | 0 | 0.00 | 0.00 |
auto extends on undo tablespace | 0 | 0.00 | 0.00 |
background checkpoints completed | 0 | 0.00 | 0.00 |
background checkpoints started | 0 | 0.00 | 0.00 |
background timeouts | 13,951 | 3.87 | 29.87 |
branch node splits | 0 | 0.00 | 0.00 |
buffer is not pinned count | 1,538,201 | 427.04 | 3,293.79 |
buffer is pinned count | 301,379 | 83.67 | 645.35 |
bytes received via SQL*Net from client | 90,824,231 | 25,215.06 | 194,484.43 |
bytes sent via SQL*Net to client | 244,248,108 | 67,809.33 | 523,015.22 |
calls to get snapshot scn: kcmgss | 1,369,687 | 380.26 | 2,932.95 |
calls to kcmgas | 25,746 | 7.15 | 55.13 |
calls to kcmgcs | 36,862 | 10.23 | 78.93 |
cell physical IO interconnect bytes | 930,956,800 | 258,456.67 | 1,993,483.51 |
change write time | 518 | 0.14 | 1.11 |
cleanout - number of ktugct calls | 609 | 0.17 | 1.30 |
cleanouts and rollbacks - consistent read gets | 13 | 0.00 | 0.03 |
cleanouts only - consistent read gets | 80 | 0.02 | 0.17 |
cluster key scan block gets | 108,246 | 30.05 | 231.79 |
cluster key scans | 98,870 | 27.45 | 211.71 |
commit batch/immediate performed | 13 | 0.00 | 0.03 |
commit batch/immediate requested | 13 | 0.00 | 0.03 |
commit cleanout failures: block lost | 61 | 0.02 | 0.13 |
commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 100 | 0.03 | 0.21 |
commit cleanout failures: cannot pin | 0 | 0.00 | 0.00 |
commit cleanouts | 9,640 | 2.68 | 20.64 |
commit cleanouts successfully completed | 9,479 | 2.63 | 20.30 |
commit immediate performed | 13 | 0.00 | 0.03 |
commit immediate requested | 13 | 0.00 | 0.03 |
commit txn count during cleanout | 587 | 0.16 | 1.26 |
concurrency wait time | 16,453 | 4.57 | 35.23 |
consistent changes | 754,257 | 209.40 | 1,615.11 |
consistent gets | 2,693,625 | 747.82 | 5,767.93 |
consistent gets - examination | 1,087,174 | 301.83 | 2,328.00 |
consistent gets direct | 6 | 0.00 | 0.01 |
consistent gets from cache | 2,693,619 | 747.82 | 5,767.92 |
consistent gets from cache (fastpath) | 966,827 | 268.42 | 2,070.29 |
current blocks converted for CR | 0 | 0.00 | 0.00 |
cursor authentications | 18,309 | 5.08 | 39.21 |
data blocks consistent reads - undo records applied | 30 | 0.01 | 0.06 |
db block changes | 985,971 | 273.73 | 2,111.29 |
db block gets | 2,382,417 | 661.42 | 5,101.54 |
db block gets direct | 342 | 0.09 | 0.73 |
db block gets from cache | 2,382,075 | 661.32 | 5,100.80 |
db block gets from cache (fastpath) | 59,845 | 16.61 | 128.15 |
deferred (CURRENT) block cleanout applications | 4,822 | 1.34 | 10.33 |
dirty buffers inspected | 2 | 0.00 | 0.00 |
drop segment calls in space pressure | 0 | 0.00 | 0.00 |
enqueue conversions | 727 | 0.20 | 1.56 |
enqueue deadlocks | 0 | 0.00 | 0.00 |
enqueue releases | 113,569 | 31.53 | 243.19 |
enqueue requests | 113,533 | 31.52 | 243.11 |
enqueue timeouts | 0 | 0.00 | 0.00 |
enqueue waits | 0 | 0.00 | 0.00 |
exchange deadlocks | 0 | 0.00 | 0.00 |
execute count | 351,360 | 97.55 | 752.38 |
failed probes on index block reclamation | 0 | 0.00 | 0.00 |
frame signature mismatch | 0 | 0.00 | 0.00 |
free buffer inspected | 21,431 | 5.95 | 45.89 |
free buffer requested | 185,718 | 51.56 | 397.68 |
global undo segment hints helped | 0 | 0.00 | 0.00 |
heap block compress | 370 | 0.10 | 0.79 |
hot buffers moved to head of LRU | 36,956 | 10.26 | 79.13 |
immediate (CR) block cleanout applications | 93 | 0.03 | 0.20 |
immediate (CURRENT) block cleanout applications | 3,630 | 1.01 | 7.77 |
index crx upgrade (positioned) | 13 | 0.00 | 0.03 |
index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 718 | 0.20 | 1.54 |
index fetch by key | 422,019 | 117.16 | 903.68 |
index scans kdiixs1 | 743,359 | 206.37 | 1,591.78 |
java call heap collected bytes | 0 | 0.00 | 0.00 |
java call heap collected count | 0 | 0.00 | 0.00 |
java call heap gc count | 0 | 0.00 | 0.00 |
java call heap live object count | 0 | 0.00 | 0.00 |
java call heap live object count max | 0 | 0.00 | 0.00 |
java call heap live size | 0 | 0.00 | 0.00 |
java call heap live size max | 0 | 0.00 | 0.00 |
java call heap object count | 0 | 0.00 | 0.00 |
java call heap object count max | 0 | 0.00 | 0.00 |
java call heap total size | 0 | 0.00 | 0.00 |
java call heap total size max | 0 | 0.00 | 0.00 |
java call heap used size | 0 | 0.00 | 0.00 |
java call heap used size max | 0 | 0.00 | 0.00 |
leaf node 90-10 splits | 80 | 0.02 | 0.17 |
leaf node splits | 280 | 0.08 | 0.60 |
lob reads | 110,583 | 30.70 | 236.79 |
lob writes | 251,872 | 69.93 | 539.34 |
lob writes unaligned | 251,868 | 69.92 | 539.33 |
local undo segment hints helped | 0 | 0.00 | 0.00 |
logons cumulative | 2,840 | 0.79 | 6.08 |
messages received | 5,347 | 1.48 | 11.45 |
messages sent | 5,347 | 1.48 | 11.45 |
min active SCN optimization applied to CR | 23 | 0.01 | 0.05 |
no work - consistent read gets | 548,066 | 152.16 | 1,173.59 |
opened cursors cumulative | 191,216 | 53.09 | 409.46 |
parse count (describe) | 26 | 0.01 | 0.06 |
parse count (failures) | 102 | 0.03 | 0.22 |
parse count (hard) | 63,919 | 17.75 | 136.87 |
parse count (total) | 164,188 | 45.58 | 351.58 |
parse time cpu | 4,864 | 1.35 | 10.42 |
parse time elapsed | 22,708 | 6.30 | 48.63 |
physical IO disk bytes | 930,956,800 | 258,456.67 | 1,993,483.51 |
physical read IO requests | 17,355 | 4.82 | 37.16 |
physical read bytes | 146,563,072 | 40,689.54 | 313,839.55 |
physical read total IO requests | 51,886 | 14.40 | 111.10 |
physical read total bytes | 712,269,824 | 197,743.75 | 1,525,203.05 |
physical read total multi block requests | 12 | 0.00 | 0.03 |
physical reads | 17,891 | 4.97 | 38.31 |
physical reads cache | 17,885 | 4.97 | 38.30 |
physical reads cache prefetch | 536 | 0.15 | 1.15 |
physical reads direct | 6 | 0.00 | 0.01 |
physical reads direct (lob) | 0 | 0.00 | 0.00 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 2,327 | 0.65 | 4.98 |
physical write bytes | 47,988,736 | 13,322.86 | 102,759.61 |
physical write total IO requests | 13,315 | 3.70 | 28.51 |
physical write total bytes | 218,686,976 | 60,712.92 | 468,280.46 |
physical write total multi block requests | 225 | 0.06 | 0.48 |
physical writes | 5,858 | 1.63 | 12.54 |
physical writes direct | 342 | 0.09 | 0.73 |
physical writes direct (lob) | 8 | 0.00 | 0.02 |
physical writes direct temporary tablespace | 330 | 0.09 | 0.71 |
physical writes from cache | 5,516 | 1.53 | 11.81 |
physical writes non checkpoint | 2,636 | 0.73 | 5.64 |
pinned buffers inspected | 12 | 0.00 | 0.03 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 1,340 | 0.37 | 2.87 |
recursive calls | 919,332 | 255.23 | 1,968.59 |
recursive cpu usage | 9,552 | 2.65 | 20.45 |
redo blocks checksummed by FG (exclusive) | 16,755 | 4.65 | 35.88 |
redo blocks written | 80,531 | 22.36 | 172.44 |
redo buffer allocation retries | 0 | 0.00 | 0.00 |
redo entries | 118,118 | 32.79 | 252.93 |
redo log space requests | 0 | 0.00 | 0.00 |
redo log space wait time | 0 | 0.00 | 0.00 |
redo ordering marks | 2,073 | 0.58 | 4.44 |
redo size | 38,400,212 | 10,660.85 | 82,227.43 |
redo size for direct writes | 98,736 | 27.41 | 211.43 |
redo subscn max counts | 3,387 | 0.94 | 7.25 |
redo synch time | 48 | 0.01 | 0.10 |
redo synch writes | 1,810 | 0.50 | 3.88 |
redo wastage | 1,145,000 | 317.88 | 2,451.82 |
redo write time | 203 | 0.06 | 0.43 |
redo writer latching time | 1 | 0.00 | 0.00 |
redo writes | 3,067 | 0.85 | 6.57 |
rollback changes - undo records applied | 0 | 0.00 | 0.00 |
rollbacks only - consistent read gets | 9 | 0.00 | 0.02 |
rows fetched via callback | 124,618 | 34.60 | 266.85 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 99,847 | 27.72 | 213.81 |
session logical reads | 5,076,042 | 1,409.24 | 10,869.47 |
shared hash latch upgrades - no wait | 578,200 | 160.52 | 1,238.12 |
shared hash latch upgrades - wait | 350 | 0.10 | 0.75 |
sorts (memory) | 13,427 | 3.73 | 28.75 |
sorts (rows) | 4,758,542 | 1,321.09 | 10,189.60 |
space was found by tune down | 0 | 0.00 | 0.00 |
sql area evicted | 60,393 | 16.77 | 129.32 |
sql area purged | 139 | 0.04 | 0.30 |
steps of tune down ret. in space pressure | 0 | 0.00 | 0.00 |
summed dirty queue length | 2 | 0.00 | 0.00 |
switch current to new buffer | 3,388 | 0.94 | 7.25 |
table fetch by rowid | 333,887 | 92.70 | 714.96 |
table fetch continued row | 746 | 0.21 | 1.60 |
table scan blocks gotten | 63,269 | 17.57 | 135.48 |
table scan rows gotten | 3,194,543 | 886.88 | 6,840.56 |
table scans (direct read) | 0 | 0.00 | 0.00 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (short tables) | 12,343 | 3.43 | 26.43 |
total number of times SMON posted | 0 | 0.00 | 0.00 |
transaction rollbacks | 13 | 0.00 | 0.03 |
transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
tune down retentions in space pressure | 0 | 0.00 | 0.00 |
undo change vector size | 14,457,824 | 4,013.85 | 30,958.94 |
user I/O wait time | 6,062 | 1.68 | 12.98 |
user calls | 516,023 | 143.26 | 1,104.97 |
user commits | 459 | 0.13 | 0.98 |
user rollbacks | 8 | 0.00 | 0.02 |
workarea executions - optimal | 9,332 | 2.59 | 19.98 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 0 | 0.00 | 0.00 |