Enter value for report_name: awrrpt_1_500_0800.html
Using the report name awrrpt_1_500_0800.html
SQL Id | SQL Text |
05xcf43d9psvm | SELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES |
089dbukv1aanh | SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL |
08bqjmf8490s2 | SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 |
08vznc16ycuag | SELECT SYS_GUID() FROM SYS.DUAL |
0j6d9y40st3k1 | select client_name, status from DBA_AUTOTASK_CLIENT where lower(client_name) = 'sql tuning advisor' |
0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
0njp59jttu2z9 | DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 AND ROWNUM <= :B1 |
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') |
15aftu6tf4xd0 |
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.KQF
CODTY 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.NONEQUIJOIN_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#(+) |
1cdcp34r6c7px |
/* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("RETRY_COUNT")), to_char(substrb(dump(min("RETRY_COUNT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RETRY_COUNT"), 16, 0, 32), 1, 120)), to_char(count("GOOD_COUNT")), to_char(substrb(dump(min("GOOD_COUNT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("GOOD_COUNT"), 16, 0, 32), 1, 120)), to_char(count("LG_JOB_LOG_ID")), to_char(substrb(dump(min("LG_JOB_LOG_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_JOB_LOG_ID"), 16, 0, 32), 1, 120)), to_char(count("LG_DATE")), to_char(substrb(dump(min("LG_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_DATE"), 16, 0, 32), 1, 120)), to_char(count("LG_PRIORITY")), to_char(substrb(dump(min("LG_PRIORITY
"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_PRIORITY"), 16, 0, 32), 1, 120)), to_char(count("LG_DURATION")), to_char(substrb(dump(min("LG_DURATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_DURATION"), 16, 0, 32), 1, 120)), to_char(count("LG_CPU_TIME")), to_char(substrb(dump(min("LG_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(count("LG_TEMP")), to_char(substrb(dump(min("LG_TEMP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_TEMP"), 16, 0, 32), 1, 120)), to_char(count("LG_DOP")), to_char(substrb(dump(min("LG_DOP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_DOP"), 16, 0, 32), 1, 120)), to_char(count("LG_IO_RATE")), to_char(substrb(dump(min("LG_IO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_IO_RATE"), 16, 0, 32), 1
, 120)), to_char(count("LG_UNDO_RATE")), to_char(substrb(dump(min("LG_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(count("LG_CPU_WAIT")), to_char(substrb(dump(min("LG_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LG_IO_WAIT")), to_char(substrb(dump(min("LG_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LG_UNDO_WAIT")), to_char(substrb(dump(min("LG_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LG_TEMP_WAIT")), to_char(substrb(dump(min("LG_TEMP_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_TEMP_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LG_CONCURRENCY")), to_cha
r(substrb(dump(min("LG_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(count("LG_CONTENTION")), to_char(substrb(dump(min("LG_CONTENTION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LG_CONTENTION"), 16, 0, 32), 1, 120)), to_char(count("LT_JOB_LOG_ID")), to_char(substrb(dump(min("LT_JOB_LOG_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_JOB_LOG_ID"), 16, 0, 32), 1, 120)), to_char(count("LT_DATE")), to_char(substrb(dump(min("LT_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_DATE"), 16, 0, 32), 1, 120)), to_char(count("LT_PRIORITY")), to_char(substrb(dump(min("LT_PRIORITY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_PRIORITY"), 16, 0, 32), 1, 120)), to_char(count("LT_TERM_CODE")), to_char(substrb(dump(min("LT_TERM_CODE"), 16, 0, 32),
1, 120)), to_char(substrb(dump(max("LT_TERM_CODE"), 16, 0, 32), 1, 120)), to_char(count("LT_ERROR")), to_char(substrb(dump(min("LT_ERROR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_ERROR"), 16, 0, 32), 1, 120)), to_char(count("LT_DURATION")), to_char(substrb(dump(min("LT_DURATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_DURATION"), 16, 0, 32), 1, 120)), to_char(count("LT_CPU_TIME")), to_char(substrb(dump(min("LT_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(count("LT_TEMP")), to_char(substrb(dump(min("LT_TEMP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_TEMP"), 16, 0, 32), 1, 120)), to_char(count("LT_DOP")), to_char(substrb(dump(min("LT_DOP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_DOP"), 16, 0, 32), 1, 120)), to_char(count(
"LT_IO_RATE")), to_char(substrb(dump(min("LT_IO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_IO_RATE"), 16, 0, 32), 1, 120)), to_char(count("LT_UNDO_RATE")), to_char(substrb(dump(min("LT_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(count("LT_CPU_WAIT")), to_char(substrb(dump(min("LT_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LT_IO_WAIT")), to_char(substrb(dump(min("LT_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LT_UNDO_WAIT")), to_char(substrb(dump(min("LT_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LT_TEMP_WAIT")), to_char(substrb(dump(min("LT_TEM
P_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_TEMP_WAIT"), 16, 0, 32), 1, 120)), to_char(count("LT_CONCURRENCY")), to_char(substrb(dump(min("LT_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(count("LT_CONTENTION")), to_char(substrb(dump(min("LT_CONTENTION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LT_CONTENTION"), 16, 0, 32), 1, 120)), to_char(count("MG_DURATION")), to_char(substrb(dump(min("MG_DURATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_DURATION"), 16, 0, 32), 1, 120)), to_char(count("MG_CPU_TIME")), to_char(substrb(dump(min("MG_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(count("MG_TEMP")), to_char(substrb(dump(min("MG_TEMP"), 16, 0, 32), 1, 120)), to_char(substrb(dump
(max("MG_TEMP"), 16, 0, 32), 1, 120)), to_char(count("MG_DOP")), to_char(substrb(dump(min("MG_DOP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_DOP"), 16, 0, 32), 1, 120)), to_char(count("MG_IO_RATE")), to_char(substrb(dump(min("MG_IO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_IO_RATE"), 16, 0, 32), 1, 120)), to_char(count("MG_UNDO_RATE")), to_char(substrb(dump(min("MG_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(count("MG_CPU_WAIT")), to_char(substrb(dump(min("MG_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_CPU_WAIT"), 16, 0, 32), 1, 120)), to_char(count("MG_IO_WAIT")), to_char(substrb(dump(min("MG_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_IO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("MG_UNDO_WAIT
")), to_char(substrb(dump(min("MG_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_UNDO_WAIT"), 16, 0, 32), 1, 120)), to_char(count("MG_TEMP_WAIT")), to_char(substrb(dump(min("MG_TEMP_WAIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_TEMP_WAIT"), 16, 0, 32), 1, 120)), to_char(count("MG_CONCURRENCY")), to_char(substrb(dump(min("MG_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_CONCURRENCY"), 16, 0, 32), 1, 120)), to_char(count("MG_CONTENTION")), to_char(substrb(dump(min("MG_CONTENTION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MG_CONTENTION"), 16, 0, 32), 1, 120)), to_char(count("INFO_FIELD_1")), to_char(substrb(dump(min("INFO_FIELD_1"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INFO_FIELD_1"), 16, 0, 32), 1, 120)), to_char(count(case when "INFO_FIELD_2" is null then null else 1
end)), to_char(sum(sys_op_opnsize("INFO_FIELD_2"))), to_char(count("INFO_FIELD_3")), to_char(substrb(dump(min("INFO_FIELD_3"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INFO_FIELD_3"), 16, 0, 32), 1, 120)), to_char(count("INFO_FIELD_4")), to_char(substrb(dump(min("INFO_FIELD_4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INFO_FIELD_4"), 16, 0, 32), 1, 120)), to_char(count("CLIENT_ID")), to_char(substrb(dump(min("CLIENT_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CLIENT_ID"), 16, 0, 32), 1, 120)), to_char(count("OPERATION_ID")), to_char(substrb(dump(min("OPERATION_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OPERATION_ID"), 16, 0, 32), 1, 120)), to_char(count("TARGET_TYPE")), to_char(substrb(dump(min("TARGET_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TARGET_TYPE"), 16, 0, 32), 1, 120))
, to_char(count("TARGET_NAME")), to_char(substrb(dump(min("TARGET_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TARGET_NAME"), 16, 0, 32), 1, 120)), to_char(count("ATTRIBUTES")), to_char(substrb(dump(min("ATTRIBUTES"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ATTRIBUTES"), 16, 0, 32), 1, 120)), to_char(count("ATTRIBUTES_OVERRIDE")), to_char(substrb(dump(min("ATTRIBUTES_OVERRIDE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ATTRIBUTES_OVERRIDE"), 16, 0, 32), 1, 120)), to_char(count("TASK_PRIORITY")), to_char(substrb(dump(min("TASK_PRIORITY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("TASK_PRIORITY"), 16, 0, 32), 1, 120)), to_char(count("PRIORITY_OVERRIDE")), to_char(substrb(dump(min("PRIORITY_OVERRIDE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PRIORITY_OVERRIDE"), 16, 0, 32), 1, 120)), to_char(count(
"STATUS")), to_char(substrb(dump(min("STATUS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("STATUS"), 16, 0, 32), 1, 120)), to_char(count("ARG_4")), to_char(substrb(dump(min("ARG_4"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ARG_4"), 16, 0, 32), 1, 120)), to_char(count("ARG_5")), to_char(substrb(dump(min("ARG_5"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ARG_5"), 16, 0, 32), 1, 120)), to_char(count("ARG_6")), to_char(substrb(dump(min("ARG_6"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ARG_6"), 16, 0, 32), 1, 120)), to_char(count("WINDOW_NAME")), to_char(substrb(dump(min("WINDOW_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("WINDOW_NAME"), 16, 0, 32), 1, 120)), to_char(count("CURR_JOB_NAME")), to_char(substrb(dump(min("CURR_JOB_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max(
"CURR_JOB_NAME"), 16, 0, 32), 1, 120)), to_char(count("CURR_WIN_START")), to_char(substrb(dump(min("CURR_WIN_START"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CURR_WIN_START"), 16, 0, 32), 1, 120)), to_char(count("EST_TYPE")), to_char(substrb(dump(min("EST_TYPE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_TYPE"), 16, 0, 32), 1, 120)), to_char(count("EST_WEIGHT")), to_char(substrb(dump(min("EST_WEIGHT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_WEIGHT"), 16, 0, 32), 1, 120)), to_char(count("EST_DURATION")), to_char(substrb(dump(min("EST_DURATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_DURATION"), 16, 0, 32), 1, 120)), to_char(count("EST_CPU_TIME")), to_char(substrb(dump(min("EST_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_CPU_TIME"), 16, 0, 32), 1, 120)), to_char(coun
t("EST_TEMP")), to_char(substrb(dump(min("EST_TEMP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_TEMP"), 16, 0, 32), 1, 120)), to_char(count("EST_DOP")), to_char(substrb(dump(min("EST_DOP"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_DOP"), 16, 0, 32), 1, 120)), to_char(count("EST_IO_RATE")), to_char(substrb(dump(min("EST_IO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_IO_RATE"), 16, 0, 32), 1, 120)), to_char(count("EST_UNDO_RATE")), to_char(substrb(dump(min("EST_UNDO_RATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EST_UNDO_RATE"), 16, 0, 32), 1, 120)) from "SYS"."KET$_CLIENT_TASKS" t /* NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL,
NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/ |
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 (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 ((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 |
24dkx03u3rj6k | SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE' |
24g90qj2b7ywk | BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); BEGIN MGMT_JOB_ENGINE.process_wait_step(:2);END; EMDW_LOG.set_context; END; |
2mysbczfp729x | SELECT /*+ INDEX(ping mgmt_emd_ping_idx_01) */ TGT.TARGET_GUID, TGT.EMD_URL, PING.STATUS FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC, MGMT_TARGETS TGT, MGMT_CURRENT_AVAILABILITY CAVAIL WHERE PING.TARGET_GUID = TGT.TARGET_GUID AND PING.TARGET_GUID = CAVAIL.TARGET_GUID AND PING.TARGET_GUID = PINGC.TARGET_GUID AND TGT.TARGET_TYPE = :B4 AND PING.MAX_INACTIVE_TIME > 0 AND CAVAIL.CURRENT_STATUS != :B3 AND PING.STATUS = :B2 AND PING.PING_JOB_NAME IS NULL AND ( (:B1 -PING.LAST_HEARTBEAT_UTC)*24*60*60 > PING.MAX_INACTIVE_TIME) AND ( (:B1 -PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2) ORDER BY TGT.EMD_URL |
330q95smuwnv9 | update hist_head$ set bucket_cnt=:3, row_cnt=:4, cache_cnt=:5, null_cnt=:6, timestamp#=:7, sample_size=:8, minimum=:9, maximum=:10, distcnt=:11, lowval=:12, hival=:13, density=:14, spare1=:15, spare2=:16, avgcln=:17, col#=:18 where obj#=:1 and intcol#=:2 |
34rks4d5suuxz | SELECT COUNT(FAILOVER_ID) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP < :B1 /(24*60*60) |
350myuyx0t1d6 |
insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
|
39c8q6w3s3r8y | UPDATE MGMT_EMD_PING_CHECK SET LAST_CHECKED_UTC = :B1 WHERE TARGET_GUID IN (SELECT PING.TARGET_GUID FROM MGMT_EMD_PING PING, MGMT_EMD_PING_CHECK PINGC WHERE PING.TARGET_GUID = PINGC.TARGET_GUID AND PING.MAX_INACTIVE_TIME > 0 AND ( (PING.STATUS = :B3 ) OR (PING.STATUS = :B2 ) ) AND (:B1 - PINGC.LAST_CHECKED_UTC)*24*60*60 >= (PING.MAX_INACTIVE_TIME)/2) |
3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values) |
3d40u5r2jfcsd | update ind$ set ts#=:2, file#=:3, block#=:4, intcols=:5, type#=:6, flags=:7, property=:8, pctfree$=:9, initrans=:10, maxtrans=:11, blevel=:12, leafcnt=:13, distkey=:14, lblkkey=:15, dblkkey=:16, clufac=:17, cols=:18, analyzetime=:19, samplesize=:20, dataobj#=:21, degree=decode(:22, 1, null, :22), instances=decode(:23, 1, null, :23), rowcnt=:24, pctthres$=:31*256+:25, indmethod#=:26, trunccnt=:27, spare4=:29, spare2=:30, spare6=:32where obj#=:1 |
3wrrjm9qtr2my |
SELECT T.CLIENT_ID, T.OPERATION_ID, T.TARGET_TYPE, T.TARGET_NAME, T.CURR_JOB_NAME, TO_NUMBER(BITAND(T.ATTRIBUTES, 131072)), CASE NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'RUNNING' THEN 1 WHEN 'DISABLED' THEN 2 WHEN 'SCHEDULED' THEN 3 WHEN 'RETRY SCHEDULED' THEN 99 WHEN 'COMPLETED' THEN 99 WHEN 'BROKEN' THEN 99 WHEN 'FAILED' THEN 99 WHEN 'REMOTE' THEN 99 WHEN 'SUCCEEDED' THEN 99 WHEN 'STOPPED' THEN 99 WHEN 'CHAIN_STALLED' THEN 99 ELSE 99 END AS CONSOLIDATED_STATE, CASE NVL(JRD.STATUS, 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'SUCCEEDED' THEN 10 WHEN 'FAILED' THEN 11 WHEN 'STOPPED' THEN CASE WHEN JRD.ADDITIONAL_INFO LIKE '%called by user%' THEN 12 WHEN JRD.ADDITIONAL_INFO LIKE '%window was closed%' THEN 13 WHEN JRD.ADDITIONAL_INFO LIKE 'ORA-01014%' THEN 14 ELSE 15 END ELSE 99 END AS STATUS, NVL(JRD.RUN_DURATION, INTERVAL '0' SECOND), NVL(JRD.CPU_USED, INTERVAL '0' SECOND), NVL(JRD.ERROR#, 0), NVL
(JRD.STATUS, 'NO LOG ENTRY') || '(jrd)' AS DBG_STATUS, NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') ||'(jobs)' AS DBG_STATE, NVL(JRD.LOG_DATE, TIMESTAMP '2001-01-01 01:01:01.01 +01:01'), NVL(JRD.LOG_ID, 0) FROM KET$_CLIENT_TASKS T, DBA_SCHEDULER_JOB_RUN_DETAILS JRD WHERE T.CURR_JOB_NAME IS NOT NULL AND T.CURR_JOB_NAME = JRD.JOB_NAME(+) AND 'SYS' = JRD.OWNER(+) |
3x0kdm7z3yasw | SELECT TARGET_TYPE, TYPE_META_VER, NVL(CATEGORY_PROP_1, ' '), NVL(CATEGORY_PROP_2, ' '), NVL(CATEGORY_PROP_3, ' '), NVL(CATEGORY_PROP_4, ' '), NVL(CATEGORY_PROP_5, ' ') FROM MGMT_TARGETS WHERE TARGET_GUID = :B1 |
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(NUL
L 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 sela
p, 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 captur
e sqls with the full set of execution stats */ bitand(nvl(s.flag, 0), 1) = 0) WHERE snap_id >= :begin_snap and snap_id <= :end_snap AND command_type in (1, 2, 3, 6, 7, 189) AND sql_id = :sqlid AND plan_hash_value = :phv GROUP BY sql_id, plan_hash_value) T2 WHERE T1.sql_id = T2.sql_id AND T1.plan_hash_value = T2.plan_hash_value AND T1.snap_id = T2.snap_id AND T1.instance_number = T2.instance_number)) S ) |
459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
47a50dvdgnxc2 | update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4 |
4dy1xm4nxc0gf | insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro, total_waits_fg, total_timeouts_fg, time_waited_micro_fg from v$system_event order by event_id |
4g46czps3t55u | SELECT sum(case when snap_id = :begin_snap_id then value else 0 end) as begin_sga, sum(case when snap_id = :end_snap_id then value else 0 end) as end_sga FROM WRH$_SGA sga WHERE sga.dbid = :dbid AND sga.instance_number = :inst_num AND (sga.snap_id = :begin_snap_id OR sga.snap_id = :end_snap_id ) |
4jrfrtx4u6zcx |
SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 ,
:B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), M
GMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POL
ICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC |
4nw0ag3rg25h1 | INSERT INTO mgmt_db_hdm_metric_helper(COLLECTION_TIMESTAMP, TARGET_GUID, TASK_AVAILABLE, TASK_COUNT) VALUES ( :1, :2, :3, :4) |
4y1y43113gv8f | delete from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 |
5fk0v8km2f811 | select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance |
5hfunyv38vwfp | SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B9 , :B8 , :B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND START_TIME <= :B2 AND ROWNUM <= :B1 |
5k5v1ah25fb2c | BEGIN EMD_LOADER.UPDATE_CURRENT_METRICS(:1, :2, :3, :4, :5, :6); END; |
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 |
5r8jah3jm5au2 | SELECT TARGETS.TARGET_NAME, TARGETS.TARGET_TYPE, TARGETS.TIMEZONE_REGION, TARGETS.EMD_URL, NVL(CAST(SYSTIMESTAMP AT TIME ZONE TARGETS.TIMEZONE_REGION AS DATE), :B2 ) FROM MGMT_TARGETS TARGETS WHERE TARGETS.TARGET_GUID = :B1 |
5uy533jsc8hyh | DELETE MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1 |
5zruc4v6y32f9 | DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN DECLARE ename VARCHAR2(30); BEGIN ename := dbms_sqltune.execute_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
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 |
63n9pwutt8yzw |
MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 5 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 + CASE WHEN ((BITAND(T.FLAGS, 16) = 16 AND (BITAND(M.FLAGS, 1) != 0
OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 16) != 16) THEN 0 ELSE 128 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O.FLAGS, 128) != 128 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND BITAND(T.PROPERTY, 4294967296) != 4294967296 AND NOT (BITAND(O.FLAGS, 16) = 16 AND
(O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME IN ('SUMDELTA$', 'SNAP_XCMT$')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.I
NSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND B
ITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL,
'TRUE') * :B6 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (
BITAND(T.FLAGS, 2) != 2)) ) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL
(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 34 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B8 ) <> 0
) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# T
YPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, SYS.OPTSTAT_USER_PREFS$ P, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T.ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(CM.BOBJ#, :B10 ) IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAGS, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * CM.ROWCNT))) AND CM.LOCKED = 0
AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 6 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 + CASE WHEN ((BITAND(T.FLAGS, 16) = 16 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 16) != 16) THEN 0 EL
SE 128 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND I.TYPE# = 4 AND I.BO# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE#(+) AND I.BLOCK# = S.BLOCK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) !=
16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(TP.ROWCNT, (TP.ROWCNT + M.INSERTS - M.DELETES)))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(TP.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INS
ERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT)) OR BITAND(TP.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OPTSTAT_USER_PREFS$ P WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND OT.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND T.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT))) OR (BITA
ND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B2 ) <> 0) AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER# = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 20 TYPE#,
64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.PART# PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B7 ) <> 0) AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.SUBPART# PART#, I.POBJ# BO#, NULL LOC_STALE_PCT FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE (
DBMS_STATS_INTERNAL.GATHER_INDEX(IND.BO#, :B10 ) IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLAGS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0,
ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B5 , :B4 , NEW.PART#, NEW.BO#) |
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
|
6amygb1ygg2y7 | INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5) |
6k5agh28pr3wp | select propagation_name streams_name, 'PROPAGATION' streams_type, '"'||destination_queue_owner||'"."'||destination_queue_name||'"@'||destination_dblink address, queue_table, owner, source_queue_name from dba_queues, dba_propagation where owner=SOURCE_QUEUE_OWNER and SOURCE_QUEUE_NAME=name |
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 ) |
6v7n0y2bq89n8 | BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1); MGMT_JOB_ENGINE.get_scheduled_steps(:2, :3, :4, :5); EMDW_LOG.set_context; END; |
73629tmfbjzrh | DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN BEGIN ORACLE_OCM.MGMT_DB_LL_METRICS.COLLECT_CONFIG_METRICS('ORACLE_OCM_CONFIG_DIR'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
74fnxs1kfd150 | DELETE FROM MGMT_BLACKOUT_WINDOWS WHERE TARGET_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B4 ) AND END_TIME IS NOT NULL AND END_TIME < (:B3 - (1/24)) AND STATUS IN (:B2 , :B1 ) |
772s25v1y0x8k | select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice |
7av8js40455qb | SELECT TARGET_GUID FROM MGMT_TARGETS WHERE EMD_URL = :B2 AND TARGET_TYPE = :B1 |
7d92gmwphtza8 | SELECT OWNER, JOB_NAME, COMMENTS FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME LIKE 'EM_IDX_STAT_JOB%' AND UPPER(OWNER) = 'DBSNMP' |
7hskd14849h8k | SELECT GREATEST(0, NVL(TRUNC(TO_NUMBER(VALUE)/60, 2), 0)) FROM MGMT_OMS_PARAMETERS WHERE NAME='loaderOldestFile' AND HOST_URL = :B1 |
7mdacxfm37utk | SELECT COUNT(*) FROM MGMT_FAILOVER_TABLE WHERE SYS_EXTRACT_UTC(SYSTIMESTAMP)-LAST_TIME_STAMP_UTC > NUMTODSINTERVAL(HEARTBEAT_INTERVAL*:B1 , 'SECOND') |
7qqnad1j615m7 | SELECT HOST_URL FROM MGMT_FAILOVER_TABLE WHERE FAILOVER_ID = :B1 |
7qx7y9h2rkt9g | SELECT ddf.file_name file_name, vdf.status status, ddf.tablespace_name tablespace_name, '', ddf.autoextensible autoextensible, ddf.increment_by increment_by, ddf.maxbytes max_file_size, vdf.create_bytes, 'NA' os_storage FROM sys.dba_data_files ddf, v$datafile vdf /*+ all_rows use_concat */ WHERE (ddf.file_name = vdf.name) UNION ALL SELECT dtf.file_name file_name, vtf.status status, dtf.tablespace_name tablespace_name, '', dtf.autoextensible autoextensible, dtf.increment_by increment_by, dtf.maxbytes max_file_size, vtf.create_bytes, 'NA' os_storage FROM sys.dba_temp_files dtf, v$tempfile vtf WHERE (dtf.file_id = vtf.file#) |
7sx5p1ug5ag12 | SELECT SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1 |
7tt3tfgb57599 | delete /*+ index(mm) */ from sys.mon_mods_all$ mm where obj# = :1 |
7vcwzqf7mgk3b | INSERT INTO MGMT_JOB_EXECUTION (JOB_ID, EXECUTION_ID, STEP_ID, SOURCE_STEP_ID, ORIGINAL_STEP_ID, RESTART_MODE, STEP_NAME, STEP_TYPE, COMMAND_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, PARENT_STEP_ID, STEP_STATUS, START_TIME, TIMEZONE_REGION) VALUES (NULL, NULL, :B5 , NULL, NULL, 0, :B4 , :B3 , :B2 , NULL, NULL, NULL, :B1 , MGMT_JOB_ENGINE.SYSDATE_UTC(), 'UTC') |
7wt7phk4xns75 | select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status |
81ky0n97v4zsg | /* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select sid from v$mystat where rownum=1) |
84k66tf2s7y1c | insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits - total_waits_fg, total_timeouts - total_timeouts_fg, time_waited_micro - time_waited_micro_fg from v$system_event where (total_waits - total_waits_fg) > 0 order by event_id |
85snhhhd1qmt7 | SELECT NVL(TO_NUMBER(SUM(VALUE)), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME = 'EMD_NOTIFICATION.NotificationDelivery Subsystem' AND TIME > (SYSDATE-(1/(24*6))) AND HOST_URL = :B1 |
86521pa77y28j | SELECT (case when snap_id = :begin_snap_id then 1 else 0 end) as start_snap, (case when name = 'maximum PGA allocated' then 1 when name = 'total PGA allocated' then 2 when name = 'over allocation count' then 3 when name = 'recompute count (total)' then 4 else 0 end) as stat_id, value FROM WRH$_PGASTAT pga WHERE pga.dbid = :dbid AND pga.instance_number = :inst_num AND (pga.snap_id = :begin_snap_id OR pga.snap_id = :end_snap_id ) AND pga.name IN ( 'maximum PGA allocated' , 'total PGA allocated' , 'over allocation count' , 'recompute count (total)' ) ORDER BY snap_id, stat_id |
8kzksw8m2rk68 | SELECT NVL(VALUE, 'None') FROM MGMT_OMS_PARAMETERS WHERE NAME='loaderDirectory' AND HOST_URL = :B1 |
8p447s6p0rv6b | select java_pool_size_for_estimate s, java_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$java_pool_advice |
8p9z2ztb272bm | SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number |
8t43xdhf4d9x2 | SELECT CONTEXT_TYPE_ID, CONTEXT_TYPE, TRACE_LEVEL, NULL, NULL FROM EMDW_TRACE_CONFIG WHERE CONTEXT_TYPE = UPPER(:B1 ) |
8vj58v5cxstjj |
SELECT /*+ ordered use_nl(u io i ito t itu po) */ IO.OBJ# IOBJN, I.TYPE# ITYPE, I.FLAGS IFLAGS, I.PROPERTY IPROP, I.INTCOLS IINTCOLS, NVL(I.DEGREE, 1), I.ANALYZETIME, ITU.NAME TOWN, ITO.NAME TAB, I.BO# TOBJN, T.FLAGS TFLAGS, T.PROPERTY TPROP, ITO.TYPE# TTYPE, CASE WHEN BITAND(T.FLAGS, 16) = 0 THEN NULL ELSE T.ROWCNT END NROWS, PO.PARTTYPE PTYPE, PO.PARTCNT PCNT, PO.PARTKEYCOLS PTKCOLS, PO.FLAGS PFLAGS, MOD(PO.SPARE2, 256) SPTYPE FROM SYS.USER$ U, SYS.OBJ$ IO, SYS.IND$ I, SYS.OBJ$ ITO, SYS.USER$ ITU, SYS.TAB$ T, PARTOBJ$ PO WHERE U.NAME=:B2 AND IO.NAME=:B1 AND IO.OWNER#=U.USER# AND IO.TYPE#=1 AND IO.OBJ#=I.OBJ# AND ITO.OBJ#=I.BO# AND ITO.OWNER#=ITU.USER# AND ITO.OBJ#=T.OBJ# AND IO.OBJ#=PO.OBJ#(+) UNION ALL SELECT /*+ ordered use_nl(u io i ito t itu) */ IO.OBJ# IOBJN, I.TYPE# ITYPE, I.FLAGS IFLAGS, I.PROPERTY IPROP, I.INTCOLS IINTCOLS, NVL(I.DEGREE, 1), I.ANALYZETIME, ITU.NAME TOWN, ITO.NAME TAB, I.BO# TOBJN, 0 TFLAGS, 0 TPROP, ITO.TYPE# TTYPE, NULL NROWS, NULL PTYPE, N
ULL PCNT, NULL PTKCOLS, NULL PFLAGS, NULL SPTYPE FROM SYS.USER$ U, SYS.OBJ$ IO, SYS.IND$ I, SYS.OBJ$ ITO, SYS.USER$ ITU, SYS.CLU$ T WHERE U.NAME=:B2 AND IO.NAME=:B1 AND IO.OWNER#=U.USER# AND IO.TYPE#=1 AND IO.OBJ#=I.OBJ# AND ITO.OBJ#=I.BO# AND ITO.OWNER#=ITU.USER# AND ITO.OBJ#=T.OBJ# |
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 |
9dhn1b8d88dpf |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.nex
t_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1),
decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.cla
ss_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name
= 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and 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 |
9dy457uf4uxzd |
SELECT /*+ all_rows */ '"'||UI.NAME||'"' IND_OWNER, '"'||OIP.NAME||'"' IND_NAME, '"'||OIP.SUBNAME||'"' PART_NAME, OIP.OBJ# OBJ_NUM, I.PROPERTY IPROP FROM SYS.USER$ UT, SYS.OBJ$ OTP, SYS.TABPART$ TP, SYS.IND$ I, SYS.PARTOBJ$ PO, SYS.INDPART$ IP, SYS.OBJ$ OIP, SYS.USER$ UI WHERE UT.NAME = :B3 AND UT.USER# = OTP.OWNER# AND OTP.NAME = :B2 AND OTP.SUBNAME = :B1 AND OTP.NAMESPACE = 1 AND OTP.REMOTEOWNER IS NULL AND OTP.LINKNAME IS NULL AND OTP.TYPE# = 19 AND OTP.OBJ# = TP.OBJ# AND TP.BO# = I.BO# AND I.OBJ# = PO.OBJ# AND BITAND(PO.FLAGS, 1) = 1 AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND IP.OBJ# = OIP.OBJ# AND OIP.OWNER# = UI.USER# UNION ALL SELECT '"'||UI.NAME||'"' IND_OWNER, '"'||OIP.NAME||'"' IND_NAME, '"'||OIP.SUBNAME||'"' PART_NAME, OIP.OBJ# OBJ_NUM, I.PROPERTY IPROP FROM SYS.USER$ UT, SYS.OBJ$ OTP, SYS.TABCOMPART$ TP, SYS.IND$ I, SYS.PARTOBJ$ PO, SYS.INDCOMPART$ IP, SYS.OBJ$ OIP, SYS.USER$ UI WHERE UT
.NAME = :B3 AND UT.USER# = OTP.OWNER# AND OTP.NAME = :B2 AND OTP.SUBNAME = :B1 AND OTP.NAMESPACE = 1 AND OTP.REMOTEOWNER IS NULL AND OTP.LINKNAME IS NULL AND OTP.TYPE# = 19 AND OTP.OBJ# = TP.OBJ# AND TP.BO# = I.BO# AND I.OBJ# = PO.OBJ# AND BITAND(PO.FLAGS, 1) = 1 AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND IP.OBJ# = OIP.OBJ# AND OIP.OWNER# = UI.USER# UNION ALL SELECT '"'||UI.NAME||'"' IND_OWNER, '"'||OIS.NAME||'"' IND_NAME, '"'||OIS.SUBNAME||'"' PART_NAME, OIS.OBJ# OBJ_NUM, I.PROPERTY IPROP FROM SYS.USER$ UT, SYS.OBJ$ OTS, SYS.TABSUBPART$ TSP, SYS.TABCOMPART$ TP, SYS.IND$ I, SYS.PARTOBJ$ PO, SYS.INDCOMPART$ IP, SYS.INDSUBPART$ ISP, SYS.OBJ$ OIS, SYS.USER$ UI WHERE UT.NAME = :B3 AND UT.USER# = OTS.OWNER# AND OTS.NAME = :B2 AND OTS.SUBNAME = :B1 AND OTS.NAMESPACE = 1 AND OTS.REMOTEOWNER IS NULL AND OTS.LINKNAME IS NULL AND OTS.TYPE# = 34 AND OTS.OBJ# = TSP.OBJ# AND TSP.POBJ# = TP.OBJ# AND TP.BO# = I.BO# AND I.OBJ# = PO.OBJ# AND BITAND(PO.FL
AGS, 1) = 1 AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND IP.OBJ# = ISP.POBJ# AND ISP.SUBPART# = TSP.SUBPART# AND ISP.OBJ# = OIS.OBJ# AND OIS.OWNER# = UI.USER# |
9juw6s4yy5pzp | /* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS ) |
9ugwm6xmvw06u | SELECT LAST_LOAD_TIME FROM MGMT_TARGETS WHERE TARGET_GUID=:B1 |
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 |
a5pyncg7v0bw3 | /* OracleOEM */ SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%' |
aq8yqxyyb40nn | update sys.job$ set this_date=:1 where job=:2 |
auqc5yhb7ady2 | SELECT DISTINCT HOST_URL FROM MGMT_OMS_PARAMETERS WHERE NAME='TIMESTAMP' |
aykvshm7zsabd | select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3' |
b2u9kspucpqwy | SELECT COUNT(*) FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL |
b5y9gf2h9c6x0 |
/* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("OBJ#")), to_char(substrb(dump(min("OBJ#"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OBJ#"), 16, 0, 32), 1, 120)), to_char(count("PROGRAM_OID")), to_char(substrb(dump(min("PROGRAM_OID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PROGRAM_OID"), 16, 0, 32), 1, 120)), to_char(count("PROGRAM_ACTION")), to_char(substrb(dump(min("PROGRAM_ACTION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PROGRAM_ACTION"), 16, 0, 32), 1, 120)), to_char(count("SCHEDULE_EXPR")), to_char(substrb(dump(min("SCHEDULE_EXPR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SCHEDULE_EXPR"), 16, 0, 32), 1, 120)), to_char(count("QUEUE_OWNER")), to_char(substrb(dump(min("QUEUE_OW
NER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("QUEUE_OWNER"), 16, 0, 32), 1, 120)), to_char(count("QUEUE_NAME")), to_char(substrb(dump(min("QUEUE_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("QUEUE_NAME"), 16, 0, 32), 1, 120)), to_char(count("QUEUE_AGENT")), to_char(substrb(dump(min("QUEUE_AGENT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("QUEUE_AGENT"), 16, 0, 32), 1, 120)), to_char(count("EVENT_RULE")), to_char(substrb(dump(min("EVENT_RULE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("EVENT_RULE"), 16, 0, 32), 1, 120)), to_char(count("SCHEDULE_LIMIT")), to_char(substrb(dump(min("SCHEDULE_LIMIT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SCHEDULE_LIMIT"), 16, 0, 32), 1, 120)), to_char(count("SCHEDULE_ID")), to_char(substrb(dump(min("SCHEDULE_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max(
"SCHEDULE_ID"), 16, 0, 32), 1, 120)), to_char(count("START_DATE")), to_char(substrb(dump(min("START_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("START_DATE"), 16, 0, 32), 1, 120)), to_char(count("END_DATE")), to_char(substrb(dump(min("END_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("END_DATE"), 16, 0, 32), 1, 120)), to_char(count("LAST_ENABLED_TIME")), to_char(substrb(dump(min("LAST_ENABLED_TIME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LAST_ENABLED_TIME"), 16, 0, 32), 1, 120)), to_char(count("CLASS_OID")), to_char(substrb(dump(min("CLASS_OID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CLASS_OID"), 16, 0, 32), 1, 120)), to_char(count("PRIORITY")), to_char(substrb(dump(min("PRIORITY"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("PRIORITY"), 16, 0, 32), 1, 120)), to_char(count("JOB_WE
IGHT")), to_char(substrb(dump(min("JOB_WEIGHT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("JOB_WEIGHT"), 16, 0, 32), 1, 120)), to_char(count("NUMBER_OF_ARGS")), to_char(substrb(dump(min("NUMBER_OF_ARGS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NUMBER_OF_ARGS"), 16, 0, 32), 1, 120)), to_char(count("MAX_RUNS")), to_char(substrb(dump(min("MAX_RUNS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MAX_RUNS"), 16, 0, 32), 1, 120)), to_char(count("MAX_FAILURES")), to_char(substrb(dump(min("MAX_FAILURES"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MAX_FAILURES"), 16, 0, 32), 1, 120)), to_char(count("MAX_RUN_DURATION")), to_char(substrb(dump(min("MAX_RUN_DURATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MAX_RUN_DURATION"), 16, 0, 32), 1, 120)), to_char(count("MXDUR_MSGID")), to_char(substrb(dump(min("MXDU
R_MSGID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("MXDUR_MSGID"), 16, 0, 32), 1, 120)), to_char(count("FLAGS")), to_char(substrb(dump(min("FLAGS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FLAGS"), 16, 0, 32), 1, 120)), to_char(count("COMMENTS")), to_char(substrb(dump(min("COMMENTS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("COMMENTS"), 16, 0, 32), 1, 120)), to_char(count("USER_CALLBACK")), to_char(substrb(dump(min("USER_CALLBACK"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("USER_CALLBACK"), 16, 0, 32), 1, 120)), to_char(count("USER_CALLBACK_CTX")), to_char(substrb(dump(min("USER_CALLBACK_CTX"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("USER_CALLBACK_CTX"), 16, 0, 32), 1, 120)), to_char(count("CREATOR")), to_char(substrb(dump(min("CREATOR"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CREATOR
"), 16, 0, 32), 1, 120)), to_char(count("CLIENT_ID")), to_char(substrb(dump(min("CLIENT_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CLIENT_ID"), 16, 0, 32), 1, 120)), to_char(count("GUID")), to_char(substrb(dump(min("GUID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("GUID"), 16, 0, 32), 1, 120)), to_char(count("NLS_ENV")), to_char(substrb(dump(min("NLS_ENV"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NLS_ENV"), 16, 0, 32), 1, 120)), to_char(count("ENV")), to_char(substrb(dump(min("ENV"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("ENV"), 16, 0, 32), 1, 120)), to_char(count("CHAR_ENV")), to_char(substrb(dump(min("CHAR_ENV"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CHAR_ENV"), 16, 0, 32), 1, 120)), to_char(count("SOURCE")), to_char(substrb(dump(min("SOURCE"), 16, 0, 32), 1, 120)), to
_char(substrb(dump(max("SOURCE"), 16, 0, 32), 1, 120)), to_char(count("DEST_OID")), to_char(substrb(dump(min("DEST_OID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DEST_OID"), 16, 0, 32), 1, 120)), to_char(count("DESTINATION")), to_char(substrb(dump(min("DESTINATION"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DESTINATION"), 16, 0, 32), 1, 120)), to_char(count("DATABASE_ROLE")), to_char(substrb(dump(min("DATABASE_ROLE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DATABASE_ROLE"), 16, 0, 32), 1, 120)), to_char(count("INSTANCE_ID")), to_char(substrb(dump(min("INSTANCE_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("INSTANCE_ID"), 16, 0, 32), 1, 120)), to_char(count("CREDENTIAL_NAME")), to_char(substrb(dump(min("CREDENTIAL_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CREDENTIAL_NAME"), 16, 0, 32),
1, 120)), to_char(count("CREDENTIAL_OWNER")), to_char(substrb(dump(min("CREDENTIAL_OWNER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CREDENTIAL_OWNER"), 16, 0, 32), 1, 120)), to_char(count("CREDENTIAL_OID")), to_char(substrb(dump(min("CREDENTIAL_OID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("CREDENTIAL_OID"), 16, 0, 32), 1, 120)), to_char(count("OWNER_UDN")), to_char(substrb(dump(min("OWNER_UDN"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("OWNER_UDN"), 16, 0, 32), 1, 120)), to_char(count("FW_NAME")), to_char(substrb(dump(min("FW_NAME"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FW_NAME"), 16, 0, 32), 1, 120)), to_char(count("FW_OID")), to_char(substrb(dump(min("FW_OID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FW_OID"), 16, 0, 32), 1, 120)), to_char(count("JOB_STATUS")), to_char(substrb(dump(min
("JOB_STATUS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("JOB_STATUS"), 16, 0, 32), 1, 120)), to_char(count("NEXT_RUN_DATE")), to_char(substrb(dump(min("NEXT_RUN_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("NEXT_RUN_DATE"), 16, 0, 32), 1, 120)), to_char(count("LAST_START_DATE")), to_char(substrb(dump(min("LAST_START_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LAST_START_DATE"), 16, 0, 32), 1, 120)), to_char(count("LAST_END_DATE")), to_char(substrb(dump(min("LAST_END_DATE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("LAST_END_DATE"), 16, 0, 32), 1, 120)), to_char(count("RETRY_COUNT")), to_char(substrb(dump(min("RETRY_COUNT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RETRY_COUNT"), 16, 0, 32), 1, 120)), to_char(count("RUN_COUNT")), to_char(substrb(dump(min("RUN_COUNT"), 16, 0, 32), 1, 120))
, to_char(substrb(dump(max("RUN_COUNT"), 16, 0, 32), 1, 120)), to_char(count("FAILURE_COUNT")), to_char(substrb(dump(min("FAILURE_COUNT"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("FAILURE_COUNT"), 16, 0, 32), 1, 120)), to_char(count("RUNNING_INSTANCE")), to_char(substrb(dump(min("RUNNING_INSTANCE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RUNNING_INSTANCE"), 16, 0, 32), 1, 120)), to_char(count("RUNNING_SLAVE")), to_char(substrb(dump(min("RUNNING_SLAVE"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RUNNING_SLAVE"), 16, 0, 32), 1, 120)), to_char(count("DIST_FLAGS")), to_char(substrb(dump(min("DIST_FLAGS"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("DIST_FLAGS"), 16, 0, 32), 1, 120)), to_char(count("JOB_DEST_ID")), to_char(substrb(dump(min("JOB_DEST_ID"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("JOB_DEST_I
D"), 16, 0, 32), 1, 120)), to_char(count("RUN_INVOKER")), to_char(substrb(dump(min("RUN_INVOKER"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("RUN_INVOKER"), 16, 0, 32), 1, 120)), to_char(count("SYS_NC00055$")), to_char(substrb(dump(min("SYS_NC00055$"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SYS_NC00055$"), 16, 0, 32), 1, 120)), to_char(count("SYS_NC00056$")), to_char(substrb(dump(min("SYS_NC00056$"), 16, 0, 32), 1, 120)), to_char(substrb(dump(max("SYS_NC00056$"), 16, 0, 32), 1, 120)) from "SYS"."SCHEDULER$_JOB" t /* ACL, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV,
NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL, NDV, NIL, NIL*/ |
b6usrg82hwsa3 | call dbms_stats.gather_database_stats_job_proc ( ) |
bfujkg8dw1aax | SELECT UPPER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 |
bn4b3vjw2mj3u |
SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a
.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0,
NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1 |
btwkwwx56w4z6 | SELECT target_guid FROM mgmt_metric_dependency WHERE can_calculate = 1 AND event_metric = 1 AND disabled = 0 AND rs_metric = 1 ORDER BY eval_order |
bunssq950snhf | insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice |
c8h3jdwaa532q | SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :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 |
cn39cg7kr98v6 | SELECT P.VALCHAR FROM SYS.OPTSTAT_USER_PREFS$ P WHERE P.OBJ#=:B2 AND P.PNAME=:B1 |
cumjq42201t37 | select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date 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 |
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 |
cxjqbfn0d3yqq | SELECT COUNT(*) FROM SYS.DBA_PROPAGATION |
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 |
d27r7zhtnfgp4 | SELECT LAST_DATE, THIS_DATE FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEVERITIES();' |
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 |
dbvkky621gqtr | SELECT /*+ parallel */ 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 |
dkk8923ygggj7 | UPDATE MGMT_EMD_PING SET LAST_HEARTBEAT_TS = :B6 , LAST_HEARTBEAT_UTC = CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE), CLEAN_HEARTBEAT_UTC = :B5 , STATUS_SYNC_UTC = :B4 , EMD_UPTIME_UTC = :B3 , HEARTBEAT_RECORDER_URL = SUBSTR(:B1 , 0, 256), UNRCH_START_TS = NULL WHERE TARGET_GUID = :B2 |
dwssdqx28tzf5 | select sysdate + 1 / (24 * 60) from dual |
dy0yxpyu2wcbv | SELECT /*+ all_rows */ C.NAME ICNAME, IC.POS# ICPOS, IC.SPARE1 ICFLAGS, C.PROPERTY ICPROP, C.DEFAULT$ ICEXPR, C.DEFLENGTH ICELEN FROM ICOL$ IC, COL$ C WHERE (:B2 IS NULL) AND IC.OBJ#=:B1 AND IC.BO#=C.OBJ# AND IC.INTCOL# = C.INTCOL# UNION ALL SELECT '"'||BO.NAME||'"."'||C.NAME||'"' ICNAME, IC.POS# ICPOS, IC.SPARE1 ICFLAGS, C.PROPERTY ICPROP, C.DEFAULT$ ICEXPR, C.DEFLENGTH ICELEN FROM ICOL$ IC, COL$ C, OBJ$ BO WHERE (:B2 IS NOT NULL) AND IC.OBJ#=:B1 AND IC.BO#=C.OBJ# AND IC.BO#=BO.OBJ# AND IC.SPARE2 = C.INTCOL# ORDER BY ICPOS |
f4fcb8ngpf080 | SELECT HOST_URL, MODULE, NVL(SUM(VALUE), 0) HR_THROUGHPUT, NVL(SUM(DURATION/1000.0), 0) RUNTIME, NVL((SUM(VALUE)*1000.0), 0)/ DECODE(NVL(SUM(DURATION), 0), 0, 1, SUM(DURATION)) SEC_THROUGHPUT FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME = :B3 AND MODULE LIKE :B2 ||'%' AND NAME = :B1 AND IS_TOTAL = 'Y' AND DURATION > 0 AND TIME > (SYSDATE - (1/24)) GROUP BY HOST_URL, MODULE |
fjvwzpxbpch0h |
/* OracleOEM */ select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STR
EAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT c.apply_name, state, -- This is the XOUT case c.hwm_time as apply_time, hwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name in (select server_name from dba_xstream_outbound) union SELECT c.apply_name, state, -- This is non-XOUT case c.lwm_time as apply_time, lwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator
c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name not in (select server_name from dba_xstream_outbound) ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name |
fsn35zyxmf1uy | SELECT WHAT, NEXT_DATE NEXT_TIME, DECODE(NVL(BROKEN, 'Y'), 'Y', 'DOWN', 'UP') BROKEN FROM USER_JOBS WHERE WHAT LIKE '%EXECUTE_EM_DBMS_JOB%' |
g1xapjmt4vm5c | SELECT SU.NAME, SO.NAME, A.STATSTYPE#, A.INTCOL# FROM ASSOCIATION$ A, OBJ$ O, USER$ U, COL$ C, OBJ$ SO, USER$ SU WHERE O.OWNER#=U.USER# AND A.OBJ#=O.OBJ# AND O.OBJ#=C.OBJ# AND C.INTCOL#=A.INTCOL# AND A.STATSTYPE#=SO.OBJ# AND SO.OWNER#=SU.USER# AND O.TYPE#=2 AND U.NAME=:B3 AND O.NAME=:B2 AND C.NAME=:B1 |
g5m0bnvyy37b1 |
select sql_id, plan_hash_value, bucket_id, begin_snap, end_snap from (select dbid, sql_id, bucket_id, plan_hash_value, begin_snap, end_snap, cpu_plus_io from (select dbid, sql_id, bucket_id, plan_hash_value, begin_snap, end_snap, cpu_plus_io, row_number() over (partition by bucket_id order by cpu_plus_io desc) as within_bucket_rnk from (select dbid, sql_id, bucket_id, max(plan_hash_value) keep (dense_rank last order by cpu_plus_io) plan_hash_value, max(begin_snap) keep (dense_rank last order by cpu_plus_io) begin_snap, max(end_snap) keep (dense_rank last order by cpu_plus_io) end_snap, max(cpu_plus_io) cpu_plus_io from (select dbid, sql_id, plan_hash_value, begin_snap, end_snap, bucket_id, cpu_time + buffer_gets * 10000 as cpu_plus_io from (select dbid, begin_snap, end_snap, sql_id, plan_hash_value, case when bucket_id = 0 then cpu_time / executions else cpu_time end as cpu_time, case when bucket_id = 0 then buffer_gets / executions else buffer_gets e
nd as buffer_gets, bucket_id from (select dbid, min(snap_id) begin_snap, max(snap_id) end_snap, sql_id, plan_hash_value, sum(cpu_time) cpu_time, sum(buffer_gets) buffer_gets, decode(sum(executions), 0, 1, sum(executions)) executions, decode(grouping_id(snap_id, hour_id, day_id), 3, 0, 5, 1, 6, 2, 3) bucket_id from (select f.dbid, f.snap_id, sql_id, plan_hash_value, to_number(to_char(begin_interval_time + 0, 'DDD')) day_id, (to_number(to_char(begin_interval_time + 0, 'DDD')) - 1)*24 + to_number(to_char(begin_interval_time + 0, 'HH24')) hour_id, cpu_time, buffer_gets, executions from (select v1.* from ( select snap_id, dbid, min_inst_num, sql_id, plan_hash_value, cpu_time, buffer_gets, executions from (select snap_id, dbid, min_inst_num, sql_id, plan_hash_value, cpu_time, buffer_gets, executions, row_number() over(partition by dbid, snap_id order by(cpu_time + buffer_gets * 10000) desc) as within_snap_rnk from (select /*+ cardinality(d 1) *
/ sq.dbid, sq.snap_id, min(sq.instance_number) min_inst_num, sq.sql_id, plan_hash_value, sum(cpu_time_delta) cpu_time, sum(buffer_gets_delta) buffer_gets, sum(executions_delta) executions from dba_hist_sqlstat sq, v$database d, dba_hist_sqltext st where sq.dbid = d.dbid and st.dbid = sq.dbid and st.sql_id = sq.sql_id and sq.snap_id between :bid and :eid and st.command_type in (2, 3, 6, 7, 189) and bitand(nvl(sq.flag, 0), 1) = 0 group by sq.dbid, sq.snap_id, sq.sql_id, plan_hash_value)) where within_snap_rnk <= 150 ) v1, (select sq.sql_id from dba_hist_sqlstat sq, v$database d where sq.dbid = d.dbid and sq.snap_id between :bid and :eid group by sq.dbid, sq.sql_id having sum(nvl(executions_delta, 0)) >= 2) v2 where v1.sql_id = v2.sql_id) f, dba_hist_snapshot s where f.snap_id = s.snap_id and f.dbid = s.dbid and s.instance_number = f.min_inst_num) group by grouping sets ((dbid, sql_id, plan_hash_value, snap_id), (dbid, sql_id, plan_hash_value, day_id), (db
id, sql_id, plan_hash_value, hour_id), (dbid, sql_id, plan_hash_value))))) group by dbid, sql_id, bucket_id) where cpu_plus_io >= decode(bucket_id, 0, (10 * 1000000), 1, (60 * 1000000), 2, (240 * 1000000), (480 * 1000000)))where within_bucket_rnk <= 150) order by bucket_id asc, cpu_plus_io desc |
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) |
gz4vfuvmxa42j | SELECT COUNT(*) FROM SYS.DBA_ADVISOR_TASKS WHERE OWNER = :B1 AND ROWNUM = 1 |