SQL Id | SQL Text |
05s9358mm6vrr | begin dbms_feature_usage_internal.exec_db_usage_sampling(:bind1); end; |
089dbukv1aanh | SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL |
08bqjmf8490s2 | SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 |
08qpghs7y4q2f | UPDATE SYS.WRI$_ADV_TASKS SET MTIME = SYSDATE, LAST_EXEC_NAME = :B5 , STATUS = NVL(:B4 , STATUS), CLEANUP = NVL(:B3 , CLEANUP), VERSION = NVL(:B2 , VERSION) WHERE ID = :B1 |
0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
0ut2yw7mxf0aq | insert into WRM$_SNAPSHOT (snap_id, dbid, instance_number, startup_time, begin_interval_time, end_interval_time, snap_level, status, error_count, bl_moved, snap_flag) values (:snap_id, :dbid, :instance_number, :startup_time, :begin_interval_time, :end_interval_time, :snap_level, :status, 0, 0, :bind1) |
130dvvr5s8bgn | select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part# |
18u5bnb9bzvha | SELECT STATUS# FROM SYS.DBA_ADVISOR_TASKS WHERE TASK_ID = :B1 FOR UPDATE |
1q3bajqwg95cz | SELECT COUNT(*) FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND A.OWNER# = :B2 AND BITAND(A.PROPERTY, :B1 ) = :B1 |
1rac8z6n21f14 | SELECT MAX(END_INTERVAL_TIME), COUNT(*) FROM WRM$_SNAPSHOT WHERE SNAP_ID = :B2 AND DBID = :B1 |
1tgukkrqj3zhw |
SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BI
TAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 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, :8) <> 0 and lower(e.affinity) = lower(:9))) OR (INST_ID IS NOT NULL AND INST_ID = :10)) ORDER BY 2, 3, 4 DESC |
2wnyugwy6m6vs | SELECT CASE AVG(HAS_CURRENT_APPLIED_POLICY) WHEN 1 THEN 1 WHEN 0 THEN 2 ELSE 3 END FROM NXGT_ACCOUNT_TREE_AP WHERE APPLIED_POLICY_ID IS NULL OR HAS_CURRENT_APPLIED_POLICY = 1 |
2zd224kurqsr9 | SELECT XMLTYPE(I.DATA) AS DATA, D.DIRECTIVE_NAME FROM DBA_ADVISOR_DIR_TASK_INST I, DBA_ADVISOR_DIR_DEFINITIONS D WHERE I.TASK_ID = :B1 AND I.DIRECTIVE_ID = D.ID AND D.ADVISOR_NAME = 'ADDM' |
350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
363tzjzrrt6b6 | MERGE INTO NXGT_ACTR_RESULT_SET A USING (SELECT PARENT_TREE_NODE_ID, COUNT(*) MY_COUNT FROM NXGT_ACTR_RESULT_SET WHERE AVAILABILITY = 1 GROUP BY PARENT_TREE_NODE_ID) SA ON ( A.TREE_NODE_ID = SA.PARENT_TREE_NODE_ID AND A.NODE_TYPE = 'A') WHEN MATCHED THEN UPDATE SET A.SA_AVAIL_COUNT = SA.MY_COUNT |
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 |
3dmrp1716t2wk | MERGE INTO NXGT_ACCOUNT_TREE_AP T USING ( WITH SUB_ACCOUNTS AS (SELECT ID, PARENT_ID, APPLIED_POLICY_ID, CALENDAR_ID FROM NXGT_ACCOUNT_TREE_AP WHERE NTYPE = 'S') SELECT S1.ID , S2.APPLIED_POLICY_ID , S2.CALENDAR_ID FROM SUB_ACCOUNTS S1 JOIN (SELECT PARENT_ID, MAX(APPLIED_POLICY_ID) APPLIED_POLICY_ID, CALENDAR_ID FROM SUB_ACCOUNTS WHERE CALENDAR_ID <> :B1 GROUP BY PARENT_ID, CALENDAR_ID) S2 ON S1.PARENT_ID = S2.PARENT_ID WHERE S1.APPLIED_POLICY_ID IS NULL) SA ON (T.ID = SA.ID) WHEN MATCHED THEN UPDATE SET T.APPLIED_POLICY_ID=SA.APPLIED_POLICY_ID , T.CALENDAR_ID=SA.CALENDAR_ID |
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 fetches,
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.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)) 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, 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.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 ) |
42cfrr6x5t75c | SELECT MAX(DB_NAME), MAX(VERSION) FROM WRM$_DATABASE_INSTANCE WHERE DBID = :B1 AND STARTUP_TIME = (SELECT MAX(STARTUP_TIME) FROM WRM$_DATABASE_INSTANCE WHERE DBID = :B1 AND STARTUP_TIME <= :B2 ) |
43ruajmwv9fus | insert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue)values(:1, :2, :3, :4, :5, :6, :7) |
492dn6mqhqfzu | INSERT INTO NXGT_ACCOUNT_TREE_AP (ID, PARENT_ID, ACCT_NUM, NTYPE, HAS_CURRENT_APPLIED_POLICY, APPLIED_POLICY_ID, CALENDAR_ID) WITH LEVEL_1_KIDS AS (SELECT TR.TREE_NODE_ID, TR.PARENT_TREE_NODE_ID , TR.NODE_TYPE , TR.NODE_ID , CASE WHEN TR.APPLIED_POLICY_ID IS NULL OR TR.APPLIED_POLICY_ID <> :B2 THEN 0.0 ELSE 1.0 END HAS_CURRENT_APPLIED_POLICY , TR.APPLIED_POLICY_ID , TR.CALENDAR_ID , TR.LEVEL_NUM FROM NXGT_ACTR_RESULT_SET TR START WITH TR.TREE_NODE_ID = :B1 CONNECT BY PRIOR TR.TREE_NODE_ID = TR.PARENT_TREE_NODE_ID) SELECT L1K.TREE_NODE_ID , L1K.PARENT_TREE_NODE_ID , L1K.NODE_ID , L1K.NODE_TYPE , L1K.HAS_CURRENT_APPLIED_POLICY , L1K.APPLIED_POLICY_ID , L1K.CALENDAR_ID FROM LEVEL_1_KIDS L1K WHERE L1K.LEVEL_NUM > 1 AND L1K.NODE_TYPE IN ('A', 'S') |
4rmr95aagzqv3 | INSERT INTO NXGT_ACTR_RESULT_SET (TREE_NODE_ID, PARENT_TREE_NODE_ID, NODE_TYPE, NODE_ID, NODE_PARENT_ID , NODE_DESCRIPTION, HAS_CHILDREN, APPLIED_POLICY_ID, CALENDAR_ID, LEVEL_NUM) WITH TREE_NODES AS (SELECT A.ACCT_GROUP PARENT_TREE_NODE_ID , A.ACCT_ID TREE_NODE_ID , A.ACCT_TYPE_CODE NODE_TYPE , A.ACCT_NUM NODE_ID , A.ACCT_NAME NODE_DESCRIPTION , 'N' HAS_CHILDREN , LEVEL AS LEVEL_NUM FROM NXGT_ACTR_ALL_GROUPS_ASAS A START WITH A.ACCT_GROUP = :B1 CONNECT BY PRIOR A.ACCT_ID = A.ACCT_GROUP) SELECT TN.TREE_NODE_ID, TN.PARENT_TREE_NODE_ID, TN.NODE_TYPE, TN.NODE_ID , A.ACCT_NUM NODE_PARENT_ID, TN.NODE_DESCRIPTION, TN.HAS_CHILDREN , AP.APPLIED_POLICY_ID, AP.CALENDAR_ID, TN.LEVEL_NUM FROM TREE_NODES TN LEFT JOIN BS_ACCTS A ON TN.PARENT_TREE_NODE_ID = A.ACCT_ID LEFT JOIN NXGT_ACTR_AP_SNAPSHOT AP ON TN.TREE_NODE_ID = AP.ACCT_ID |
4vs91dcv7u1p6 | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36) |
4y1y43113gv8f | delete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 |
5c6mww9rqa9hw | select /*+ no_parallel_index(t, "WRH$_EVENT_HISTOGRAM_PK") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad no_expand index(t, "WRH$_EVENT_HISTOGRAM_PK") */ count(*) as nrw, count(distinct sys_op_lbid(6267, 'L', t.rowid)) as nlb, null as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRH$_EVENT_HISTOGRAM" t where "DBID" is not null or "SNAP_ID" is not null or "INSTANCE_NUMBER" is not null or "EVENT_ID" is not null or "WAIT_TIME_MILLI" is not null |
5kyb5bvnu3s04 | SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE = :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1 |
5ms6rbzdnq16t | select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job |
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 |
66gs90fyynks7 | insert into wrh$_instance_recovery (snap_id, dbid, instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt) select :snap_id, :dbid, :instance_number, recovery_estimated_ios, actual_redo_blks, target_redo_blks, log_file_size_redo_blks, log_chkpt_timeout_redo_blks, log_chkpt_interval_redo_blks, fast_start_io_target_redo_blks, target_mttr, estimated_mttr, ckpt_block_writes, optimal_logfile_size, estd_cluster_available_time, writes_mttr, writes_logfile_size, writes_log_checkpoint_settings, writes_other_settings, writes_autotune, writes_full_thread_ckpt from v$instance_recovery |
6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
6nr22s0vjrtc1 | UPDATE NXGT_ACTR_RESULT_SET SET SELECTED = 1 WHERE NODE_TYPE IN ('A', 'S') AND APPLIED_POLICY_ID = :B1 |
6wm3n4d7bnddg |
SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l ,
DBA_SCHEDULER_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(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B
Y source ASC, time_secs DESC, log_id ASC |
7m3xvzupv5a64 | UPDATE wrh$_sqltext stx SET stx.snap_id = :lah_snap_id WHERE stx.dbid = :dbid AND stx.sql_id = :sql_id |
7sx5p1ug5ag12 | SELECT SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1 |
84ygtc6ucuafk | update sys.scheduler$_job set job_status = :1 where obj# = :2 |
86w49kdq48gk9 | SELECT STATUS#, HOW_CREATED, LAST_EXECUTION FROM SYS.DBA_ADVISOR_TASKS WHERE TASK_ID = :B1 FOR UPDATE |
8vwv6hx92ymmm | UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1 |
9r9t4qu6ubs00 | SELECT t9.prop_value FROM as_props t9 WHERE t9.user_id = 0 AND t9.prop_name = 'Number of ASAs' AND t9.prop_order = 0 |
a4cfk3vjhd9qj | DELETE FROM NXGT_ACCOUNT_TREE_AP WHERE ID IN ( SELECT SA.ID FROM NXGT_ACCOUNT_TREE_AP SA JOIN NXGT_ACCOUNT_TREE_AP A ON SA.PARENT_ID = A.ID AND A.APPLIED_POLICY_ID IS NOT NULL UNION SELECT A.ID FROM NXGT_ACCOUNT_TREE_AP A JOIN NXGT_ACCOUNT_TREE_AP SA ON A.ID = SA.PARENT_ID AND SA.APPLIED_POLICY_ID IS NOT NULL) |
a5mmhrrnpwjsc |
SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0)
OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND INST_ID IS NULL AND (CLSOID IS NULL OR (CLSOID IS NOT NULL AND (CLSOID IN (select e.obj# from sys.scheduler$_class e where e.affinity is null)))) ORDER BY 2, 3, 4 DESC |
ab3swhv5g138y |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY'
)) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.ob
j# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj#
and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
ajymgnp1qnruw | select o.name, o.owner# from obj$ o, type$ t where o.oid$ = t.tvoid and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007 |
aktbxfjwnzgmu | update WRM$_DATABASE_INSTANCE set last_ash_sample_id = :last_ash_sample_id where instance_number = :instance_number and dbid = :dbid and startup_time = (select max(startup_time) from WRM$_DATABASE_INSTANCE where instance_number = :instance_number2 and dbid = :dbid2 ) |
am1fn6xx94q5u | BEGIN crt_get_account_tree(:1 , :2 , :3 ) ; END; |
aq8yqxyyb40nn | update sys.job$ set this_date=:1 where job=:2 |
ayr8swhks7n2y | update sys.scheduler$_job set flags = :1, start_date = :2, dist_flags = :3 where obj# = :4 |
b2gnxm5z6r51n | lock table sys.col_usage$ in exclusive mode nowait |
b6usrg82hwsa3 | call dbms_stats.gather_database_stats_job_proc ( ) |
bb0dybyq6bjsm | UPDATE NXGT_ACTR_RESULT_SET T SET T.HAS_CHILDREN = 'Y' WHERE EXISTS (SELECT 1 FROM BS_SUBACCOUNT WHERE ACCT_ID = T.TREE_NODE_ID) |
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 |
bwsz40d3hc8q7 | insert into wrh$_librarycache (snap_id, dbid, instance_number, namespace, gets, gethits, pins, pinhits, reloads, invalidations, dlm_lock_requests, dlm_pin_requests, dlm_pin_releases, dlm_invalidation_requests, dlm_invalidations) select :snap_id, :dbid, :instance_number, namespace, gets, gethits, pins, pinhits, reloads, invalidations, dlm_lock_requests, dlm_pin_requests, dlm_pin_releases, dlm_invalidation_requests, dlm_invalidations from v$librarycache |
c0gvws85ubcgq | Select owner
FROM all_objects
WHERE object_name = 'QU_VERSION'
AND object_type = 'PACKAGE'
AND owner = USER
UNION
Select owner
FROM all_synonyms
WHERE synonym_name = 'QU_VERSION' AND owner = 'PUBLIC'
UNION
Select owner
FROM all_synonyms
WHERE synonym_name = 'QU_VERSION' AND owner = USER |
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 |
c3zymn7x3k6wy | select obj#, dataobj#, part#, hiboundlen, hiboundval, flags, ts#, file#, block#, pctfree$, initrans, maxtrans, analyzetime, samplesize, rowcnt, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, pctthres$, length(bhiboundval), bhiboundval from indpart$ where bo# = :1 order by part# |
c6h3ypm205u91 | INSERT INTO NXGT_ACTR_ALL_GROUPS_ASAS (ACCT_ID, ACCT_GROUP, ACCT_NUM, ACCT_NAME, ACCT_TYPE, ACCT_TYPE_CODE, ACCT_TYPE_SORT, SUBACCOUNT_ID) WITH ACCOUNTS_AND_GROUPS AS (SELECT A.ACCT_ID , A.ACCT_GROUP , A.ACCT_NUM , A.ACCT_NAME , A.ACCT_TYPE , -1 SUBACCOUNT_ID , CASE WHEN A.ACCT_TYPE IN (0, 1) THEN 'A' ELSE 'G' END ACCT_TYPE_CODE , CASE WHEN A.ACCT_TYPE IN (0, 1) THEN 2 ELSE 1 END ACCT_TYPE_SORT FROM BS_ACCTS A START WITH A.ACCT_GROUP = :B1 CONNECT BY PRIOR A.ACCT_ID = A.ACCT_GROUP UNION ALL SELECT 0, NULL, 'root', 'root' , 4, -1, 'G' ACCT_TYPE_CODE, 1 ACCT_TYPE_SORT FROM DUAL WHERE :B1 = 0) , SUBACCOUNTS AS ( SELECT :B2 + ROW_NUMBER() OVER (ORDER BY A.ACCT_ID) AS ACCT_ID , A.ACCT_ID ACCT_GROUP , S.SUBACCOUNT_NUMBER ACCT_NUM , S.SUBACCOUNT_NAME ACCT_NAME , 999 ACCT_TYPE , S.SUBACCOUNT_ID , 'S' ACCT_TYPE_CODE , 3 ACCT_TYPE_SORT FROM ACCOUNTS_AND_GROUPS A JOIN BS_SUBACCOUNT S ON A.ACCT_ID = S.ACCT_ID WHERE A.ACCT_TYPE <> 4 ) SELECT A.ACCT_ID , A.ACCT_GROUP , A.ACCT_NUM , A.ACCT_NAME , A.ACCT_TYPE , A.ACCT_TYPE_CODE , A.ACCT_TYPE_SORT , A.SUBACCOUNT_ID FROM ACCOUNTS_AND_GROUPS A UNION ALL SELECT A.ACCT_ID , A.ACCT_GROUP , A.ACCT_NUM , A.ACCT_NAME , A.ACCT_TYPE , A.ACCT_TYPE_CODE , A.ACCT_TYPE_SORT , A.SUBACCOUNT_ID FROM SUBACCOUNTS A |
c8h3jdwaa532q | SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 |
cfk4qsrg681sz | SELECT MIN(END_INTERVAL_TIME), COUNT(*) FROM WRM$_SNAPSHOT WHERE SNAP_ID = :B2 AND DBID = :B1 |
cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# |
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 |
d1dsc597kqr7s | DELETE FROM NXGT_ACTR_RESULT_SET WHERE NODE_TYPE = 'G' AND HAS_CHILDREN = 'N' |
dcy1bgdgavcr4 | SELECT TREE_NODE_ID FROM NXGT_ACTR_RESULT_SET WHERE NODE_TYPE = 'G' AND LEVEL_NUM = 1 |
fcb5u7n0r523m | SELECT NVL(AVG((VALUE*1000.0)/DURATION), 0), NVL((((SUM(DURATION)/(60*1000))/60)*100), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A, MGMT_PERFORMANCE_NAMES B WHERE :B1 = B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.IS_TOTAL='Y' AND A.DURATION > 0 |
fsbqktj5vw6n9 |
select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(ca
st(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1 |
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 |
g52zugxj4a7kb | INSERT INTO NXGT_ACTR_AP_SNAPSHOT (ACCT_ID, APPLIED_POLICY_ID, CALENDAR_ID) SELECT AC.ACCT_ID, AP.APPLIED_POLICY_ID, AP.CALENDAR_ID FROM CRTV_CURR_ASA_APPLIED_POLICY AP JOIN NXGT_ACTR_ALL_GROUPS_ASAS AC ON AP.ASA_EXT_ID = AC.ACCT_NUM |
gc8rqv835jxv0 | MERGE INTO NXGT_ACTR_RESULT_SET T USING (SELECT SA.TREE_NODE_ID , CASE WHEN SA.APPLIED_POLICY_ID <> :B1 THEN 2 WHEN A.APPLIED_POLICY_ID = :B1 THEN 3 WHEN A.APPLIED_POLICY_ID <> :B1 THEN 4 WHEN EXISTS ( SELECT 1 FROM NXGT_ACTR_RESULT_SET WHERE PARENT_TREE_NODE_ID = SA.PARENT_TREE_NODE_ID AND CALENDAR_ID <> :B2 ) THEN 5 ELSE 1 END AS AVAILABILITY FROM NXGT_ACTR_RESULT_SET SA JOIN NXGT_ACTR_RESULT_SET A ON SA.PARENT_TREE_NODE_ID = A.TREE_NODE_ID) TSA ON (T.TREE_NODE_ID = TSA.TREE_NODE_ID) WHEN MATCHED THEN UPDATE SET AVAILABILITY=TSA.AVAILABILITY |
gfdn12rn0fg3m | SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND TARGET_TYPE = :B1 |
gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME) |
gp91kft4mft6j | select /*+ no_parallel_index(t, "I_WRI$_OPTSTAT_H_ST") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad no_expand index(t, "I_WRI$_OPTSTAT_H_ST") */ count(*) as nrw, count(distinct sys_op_lbid(475, 'L', t.rowid)) as nlb, null as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SYS"."WRI$_OPTSTAT_HISTGRM_HISTORY" t where "SYS_NC00014$" is not null |
Statistic | Total | per Second | per Trans |
Batched IO (bound) vector count | 53 | 0.00 | 0.00 |
Batched IO (full) vector count | 22 | 0.00 | 0.00 |
Batched IO block miss count | 2,990 | 0.04 | 0.24 |
Batched IO buffer defrag count | 2 | 0.00 | 0.00 |
Batched IO double miss count | 4 | 0.00 | 0.00 |
Batched IO same unit count | 123 | 0.00 | 0.01 |
Batched IO single block count | 52 | 0.00 | 0.00 |
Batched IO vector block count | 2,837 | 0.03 | 0.23 |
Batched IO vector read count | 27 | 0.00 | 0.00 |
Block Cleanout Optim referenced | 192 | 0.00 | 0.02 |
CCursor + sql area evicted | 104 | 0.00 | 0.01 |
CPU used by this session | 118,417 | 1.43 | 9.49 |
CPU used when call started | 93,245 | 1.13 | 7.48 |
CR blocks created | 3,413 | 0.04 | 0.27 |
Cached Commit SCN referenced | 4,667 | 0.06 | 0.37 |
Commit SCN cached | 75 | 0.00 | 0.01 |
DB time | 10,099,205 | 122.00 | 809.62 |
DBWR checkpoint buffers written | 616,091 | 7.44 | 49.39 |
DBWR checkpoints | 134 | 0.00 | 0.01 |
DBWR object drop buffers written | 0 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR thread checkpoint buffers written | 568,147 | 6.86 | 45.55 |
DBWR transaction table writes | 3,126 | 0.04 | 0.25 |
DBWR undo block writes | 619,065 | 7.48 | 49.63 |
HSC Compressed Segment Block Changes | 0 | 0.00 | 0.00 |
HSC Heap Segment Block Changes | 5,926,522 | 71.60 | 475.11 |
HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
HSC OLTP Compressed Blocks | 0 | 0.00 | 0.00 |
HSC OLTP Space Saving | 0 | 0.00 | 0.00 |
HSC OLTP positive compression | 0 | 0.00 | 0.00 |
HSC OLTP recursive compression | 0 | 0.00 | 0.00 |
Heap Segment Array Inserts | 200,055 | 2.42 | 16.04 |
Heap Segment Array Updates | 2,141 | 0.03 | 0.17 |
IMU CR rollbacks | 2,768 | 0.03 | 0.22 |
IMU Flushes | 1,786 | 0.02 | 0.14 |
IMU Redo allocation size | 2,607,024 | 31.49 | 209.00 |
IMU commits | 11,794 | 0.14 | 0.95 |
IMU contention | 10 | 0.00 | 0.00 |
IMU ktichg flush | 9 | 0.00 | 0.00 |
IMU pool not allocated | 211 | 0.00 | 0.02 |
IMU recursive-transaction flush | 3 | 0.00 | 0.00 |
IMU undo allocation size | 45,611,328 | 551.01 | 3,656.51 |
IMU- failed to get a private strand | 211 | 0.00 | 0.02 |
LOB table id lookup cache misses | 1 | 0.00 | 0.00 |
Number of read IOs issued | 6 | 0.00 | 0.00 |
PX local messages recv'd | 0 | 0.00 | 0.00 |
PX local messages sent | 0 | 0.00 | 0.00 |
RowCR - row contention | 0 | 0.00 | 0.00 |
RowCR attempts | 6,657 | 0.08 | 0.53 |
RowCR hits | 5,834 | 0.07 | 0.47 |
SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 12 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 199,555 | 2.41 | 16.00 |
TBS Extension: bytes extended | 0 | 0.00 | 0.00 |
TBS Extension: files extended | 0 | 0.00 | 0.00 |
TBS Extension: tasks created | 0 | 0.00 | 0.00 |
TBS Extension: tasks executed | 0 | 0.00 | 0.00 |
active txn count during cleanout | 698,556 | 8.44 | 56.00 |
application wait time | 0 | 0.00 | 0.00 |
auto extends on undo tablespace | 0 | 0.00 | 0.00 |
background checkpoints completed | 95 | 0.00 | 0.01 |
background checkpoints started | 95 | 0.00 | 0.01 |
background timeouts | 340,142 | 4.11 | 27.27 |
branch node splits | 619 | 0.01 | 0.05 |
buffer is not pinned count | 3,788,025 | 45.76 | 303.67 |
buffer is pinned count | 59,401,784 | 717.61 | 4,762.05 |
bytes received via SQL*Net from client | 44,386,140 | 536.21 | 3,558.29 |
bytes sent via SQL*Net to client | 43,030,330 | 519.83 | 3,449.60 |
calls to get snapshot scn: kcmgss | 1,026,043 | 12.40 | 82.25 |
calls to kcmgas | 474,010 | 5.73 | 38.00 |
calls to kcmgcs | 1,145,884 | 13.84 | 91.86 |
cell physical IO interconnect bytes | 23,490,330,624 | 283,776.57 | 1,883,143.39 |
change write time | 70,888 | 0.86 | 5.68 |
cleanout - number of ktugct calls | 893,079 | 10.79 | 71.60 |
cleanouts and rollbacks - consistent read gets | 9 | 0.00 | 0.00 |
cleanouts only - consistent read gets | 112,221 | 1.36 | 9.00 |
cluster key scan block gets | 501,937 | 6.06 | 40.24 |
cluster key scans | 479,717 | 5.80 | 38.46 |
commit batch/immediate performed | 251 | 0.00 | 0.02 |
commit batch/immediate requested | 251 | 0.00 | 0.02 |
commit cleanout failures: block lost | 646,669 | 7.81 | 51.84 |
commit cleanout failures: buffer being written | 1 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 200 | 0.00 | 0.02 |
commit cleanout failures: cannot pin | 3 | 0.00 | 0.00 |
commit cleanouts | 740,409 | 8.94 | 59.36 |
commit cleanouts successfully completed | 93,536 | 1.13 | 7.50 |
commit immediate performed | 251 | 0.00 | 0.02 |
commit immediate requested | 251 | 0.00 | 0.02 |
commit txn count during cleanout | 766,253 | 9.26 | 61.43 |
concurrency wait time | 61,071 | 0.74 | 4.90 |
consistent changes | 22,118,481 | 267.20 | 1,773.17 |
consistent gets | 8,989,662 | 108.60 | 720.67 |
consistent gets - examination | 2,078,972 | 25.12 | 166.66 |
consistent gets direct | 14 | 0.00 | 0.00 |
consistent gets from cache | 8,989,648 | 108.60 | 720.67 |
consistent gets from cache (fastpath) | 6,575,826 | 79.44 | 527.16 |
cursor authentications | 1,744 | 0.02 | 0.14 |
data blocks consistent reads - undo records applied | 5,516 | 0.07 | 0.44 |
db block changes | 34,366,163 | 415.16 | 2,755.02 |
db block gets | 96,130,865 | 1,161.32 | 7,706.50 |
db block gets direct | 11,460 | 0.14 | 0.92 |
db block gets from cache | 96,119,405 | 1,161.18 | 7,705.58 |
db block gets from cache (fastpath) | 235,819 | 2.85 | 18.90 |
deferred (CURRENT) block cleanout applications | 47,899 | 0.58 | 3.84 |
dirty buffers inspected | 356,705 | 4.31 | 28.60 |
drop segment calls in space pressure | 0 | 0.00 | 0.00 |
enqueue conversions | 19,484 | 0.24 | 1.56 |
enqueue releases | 1,274,339 | 15.39 | 102.16 |
enqueue requests | 1,274,389 | 15.40 | 102.16 |
enqueue timeouts | 40 | 0.00 | 0.00 |
enqueue waits | 136 | 0.00 | 0.01 |
execute count | 574,315 | 6.94 | 46.04 |
failed probes on index block reclamation | 1 | 0.00 | 0.00 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 831,281,641,947 | 10,042,355.47 | 66,641,144.94 |
frame signature mismatch | 0 | 0.00 | 0.00 |
free buffer inspected | 1,295,204 | 15.65 | 103.83 |
free buffer requested | 1,461,148 | 17.65 | 117.14 |
global undo segment hints helped | 0 | 0.00 | 0.00 |
global undo segment hints were stale | 0 | 0.00 | 0.00 |
heap block compress | 330,959 | 4.00 | 26.53 |
hot buffers moved to head of LRU | 168,781 | 2.04 | 13.53 |
immediate (CR) block cleanout applications | 112,230 | 1.36 | 9.00 |
immediate (CURRENT) block cleanout applications | 672,713 | 8.13 | 53.93 |
index crx upgrade (positioned) | 1,254 | 0.02 | 0.10 |
index crx upgrade (prefetch) | 40 | 0.00 | 0.00 |
index fast full scans (full) | 1,256 | 0.02 | 0.10 |
index fetch by key | 1,985,559 | 23.99 | 159.18 |
index scans kdiixs1 | 10,549,999 | 127.45 | 845.76 |
leaf node 90-10 splits | 50,936 | 0.62 | 4.08 |
leaf node splits | 193,491 | 2.34 | 15.51 |
lob reads | 6,763 | 0.08 | 0.54 |
lob writes | 4,888 | 0.06 | 0.39 |
lob writes unaligned | 4,888 | 0.06 | 0.39 |
local undo segment hints helped | 0 | 0.00 | 0.00 |
local undo segment hints were stale | 0 | 0.00 | 0.00 |
logons cumulative | 27,768 | 0.34 | 2.23 |
max cf enq hold time | 156 | 0.00 | 0.01 |
messages received | 87,084 | 1.05 | 6.98 |
messages sent | 87,084 | 1.05 | 6.98 |
min active SCN optimization applied on CR | 0 | 0.00 | 0.00 |
no buffer to keep pinned count | 147 | 0.00 | 0.01 |
no work - consistent read gets | 6,219,595 | 75.14 | 498.60 |
non-idle wait count | 851,421 | 10.29 | 68.26 |
non-idle wait time | 1,561,761 | 18.87 | 125.20 |
opened cursors cumulative | 539,916 | 6.52 | 43.28 |
parse count (describe) | 56 | 0.00 | 0.00 |
parse count (failures) | 189 | 0.00 | 0.02 |
parse count (hard) | 7,868 | 0.10 | 0.63 |
parse count (total) | 390,925 | 4.72 | 31.34 |
parse time cpu | 4,878 | 0.06 | 0.39 |
parse time elapsed | 23,354 | 0.28 | 1.87 |
physical read IO requests | 327,300 | 3.95 | 26.24 |
physical read bytes | 5,539,627,008 | 66,921.85 | 444,093.88 |
physical read total IO requests | 429,174 | 5.18 | 34.41 |
physical read total bytes | 7,209,239,552 | 87,091.72 | 577,941.28 |
physical read total multi block requests | 3,712 | 0.04 | 0.30 |
physical reads | 676,224 | 8.17 | 54.21 |
physical reads cache | 406,015 | 4.90 | 32.55 |
physical reads cache prefetch | 215,617 | 2.60 | 17.29 |
physical reads direct | 270,209 | 3.26 | 21.66 |
physical reads direct (lob) | 6 | 0.00 | 0.00 |
physical reads direct temporary tablespace | 269,150 | 3.25 | 21.58 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 468,814 | 5.66 | 37.58 |
physical write bytes | 10,794,213,376 | 130,400.24 | 865,336.97 |
physical write total IO requests | 572,598 | 6.92 | 45.90 |
physical write total bytes | 16,281,091,072 | 196,684.85 | 1,305,202.11 |
physical write total multi block requests | 48,826 | 0.59 | 3.91 |
physical writes | 1,317,653 | 15.92 | 105.63 |
physical writes direct | 258,567 | 3.12 | 20.73 |
physical writes direct (lob) | 14 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 257,455 | 3.11 | 20.64 |
physical writes from cache | 1,059,086 | 12.79 | 84.90 |
physical writes non checkpoint | 1,278,715 | 15.45 | 102.51 |
pinned buffers inspected | 455 | 0.01 | 0.04 |
pinned cursors current | 1 | 0.00 | 0.00 |
prefetch clients - default | 0 | 0.00 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 73 | 0.00 | 0.01 |
process last non-idle time | 86,400 | 1.04 | 6.93 |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
recursive calls | 4,470,942 | 54.01 | 358.42 |
recursive cpu usage | 104,429 | 1.26 | 8.37 |
redo blocks checksummed by FG (exclusive) | 4,438,861 | 53.62 | 355.85 |
redo blocks written | 8,773,792 | 105.99 | 703.37 |
redo buffer allocation retries | 4,710 | 0.06 | 0.38 |
redo entries | 10,862,731 | 131.23 | 870.83 |
redo log space requests | 26,355 | 0.32 | 2.11 |
redo log space wait time | 245,398 | 2.96 | 19.67 |
redo ordering marks | 12 | 0.00 | 0.00 |
redo size | 4,397,111,512 | 53,119.61 | 352,502.13 |
redo size for direct writes | 832 | 0.01 | 0.07 |
redo synch time | 123,654 | 1.49 | 9.91 |
redo synch writes | 28,246 | 0.34 | 2.26 |
redo wastage | 9,476,724 | 114.48 | 759.72 |
redo write time | 158,666 | 1.92 | 12.72 |
redo writes | 40,544 | 0.49 | 3.25 |
rollback changes - undo records applied | 3,989 | 0.05 | 0.32 |
rollbacks only - consistent read gets | 3,381 | 0.04 | 0.27 |
root node splits | 41 | 0.00 | 0.00 |
rows fetched via callback | 265,043 | 3.20 | 21.25 |
scheduler wait time | 664 | 0.01 | 0.05 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 259,409 | 3.13 | 20.80 |
session logical reads | 105,120,527 | 1,269.92 | 8,427.17 |
shared hash latch upgrades - no wait | 78,930 | 0.95 | 6.33 |
sorts (disk) | 8 | 0.00 | 0.00 |
sorts (memory) | 406,281 | 4.91 | 32.57 |
sorts (rows) | 41,696,617 | 503.72 | 3,342.68 |
space was found by tune down | 0 | 0.00 | 0.00 |
space was not found by tune down | 0 | 0.00 | 0.00 |
sql area evicted | 13,705 | 0.17 | 1.10 |
sql area purged | 278 | 0.00 | 0.02 |
steps of tune down ret. in space pressure | 0 | 0.00 | 0.00 |
summed dirty queue length | 3,234,432 | 39.07 | 259.29 |
switch current to new buffer | 70,671 | 0.85 | 5.67 |
table fetch by rowid | 30,520,060 | 368.70 | 2,446.69 |
table fetch continued row | 1,166 | 0.01 | 0.09 |
table scan blocks gotten | 914,940 | 11.05 | 73.35 |
table scan rows gotten | 94,114,257 | 1,136.95 | 7,544.83 |
table scans (direct read) | 0 | 0.00 | 0.00 |
table scans (long tables) | 128 | 0.00 | 0.01 |
table scans (short tables) | 74,620 | 0.90 | 5.98 |
temp space allocated (bytes) | 8,388,608 | 101.34 | 672.49 |
total cf enq hold time | 255,832 | 3.09 | 20.51 |
total number of cf enq holders | 2,163 | 0.03 | 0.17 |
total number of times SMON posted | 14 | 0.00 | 0.00 |
transaction rollbacks | 251 | 0.00 | 0.02 |
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 | 3,398,020,448 | 41,050.02 | 272,408.24 |
user I/O wait time | 452,530 | 5.47 | 36.28 |
user calls | 364,070 | 4.40 | 29.19 |
user commits | 12,367 | 0.15 | 0.99 |
user rollbacks | 107 | 0.00 | 0.01 |
workarea executions - onepass | 56 | 0.00 | 0.00 |
workarea executions - optimal | 142,561 | 1.72 | 11.43 |
write clones created in background | 33 | 0.00 | 0.00 |
write clones created in foreground | 453 | 0.01 | 0.04 |