ORACLE_OCM.MGMT_CONFIG dependencies on V$INSTANCE

Line 70: l_par v$instance.PARALLEL%TYPE;

66: procedure submit_job_for_inst(inst_id IN BINARY_INTEGER, p_inst_num IN BINARY_INTEGER,
67: p_job_name IN VARCHAR2,
68: p_job_action IN VARCHAR2, p_job_action2 in VARCHAR2) IS
69: l_job NUMBER;
70: l_par v$instance.PARALLEL%TYPE;
71: l_instNum v$instance.INSTANCE_NUMBER%TYPE;
72: BEGIN
73: BEGIN
74: IF not job_exists(p_job_name || '_' || inst_id) THEN

Line 71: l_instNum v$instance.INSTANCE_NUMBER%TYPE;

67: p_job_name IN VARCHAR2,
68: p_job_action IN VARCHAR2, p_job_action2 in VARCHAR2) IS
69: l_job NUMBER;
70: l_par v$instance.PARALLEL%TYPE;
71: l_instNum v$instance.INSTANCE_NUMBER%TYPE;
72: BEGIN
73: BEGIN
74: IF not job_exists(p_job_name || '_' || inst_id) THEN
75: sys.dbms_scheduler.create_job(

Line 106: select PARALLEL into l_par from v$instance;

102: END;
103:
104: -- create 2nd job if specified
105: IF p_job_action2 is NOT NULL THEN
106: select PARALLEL into l_par from v$instance;
107: IF l_par = 'YES' THEN
108: select instance_number into l_instNum from v$instance;
109: IF l_instNum <> p_inst_num THEN
110: BEGIN

Line 108: select instance_number into l_instNum from v$instance;

104: -- create 2nd job if specified
105: IF p_job_action2 is NOT NULL THEN
106: select PARALLEL into l_par from v$instance;
107: IF l_par = 'YES' THEN
108: select instance_number into l_instNum from v$instance;
109: IF l_instNum <> p_inst_num THEN
110: BEGIN
111: IF not job_exists(p_job_name || '_2_' || inst_id) THEN
112: sys.dbms_scheduler.create_job(

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;',