| SQL Id | SQL Text |
|---|
| 0cgt3tzkg1n97 | SELECT CODE, DESCRIPTION, NEXT_REFERENCE_DATE, RECURRENCE, MAX_DURATION, OPERATION FROM STORED_JOBS |
| 0h6b2sajwb74n | select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| 0h7jc6t42jsdy | SELECT /*+ first_rows(1) */ '"'||OI.NAME||'"' FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.OBJ$ OI WHERE U.NAME = :B2 AND OT.OWNER# = U.USER# AND OT.NAME = :B1 AND I.BO# = OT.OBJ# AND I.TYPE# = 4 AND I.OBJ# = OI.OBJ# |
| 0r0gjmr1vm88u | select /*+ no_parallel_index(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index_ffs(t, "I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST") */ count(*) as nrw, count(distinct sys_op_lbid(4219, 'L', t.rowid)) as nlb, count(distinct hextoraw(sys_op_descend("OBJ#")||sys_op_descend("INTCOL#")||sys_op_descend("SYS_NC00013$"))) as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRI$_OPTSTAT_HISTGRM_HISTORY" sample block ( 1.1529814419, 1) t where "OBJ#" is not null or "INTCOL#" is not null or "SYS_NC00013$" is not null |
| 10xj8nynmpqtq |
SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t
ime = s1.startup_time |
| 14566d856s6hs | SELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1 |
| 1627bjmpbh924 | select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*) from "SYS"."WRI$_OPTSTAT_HISTGRM_HISTORY" sample block ( 1.1739982860, 1) t |
| 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256)) |
| 19v5guvsgcd1v | SELECT C.TARGET_GUID, C.METRIC_GUID, C.STORE_METRIC, C.SCHEDULE, C.COLL_NAME, M.METRIC_NAME, M.EVAL_FUNC FROM MGMT_METRIC_COLLECTIONS_REP R, MGMT_METRIC_COLLECTIONS C, MGMT_METRICS M WHERE C.SUSPENDED = 0 AND C.IS_REPOSITORY = 1 AND (C.LAST_COLLECTED_TIMESTAMP IS NULL OR C.LAST_COLLECTED_TIMESTAMP + C.SCHEDULE / 1440 < SYSDATE) AND C.METRIC_GUID = M.METRIC_GUID AND R.TARGET_GUID = C.TARGET_GUID AND R.METRIC_GUID = C.METRIC_GUID AND R.COLL_NAME = C.COLL_NAME |
| 1b28hzmjun5t0 | MERGE INTO SYS.MON_MODS_ALL$ MM USING ( SELECT /*+ ordered */ DISTINCT TAB.OBJ# FROM (SELECT T.OBJ# OBJ#, T.OBJ# BO#, T.ANALYZETIME FROM SYS.TAB$ T WHERE BITAND(T.FLAGS, 16) = 16 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, T.BO# BO#, T.ANALYZETIME FROM SYS.TABCOMPART$ T WHERE BITAND(T.FLAGS, 2) = 2 UNION ALL SELECT T.OBJ# OBJ#, TCP.BO# BO#, T.ANALYZETIME FROM SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP WHERE BITAND(T.FLAGS, 2) = 2 AND T.POBJ# = TCP.OBJ# ) TAB, OBJ$ O, SYS.COL$ C WHERE TAB.BO# = O.OBJ# AND TAB.ANALYZETIME < O.MTIME AND C.OBJ# = TAB.BO# AND C.TYPE# IN ( 1, 2, 12, 23, 69, 96, 100, 101, 178, 179, 180, 181, 182, 183, 231) AND BITAND(C.PROPERTY, 16384+32768) = 0 AND NOT (BITAND(C.PROPERTY, 32+65536+131072) = 32+65536 AND C.DEFAULT$ IS NULL ) AND NOT EXISTS (SELECT /*+ unnest */ NULL FROM HIST_HEAD$ HH WHERE HH.OBJ# = TAB.OBJ# AND HH.INTCOL# = C.INTCOL#) ) MCS ON (MM.OBJ# = MCS.OBJ#) WHEN MATCHED THEN UPDATE SET FLAGS = FLAGS + 4 WHERE BITAND(FLAGS, 4) = 0 WHEN NOT MATCHED THEN INSERT (OBJ#, INSERTS, UPDATES, DELETES, TIMESTAMP, FLAGS, DROP_SEGMENTS) VALUES(MCS.OBJ#, 0, 0, 0, :B1 , 4, 0) |
| 1dubbbfqnqvh9 | SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL |
| 1msk5g3ktpj7t | SELECT IOT_NAME FROM DBA_TABLES WHERE OWNER = :B2 AND TABLE_NAME = :B1 AND IOT_TYPE = 'IOT_OVERFLOW' |
| 1x8a3ncff7ty1 | DELETE BULK_LOADING_REQUEST WHERE DIRECTORY_ID = :1 AND STRING_REQUEST IN ( SELECT STRING_REQUEST FROM BULK_LOADING_REQUEST WHERE DIRECTORY_ID != :2 AND DIRECTORY_ID < :3 GROUP BY STRING_REQUEST ) |
| 27xdav1rg5g14 | select u.name, o.name, o.namespace, o.type#, decode(bitand(i.property, 1024), 0, 0, 1) from ind$ i, obj$ o, user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.user# |
| 298ppdduqr7wm | SELECT status FROM sys.wri$_adv_tasks WHERE id = :1 |
| 2ym6hhaq30r73 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
| 31a13pnjps7j3 |
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(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.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_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(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
|
| 350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
| 3axxxnjp5jjwj | delete from ind_stats$ where obj#=:1 |
| 3kywng531fcxu | delete from tab_stats$ where obj#=:1 |
| 43rudbxyxjw6y | BEGIN HD_ARCHIVE_PURGE.MANAGE_NEW_PARTITION(); END;
|
| 4m7m0t6fjcs5x | update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1 |
| 52wyb6bhcs8zh | SELECT JOB_ID, NAME, REFERENCE_DATE, START_DATE, END_DATE, LIMIT_DATE, STATE, LOG_PATH, OPERATION, RESULT FROM JOBS WHERE STATE = :1 ORDER BY REFERENCE_DATE, JOB_ID FOR UPDATE |
| 57jgvrbychxmn | select /*+ no_parallel_index(t, "I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index_ffs(t, "I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST") */ count(*) as nrw, count(distinct sys_op_lbid(4216, 'L', t.rowid)) as nlb, null as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRI$_OPTSTAT_HISTHEAD_HISTORY" sample block ( 15.0104534170, 1) t where "OBJ#" is not null or "INTCOL#" is not null or "SYS_NC00022$" is not null |
| 5rxbazwmcdfaz | insert into sys.wri$_optstat_histhead_history (obj#, intcol#, savtime, flags) values (:1, :2, :3, 0) |
| 649ju2a8wtutj | SELECT JOB_ID, NAME, REFERENCE_DATE, START_DATE, END_DATE, LIMIT_DATE, STATE, LOG_PATH, OPERATION, RESULT FROM JOBS WHERE STATE = :1 ORDER BY REFERENCE_DATE, JOB_ID |
| 6mcpb06rctk0x | call dbms_space.auto_space_advisor_job_proc ( ) |
| 6qg99cfg26kwb | SELECT COUNT(UNQ) UNQ, COUNT(PFX) PFX FROM (SELECT /*+ first_rows(1) leading(cc) */ CD.TYPE# UNQ, NULL PFX FROM SYS.CCOL$ CC, SYS.CDEF$ CD WHERE CC.OBJ# = :B2 AND CC.INTCOL# = :B1 AND CD.CON# = CC.CON# AND CD.OBJ# = CC.OBJ# AND CD.ENABLED IS NOT NULL AND CD.INTCOLS = 1 AND CD.TYPE# IN (2, 3) AND BITAND(CD.DEFER, 2+4) = 4 AND ROWNUM < 2 UNION ALL SELECT /*+ first_rows(1) leading(i) */ CASE WHEN I.INTCOLS = 1 AND BITAND(I.PROPERTY, 1) = 1 THEN 3 ELSE NULL END UNQ, CASE WHEN IC.POS# = 1 THEN 1 ELSE NULL END PFX FROM SYS.IND$ I, SYS.ICOL$ IC WHERE I.BO# = :B2 AND I.BO# = IC.BO# AND IC.INTCOL# = :B1 AND I.OBJ# = IC.OBJ# AND BITAND(I.FLAGS, 1025) = 0 AND ROWNUM < 2 ) |
| 6xvp6nxs4a9n4 | select nvl(sum(space), 0) from recyclebin$ where ts# = :1 |
| 7gy3y7kjsbfuv | select a.con#, a.owner# from con$ a, cdef$ b where a.con# = b.con# and name = :1 and obj# = :2 |
| 7h66bd08futqb |
insert into wrh$_sess_time_stats (snap_id, dbid, instance_number, session_type, min_logon_time, sum_cpu_time, sum_sys_io_wait, sum_user_io_wait) select :snap_id, :dbid, :instance_number, type, min(logon_time) min_logon_time, sum(cpu_time) cpu_time, sum(sys_io_wait) sys_io_wait, sum(user_io_wait) user_io_wait from (select sid, serial#, max(type) type, max(logon_time) logon_time, max(cpu_time) cpu_time, sum(case when kslcsclsname = 'System I/O' then kslcstim else 0 end) as sys_io_wait, sum(case when kslcsclsname ='User I/O' then kslcstim else 0 end) as user_io_wait from (select /*+ ordered */ allsids.sid sid, allsids.serial# serial#, max(type) type, max(logon_time) logon_time, sum(kewsval) cpu_time from (select type, allsids.sid, sess.ksuseser as serial#, sess.ksuseltm as logon_time from (select /*+ ordered index(p) */ s.indx as sid, decode(l.role, 'reader', 'Logminer Reader', 'preparer', 'Logminer Preparer', 'builder', 'Logminer Builder') as type from x$logmnr_process l, x$ksupr p, x$ksuse s where l.role in ('reader', 'preparer', 'builder') and l.pid = p.indx and bitand(p.ksspaflg, 1)!=0 and p.ksuprpid = s.ksusepid union all select sid
_knst as sid, decode(type_knst, 8, 'STREAMS Capture', 7, 'STREAMS Apply Reader', 2, 'STREAMS Apply Server', 1, 'STREAMS Apply Coordinator') as type from x$knstcap where type_knst in (8, 7, 2, 1) union all select indx as sid, (case when ksusepnm like '%(q00%)' then 'QMON Slaves' else 'QMON Coordinator' end) as type from x$ksuse where ksusepnm like '%(q00%)' or ksusepnm like '%(QMNC)' union all select kwqpssid as sid, 'Propagation Sender' as type from x$kwqps union all select kwqpdsid as sid, 'Propagation Receiver' as type from x$kwqpd) allsids, x$ksuse sess where bitand(sess.ksspaflg, 1) != 0 and bitand(sess.ksuseflg, 1) != 0 and allsids.sid = sess.indx) allsids, x$kewssesv sesv, x$kewssmap map where allsids.sid = sesv.ksusenum and sesv.kewsnum = map.soffst and map.aggid = 1 and (map.stype = 2 or map.stype = 3) and map.sname in ('DB CPU', 'background cpu time') group by sid, serial#) allaggr, x$kslcs allio where allaggr.sid = allio.kslcssid(+) and allio.kslcsclsname in ('System I/O', 'User I/O') group by allaggr.sid, allaggr.serial#) group by type
|
| 7jpt4cpfvcy1k | select ts#, online$ from ts$ where name=:1 |
| 8a1pvy4cy8hgv | insert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue) values(:1, :2, :3, :4, :5, :6, :7) |
| 8bmx9xzmx4uqk | SELECT OWNER, SEGMENT_NAME, PARTITION_NAME, SEGMENT_TYPE, TABLESPACE_NAME, TABLESPACE_ID FROM SYS_DBA_SEGS WHERE SEGMENT_OBJD = :B1 AND SEGMENT_TYPE <> 'ROLLBACK' AND SEGMENT_TYPE <> 'TYPE2 UNDO' AND SEGMENT_TYPE <> 'DEFERRED ROLLBACK' AND SEGMENT_TYPE <> 'TEMPORARY' AND SEGMENT_TYPE <> 'CACHE' AND SEGMENT_TYPE <> 'SPACE HEADER' AND SEGMENT_TYPE <> 'UNDEFINED' |
| 8cuu0uynbrhbn | 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 |
| 8mrg623amm8rx |
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, 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, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 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.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))) 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 <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL
LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, 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 <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 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 ik.logins = 'ALLOWED' 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) order by RUNTIME, 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')) |
| 95mpkn5xz9001 | insert into hist_head$(obj#, intcol#, bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, spare1, spare2, avgcln, col#) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18) |
| 9qgtwh66xg6nz | update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3 |
| a1mbfp580hw3k | select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1 from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name |
| akh9zqqkx3wj7 | select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all select 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(id) from sys.wri$_adv_rationale where task_id = :1 |
| aq4js2gkfjru8 | update tsq$ set blocks=:3, maxblocks=:4, grantor#=:5, priv1=:6, priv2=:7, priv3=:8 where ts#=:1 and user#=:2 |
| b6usrg82hwsa3 | call dbms_stats.gather_database_stats_job_proc ( ) |
| bsa0wjtftg3uw | select file# from file$ where ts#=:1 |
| btzq46kta67dz | update obj$ set obj#=:6, type#=:7, ctime=:8, mtime=:9, stime=:10, status=:11, dataobj#=:13, flags=:14, oid$=:15, spare1=:16, spare2=:17 where owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and :5 is null)and(subname=:12 or subname is null and :12 is null) |
| byaarkxm6b0r1 | SELECT /*+ use_nl(u, o, t) */ NVL(T.DEGREE, 1) FROM USER$ U, OBJ$ O, TAB$ T WHERE U.NAME=:B2 AND O.NAME=:B1 AND O.OBJ#=T.OBJ# AND U.USER#=O.OWNER# |
| c1z51t90s24ns | insert into con$(owner#, name, con#)values(:1, :2, :3) |
| cfxfxjk00tq0m | SELECT TASKS.TASK_ID, REC.ID REC_ID, ACT.OBJ_ID, SUBSTR(OBJ.ATTR1, 1, 30) SEG_OWNER, SUBSTR(OBJ.ATTR2, 1, 30) SEG_NAME, SUBSTR(D.OBJECT_TYPE, 1, 18) SEG_TYPE, SUBSTR(OBJ.ATTR3, 1, 30) PART_NAME, TO_CHAR(SUBSTR(OBJ.ATTR4, 1, 30)) TBS_NAME FROM DBA_ADVISOR_TASKS TASKS, SYS.WRI$_ADV_REC_ACTIONS RACT, SYS.WRI$_ADV_OBJECTS OBJ, DBA_ADVISOR_OBJECT_TYPES D, SYS.WRI$_ADV_RECOMMENDATIONS REC, SYS.WRI$_ADV_ACTIONS ACT WHERE TASKS.ADVISOR_ID = 5 AND TASKS.TASK_ID = RACT.TASK_ID AND RACT.TASK_ID = REC.TASK_ID AND RACT.REC_ID = REC.ID AND NVL(REC.ANNOTATION, 0) <> 3 AND RACT.TASK_ID = ACT.TASK_ID AND RACT.ACT_ID = ACT.ID AND ACT.TASK_ID = OBJ.TASK_ID AND ACT.OBJ_ID = OBJ.ID AND OBJ.TYPE = D.OBJECT_TYPE_ID AND NVL(SUBSTR(OBJ.ATTR1, 1, 30), ' ') = NVL(:B5 , ' ') AND NVL(SUBSTR(OBJ.ATTR2, 1, 30), ' ') = NVL(:B4 , ' ') AND NVL(SUBSTR(D.OBJECT_TYPE, 1, 18), ' ') = NVL(:B3 , ' ') AND NVL(SUBSTR(OBJ.ATTR3, 1, 30), ' ') = NVL(:B2 , ' ') AND NVL(TO_CHAR(SUBSTR(OBJ.ATTR4, 1, 30)), ' ') = NVL(:B1 , ' ') |
| csnp95dz2r8ss | select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0 |
| 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 |
| d2x8u850bx7fv | SELECT VENDOR_ID FROM PARTY WHERE PARTY_ID = :1 |
| d89c1mh5pvbkz |
SELECT /*+ rule */ U.NAME, OT.NAME, NULL, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE :B4 IS NULL AND U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND C.OBJ# = OT.OBJ# AND (:B1 IS NULL OR C.NAME = :B1 ) AND H.OBJ# = OT.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OT.NAME, OP.SUBNAME, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.COL$ C, SYS.TABPART$ TP, SYS.OBJ$ OP, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OT.OWNER# = U.USER# AND OT.NAME = :B2 AND OT.TYPE# = 2 AND C.OBJ# = OT.OBJ# AND (:B1 IS NULL OR C.NAME = :B1 ) AND TP.BO# = OT.OBJ# AND TP.OBJ# = OP.OBJ# AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR OP.SUBNAME = :B4 ) AND H.OBJ# = OP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OP.NAME, OP.SUBNAME
, NULL, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.COL$ C, SYS.TABCOMPART$ TP, SYS.OBJ$ OP, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OP.OWNER# = U.USER# AND OP.NAME = :B2 AND OP.TYPE# = 19 AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR OP.SUBNAME = :B4 ) AND TP.OBJ# = OP.OBJ# AND C.OBJ# = TP.BO# AND (:B1 IS NULL OR C.NAME = :B1 ) AND H.OBJ# = OP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# UNION ALL SELECT U.NAME, OP.NAME, OP.SUBNAME, OS.SUBNAME, C.NAME, BITAND(H.SPARE2, 2), BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL, NULL, H.CACHE_CNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.SPARE2, 4), NULL FROM SYS.USER$ U, SYS.COL$ C, SYS.TABCOMPART$ TP, SYS.OBJ$ OP, SYS.TABSUBPART$ TS, SYS.OBJ$ OS, SYS.HIST_HEAD$ H, HISTGRM$ HG WHERE U.NAME = :B3 AND OP.OWNER# = U.USER# AND OP.NAME = :B2 AND OP.TYPE# = 19 AND TP.OBJ# = OP.OBJ# AND C.OBJ# = TP.BO# AND (:B1 IS NULL OR C.NAME = :B1 ) AND TS.POBJ# = TP.OBJ# AND TS.OBJ# = OS.OBJ# AND ((:B4 IS NULL AND :B5 IS NOT NULL) OR (OP.SUBNAME = :B4 AND (:B5 IS NOT NULL OR OS.SUBNAME IS NULL)) OR
OS.SUBNAME = :B4 ) AND H.OBJ# = OS.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# ORDER BY 1, 2, 3, 4, 5, 22 |
| fk3985dkjb1ua |
SELECT /*+ ordered use_nl(o c cu h) index(u i_user1) index(o i_obj2)
index(ci_obj#) index(cu i_col_usage$)
index(h i_hh_obj#_intcol#) */ C.NAME COL_NAME, C.TYPE# COL_TYPE, C.CHARSETFORM COL_CSF, C.DEFAULT$ COL_DEF, C.NULL$ COL_NULL, C.PROPERTY COL_PROP, C.COL# COL_UNUM, C.INTCOL# COL_INUM, C.OBJ# COL_OBJ, C.SCALE COL_SCALE, H.BUCKET_CNT H_BCNT, (T.ROWCNT-H.NULL_CNT)/GREATEST(H.DISTCNT, 1) H_PFREQ, C.LENGTH COL_LEN, CU.TIMESTAMP CU_TIME, CU.EQUALITY_PREDS CU_EP, CU.EQUIJOIN_PREDS CU_EJP, CU.RANGE_PREDS CU_RP, CU.LIKE_PREDS CU_LP, CU.NONEQUIJOIN_PREDS CU_NEJP, CU.NULL_PREDS NP FROM SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.COL$ C, SYS.COL_USAGE$ CU, SYS.HIST_HEAD$ H WHERE :B3 = '0' AND U.NAME = :B2 AND O.OWNER# = U.USER# AND O.TYPE# = 2 AND O.NAME = :B1 AND O.OBJ# = T.OBJ# AND O.OBJ# = C.OBJ# AND C.OBJ# = CU.OBJ#(+) AND C.INTCOL# = CU.INTCOL#(+) AND C.OBJ# = H.OBJ#(+) AND C.INTCOL# = H.INTCOL#(+) UNION ALL SELECT /*+ ordered use_nl(c) */ C.KQFCONAM COL_NAME, C.KQFCODTY COL_TYPE, DECODE(C.KQFCODTY, 1, 1, 0) COL_CSF, NULL COL_DEF, 0 COL_NULL, 0 COL_PROP, C.KQFCOCNO COL_UNUM, C.KQFCOCNO COL_INUM, O.KQFTAOBJ COL_OBJ, DECODE(C.KQFCODTY, 2, -127, 0) COL_SCALE, H.BUCKET_CNT H_BCNT, (ST.ROWCNT-NULL_CNT)/GREATEST(H.DISTCNT, 1) H_PFREQ, DECODE(C.KQFCODTY, 2, 22, C.KQFCOSIZ) COL_LEN, CU.TIMESTAMP CU_TIME, CU.EQUALITY_PREDS CU_EP, CU.EQUIJOIN_PREDS CU_EJP, CU.RANGE_PREDS CU_RP, CU.LIKE_PREDS CU_LP, CU.NONEQUI
JOIN_PREDS CU_NEJP, CU.NULL_PREDS NP FROM SYS.X$KQFTA O, SYS.TAB_STATS$ ST, SYS.X$KQFCO C, SYS.COL_USAGE$ CU, SYS.HIST_HEAD$ H WHERE :B3 != '0' AND :B2 = 'SYS' AND O.KQFTANAM = :B1 AND O.KQFTAOBJ = ST.OBJ#(+) AND O.KQFTAOBJ = C.KQFCOTOB AND C.KQFCOTOB = CU.OBJ#(+) AND C.KQFCOCNO = CU.INTCOL#(+) AND C.KQFCOTOB = H.OBJ#(+) AND C.KQFCOCNO = H.INTCOL#(+) |
| fyjb2abrfhy4u | SELECT O.SUBNAME PART FROM SYS.USER$ U, SYS.OBJ$ O, SYS.INDPART$ IP, PARTOBJ$ PO, IND$ I, TABPART$ TP WHERE U.NAME = :B2 AND O.NAME = :B1 AND O.TYPE# = 20 AND U.USER# = O.OWNER# AND IP.OBJ# = O.OBJ# AND IP.BO# = PO.OBJ# AND BITAND(PO.FLAGS, 1) = 1 AND I.BO# = TP.BO# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND BITAND(TP.FLAGS, 32) = 32 UNION ALL SELECT O.SUBNAME PART FROM SYS.USER$ U, SYS.OBJ$ O, SYS.INDCOMPART$ IP, PARTOBJ$ PO, IND$ I, TABCOMPART$ TP WHERE U.NAME = :B2 AND O.NAME = :B1 AND O.TYPE# = 20 AND U.USER# = O.OWNER# AND IP.OBJ# = O.OBJ# AND IP.BO# = PO.OBJ# AND BITAND(PO.FLAGS, 1) = 1 AND I.BO# = TP.BO# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND BITAND(TP.FLAGS, 32) = 32 |
| g00cj285jmgsw | update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn |
| gdn3ysuyssf82 | SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1 |
| gfw9v7ckmbdb6 | delete from ind_online$ where obj#= :1 |
| grwydz59pu6mc | select text from view$ where rowid=:1 |
| Statistic | Total | per Second | per Trans |
|---|
| CPU used by this session | 160,333 | 1.39 | 5.56 |
| CPU used when call started | 77,085 | 0.67 | 2.67 |
| CR blocks created | 46,397 | 0.40 | 1.61 |
| Cached Commit SCN referenced | 10,576 | 0.09 | 0.37 |
| Commit SCN cached | 102 | 0.00 | 0.00 |
| DB time | 11,848,112 | 102.80 | 410.71 |
| DBWR checkpoint buffers written | 129,104 | 1.12 | 4.48 |
| DBWR checkpoints | 5,363 | 0.05 | 0.19 |
| DBWR object drop buffers written | 13,310 | 0.12 | 0.46 |
| DBWR parallel query checkpoint buffers written | 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 | 2,870 | 0.02 | 0.10 |
| DBWR undo block writes | 17,902 | 0.16 | 0.62 |
| DFO trees parallelized | 15,124 | 0.13 | 0.52 |
| IMU CR rollbacks | 1,241 | 0.01 | 0.04 |
| IMU Flushes | 4,902 | 0.04 | 0.17 |
| IMU Redo allocation size | 160,366,124 | 1,391.45 | 5,559.00 |
| IMU commits | 20,262 | 0.18 | 0.70 |
| IMU contention | 10 | 0.00 | 0.00 |
| IMU ktichg flush | 453 | 0.00 | 0.02 |
| IMU pool not allocated | 285 | 0.00 | 0.01 |
| IMU recursive-transaction flush | 71 | 0.00 | 0.00 |
| IMU undo allocation size | 149,353,680 | 1,295.89 | 5,177.26 |
| IMU- failed to get a private strand | 285 | 0.00 | 0.01 |
| PX local messages recv'd | 424,170 | 3.68 | 14.70 |
| PX local messages sent | 424,188 | 3.68 | 14.70 |
| Parallel operations not downgraded | 15,124 | 0.13 | 0.52 |
| RowCR - row contention | 3 | 0.00 | 0.00 |
| RowCR attempts | 540 | 0.00 | 0.02 |
| RowCR hits | 537 | 0.00 | 0.02 |
| SMON posted for dropping temp segment | 0 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 35 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 783,601 | 6.80 | 27.16 |
| active txn count during cleanout | 10,616 | 0.09 | 0.37 |
| application wait time | 949 | 0.01 | 0.03 |
| background checkpoints completed | 2 | 0.00 | 0.00 |
| background checkpoints started | 2 | 0.00 | 0.00 |
| background timeouts | 370,838 | 3.22 | 12.85 |
| branch node splits | 0 | 0.00 | 0.00 |
| buffer is not pinned count | 233,790,009 | 2,028.52 | 8,104.20 |
| buffer is pinned count | 1,369,189,879 | 11,880.03 | 47,462.21 |
| bytes received via SQL*Net from client | 182,713,900 | 1,585.35 | 6,333.68 |
| bytes sent via SQL*Net to client | 69,339,968 | 601.64 | 2,403.63 |
| calls to get snapshot scn: kcmgss | 2,740,232 | 23.78 | 94.99 |
| calls to kcmgas | 293,757 | 2.55 | 10.18 |
| calls to kcmgcs | 38,921 | 0.34 | 1.35 |
| change write time | 9,953 | 0.09 | 0.35 |
| cleanout - number of ktugct calls | 12,425 | 0.11 | 0.43 |
| cleanouts and rollbacks - consistent read gets | 2,488 | 0.02 | 0.09 |
| cleanouts only - consistent read gets | 1,500 | 0.01 | 0.05 |
| cluster key scan block gets | 183,959,430 | 1,596.16 | 6,376.85 |
| cluster key scans | 183,144,151 | 1,589.08 | 6,348.59 |
| commit batch/immediate performed | 51 | 0.00 | 0.00 |
| commit batch/immediate requested | 51 | 0.00 | 0.00 |
| commit cleanout failures: block lost | 1,389 | 0.01 | 0.05 |
| commit cleanout failures: buffer being written | 14 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 502 | 0.00 | 0.02 |
| commit cleanout failures: cannot pin | 0 | 0.00 | 0.00 |
| commit cleanouts | 437,210 | 3.79 | 15.16 |
| commit cleanouts successfully completed | 435,305 | 3.78 | 15.09 |
| commit immediate performed | 51 | 0.00 | 0.00 |
| commit immediate requested | 51 | 0.00 | 0.00 |
| commit txn count during cleanout | 4,972 | 0.04 | 0.17 |
| concurrency wait time | 2,034 | 0.02 | 0.07 |
| consistent changes | 66,581 | 0.58 | 2.31 |
| consistent gets | 323,611,118 | 2,807.87 | 11,217.80 |
| consistent gets - examination | 83,392,886 | 723.57 | 2,890.77 |
| consistent gets direct | 53 | 0.00 | 0.00 |
| consistent gets from cache | 323,611,065 | 2,807.87 | 11,217.80 |
| current blocks converted for CR | 0 | 0.00 | 0.00 |
| cursor authentications | 981 | 0.01 | 0.03 |
| data blocks consistent reads - undo records applied | 37,680 | 0.33 | 1.31 |
| db block changes | 5,556,068 | 48.21 | 192.60 |
| db block gets | 5,803,182 | 50.35 | 201.16 |
| db block gets direct | 2,257 | 0.02 | 0.08 |
| db block gets from cache | 5,800,925 | 50.33 | 201.09 |
| deferred (CURRENT) block cleanout applications | 299,772 | 2.60 | 10.39 |
| dirty buffers inspected | 796 | 0.01 | 0.03 |
| enqueue conversions | 110,569 | 0.96 | 3.83 |
| enqueue releases | 1,612,431 | 13.99 | 55.89 |
| enqueue requests | 1,612,433 | 13.99 | 55.89 |
| enqueue timeouts | 0 | 0.00 | 0.00 |
| enqueue waits | 21,116 | 0.18 | 0.73 |
| execute count | 1,647,273 | 14.29 | 57.10 |
| failed probes on index block reclamation | 7 | 0.00 | 0.00 |
| free buffer inspected | 304,282 | 2.64 | 10.55 |
| free buffer requested | 363,636 | 3.16 | 12.61 |
| heap block compress | 2,986 | 0.03 | 0.10 |
| hot buffers moved to head of LRU | 66,109 | 0.57 | 2.29 |
| immediate (CR) block cleanout applications | 3,988 | 0.03 | 0.14 |
| immediate (CURRENT) block cleanout applications | 67,323 | 0.58 | 2.33 |
| index crx upgrade (positioned) | 194,051 | 1.68 | 6.73 |
| index fast full scans (direct read) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 891 | 0.01 | 0.03 |
| index fast full scans (rowid ranges) | 0 | 0.00 | 0.00 |
| index fetch by key | 76,238,916 | 661.50 | 2,642.78 |
| index scans kdiixs1 | 1,806,588 | 15.68 | 62.62 |
| leaf node 90-10 splits | 1,641 | 0.01 | 0.06 |
| leaf node splits | 2,051 | 0.02 | 0.07 |
| lob reads | 6,015 | 0.05 | 0.21 |
| lob writes | 10,399 | 0.09 | 0.36 |
| lob writes unaligned | 10,399 | 0.09 | 0.36 |
| logons cumulative | 33,132 | 0.29 | 1.15 |
| messages received | 141,889 | 1.23 | 4.92 |
| messages sent | 141,889 | 1.23 | 4.92 |
| no buffer to keep pinned count | 2,423 | 0.02 | 0.08 |
| no work - consistent read gets | 238,936,785 | 2,073.18 | 8,282.61 |
| opened cursors cumulative | 953,411 | 8.27 | 33.05 |
| parse count (failures) | 9 | 0.00 | 0.00 |
| parse count (hard) | 42,097 | 0.37 | 1.46 |
| parse count (total) | 764,254 | 6.63 | 26.49 |
| parse time cpu | 41,177 | 0.36 | 1.43 |
| parse time elapsed | 42,010 | 0.36 | 1.46 |
| physical read IO requests | 143,127 | 1.24 | 4.96 |
| physical read bytes | 8,469,708,800 | 73,488.99 | 293,597.78 |
| physical read total IO requests | 284,057 | 2.46 | 9.85 |
| physical read total bytes | 11,937,132,544 | 103,574.74 | 413,794.11 |
| physical read total multi block requests | 15,220 | 0.13 | 0.53 |
| physical reads | 258,475 | 2.24 | 8.96 |
| physical reads cache | 257,768 | 2.24 | 8.94 |
| physical reads cache prefetch | 114,836 | 1.00 | 3.98 |
| physical reads direct | 707 | 0.01 | 0.02 |
| physical reads direct (lob) | 52 | 0.00 | 0.00 |
| physical reads direct temporary tablespace | 654 | 0.01 | 0.02 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 83,649 | 0.73 | 2.90 |
| physical write bytes | 4,855,300,096 | 42,127.91 | 168,306.30 |
| physical write total IO requests | 329,363 | 2.86 | 11.42 |
| physical write total bytes | 12,318,707,712 | 106,885.54 | 427,021.20 |
| physical write total multi block requests | 149,547 | 1.30 | 5.18 |
| physical writes | 148,172 | 1.29 | 5.14 |
| physical writes direct | 2,911 | 0.03 | 0.10 |
| physical writes direct (lob) | 1 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 2,905 | 0.03 | 0.10 |
| physical writes from cache | 145,261 | 1.26 | 5.04 |
| physical writes non checkpoint | 60,966 | 0.53 | 2.11 |
| pinned buffers inspected | 3 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 2,453 | 0.02 | 0.09 |
| process last non-idle time | 86,408 | 0.75 | 3.00 |
| queries parallelized | 15,124 | 0.13 | 0.52 |
| recovery blocks read | 0 | 0.00 | 0.00 |
| recursive calls | 10,750,939 | 93.28 | 372.68 |
| recursive cpu usage | 140,913 | 1.22 | 4.88 |
| redo blocks read for recovery | 0 | 0.00 | 0.00 |
| redo blocks written | 2,270,488 | 19.70 | 78.71 |
| redo buffer allocation retries | 7 | 0.00 | 0.00 |
| redo entries | 2,829,458 | 24.55 | 98.08 |
| redo log space requests | 8 | 0.00 | 0.00 |
| redo log space wait time | 10 | 0.00 | 0.00 |
| redo ordering marks | 52,821 | 0.46 | 1.83 |
| redo size | 1,107,544,444 | 9,609.81 | 38,392.42 |
| redo subscn max counts | 73,735 | 0.64 | 2.56 |
| redo synch time | 5,942 | 0.05 | 0.21 |
| redo synch writes | 20,879 | 0.18 | 0.72 |
| redo wastage | 16,936,080 | 146.95 | 587.08 |
| redo write time | 27,552 | 0.24 | 0.96 |
| redo writer latching time | 24 | 0.00 | 0.00 |
| redo writes | 62,593 | 0.54 | 2.17 |
| rollback changes - undo records applied | 85 | 0.00 | 0.00 |
| rollbacks only - consistent read gets | 31,578 | 0.27 | 1.09 |
| rows fetched via callback | 7,001,483 | 60.75 | 242.70 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 925,959 | 8.03 | 32.10 |
| session logical reads | 329,414,300 | 2,858.22 | 11,418.96 |
| shared hash latch upgrades - no wait | 304,250 | 2.64 | 10.55 |
| shared hash latch upgrades - wait | 0 | 0.00 | 0.00 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 355,631 | 3.09 | 12.33 |
| sorts (rows) | 68,578,152 | 595.03 | 2,377.22 |
| sql area evicted | 28,331 | 0.25 | 0.98 |
| sql area purged | 16,953 | 0.15 | 0.59 |
| summed dirty queue length | 3,090 | 0.03 | 0.11 |
| switch current to new buffer | 7,868 | 0.07 | 0.27 |
| table fetch by rowid | 670,731,861 | 5,819.73 | 23,250.55 |
| table fetch continued row | 67,088 | 0.58 | 2.33 |
| table scan blocks gotten | 4,934,588 | 42.82 | 171.05 |
| table scan rows gotten | 1,381,309,916 | 11,985.19 | 47,882.35 |
| table scans (cache partitions) | 0 | 0.00 | 0.00 |
| table scans (direct read) | 0 | 0.00 | 0.00 |
| table scans (long tables) | 26 | 0.00 | 0.00 |
| table scans (rowid ranges) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 198,951 | 1.73 | 6.90 |
| total number of times SMON posted | 35 | 0.00 | 0.00 |
| transaction rollbacks | 51 | 0.00 | 0.00 |
| transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
| undo change vector size | 382,916,348 | 3,322.44 | 13,273.58 |
| user I/O wait time | 5,051 | 0.04 | 0.18 |
| user calls | 1,051,953 | 9.13 | 36.47 |
| user commits | 28,845 | 0.25 | 1.00 |
| user rollbacks | 3 | 0.00 | 0.00 |
| workarea executions - onepass | 20 | 0.00 | 0.00 |
| workarea executions - optimal | 185,530 | 1.61 | 6.43 |
| write clones created for recovery | 0 | 0.00 | 0.00 |
| write clones created in background | 6 | 0.00 | 0.00 |
| write clones created in foreground | 29 | 0.00 | 0.00 |