DBA Data[Home] [Help]

ORACLE_OCM.MGMT_CONFIG dependencies on GV$INSTANCE

Line 207: CURSOR l_res_cur IS select inst_id,instance_number from gv$instance;

203: /*
204: Config collection job
205: */
206: procedure collect_config IS
207: CURSOR l_res_cur IS select inst_id,instance_number from gv$instance;
208: BEGIN
209: FOR inst_id_row in l_res_cur LOOP
210: submit_job_for_inst(inst_id_row.inst_id, inst_id_row.instance_number, JOB_NAME,
211: 'BEGIN ORACLE_OCM.MGMT_DB_LL_METRICS.COLLECT_CONFIG_METRICS(''ORACLE_OCM_CONFIG_DIR''); END;',

Line 220: CURSOR l_res_cur IS select inst_id, instance_number from gv$instance;

216: /*
217: Statistics collection job
218: */
219: procedure collect_stats IS
220: CURSOR l_res_cur IS select inst_id, instance_number from gv$instance;
221: BEGIN
222: FOR inst_id_row in l_res_cur LOOP
223: submit_job_for_inst(inst_id_row.inst_id, inst_id_row.instance_number, STATS_JOB_NAME,
224: 'BEGIN ORACLE_OCM.MGMT_DB_LL_METRICS.collect_stats_metrics(''ORACLE_OCM_CONFIG_DIR''); END;',