Metrics "Process Limit %" is at 99.667
process parameter is set to 300
AS per ASH stats gathering is being performed at the time of this alert.
0309hs8cqjbkcselect /*+ parallel_index(t, "TDVDIVER_BM12", 320) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad no_expand index_ffs(t, "TDVDIVER_BM12") */ count(distinct sys_op_lbid(66663, 'R', t.rowid)) as nrw, count(distinct sys_op_lbid(66663, 'L', t.rowid)) as nlb, null as ndk, null as clf from "MSL"."TDVDIVER" sample block ( 17.3422403382, 1) t6ukz58jv3hrb6insert /*+ append */ into sys.ora_temp_1_ds_110003 SELECT /*+ parallel(t, 320) parallel_index(t, 320) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"FSC_PERD", "VEND_NBR", "ORD_TY_CD", "PURCH_GRP", "PAYT_DEPT_CD", "PAYT_ORG_CD", rowid SYS_DS_ALIAS_0 from "MSL"."TDVDIVER" sample ( .0178525319) t UNION ALL SELECT "FSC_PERD", "VEND_NBR", "ORD_TY_CD", "PURCH_GRP", "PAYT_DEPT_CD", "PAYT_ORG_CD", SYS_DS_ALIAS_0 FROM sys.ora_temp_1_ds_110003 WHERE 1 = 0