ORACLE_OCM.MGMT_DB_LL_METRICS dependencies on GV$INSTANCE

Line 225: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;

221: Private procedure
222: Collect metric=db_init_params
223: */
224: procedure collect_db_init_params IS
225: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;
226: BEGIN
227: FOR inst_id_row in l_res_cur LOOP
228: write_metric('db_init_params',
229: 'SELECT name, '||

Line 250: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;

246: Private procedure
247: Collect metric=cdb_init_params
248: */
249: procedure collect_cdb_init_params IS
250: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;
251: BEGIN
252: FOR inst_id_row in l_res_cur LOOP
253: write_metric('cdb_init_params',
254: 'SELECT pdb, '||

Line 292: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;

288: Private procedure
289: collect metric=cdb_pdb_over_params
290: */
291: procedure collect_cdb_pdb_over_params IS
292: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;
293: BEGIN
294: FOR inst_id_row in l_res_cur LOOP
295: write_metric('cdb_pdb_over_params',
296: 'SELECT distinct pdb.pdb,' ||

Line 908: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;

904: Private procedure
905: Collect metric=db_sga
906: */
907: procedure collect_db_sga IS
908: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;
909: BEGIN
910: FOR inst_id_row in l_res_cur LOOP
911: write_metric('db_sga',
912: ' select sganame,sgasize ' ||

Line 1163: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;

1159: Collect metric=db_dbNInstanceInfo
1160: */
1161: procedure collect_db_dbNInstanceInfo IS
1162:
1163: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;
1164:
1165: l_word_length NUMBER;
1166: l_is_64bit VARCHAR2(1);
1167: l_banner_bitrelstr VARCHAR2(4000);

Line 1280: ' gv$instance c, ' ||

1276: l_supplemental_log ||
1277: l_dv_status ||
1278: ' FROM gv$database a, ' ||
1279: ' gv$version b, ' ||
1280: ' gv$instance c, ' ||
1281: ' global_name e,' ||
1282: ' gv$nls_parameters nlsp1 , ' ||
1283: ' gv$nls_parameters nlsp2 ' ||
1284: l_dbproperties_from ||

Line 1304: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;

1300: Private procedure
1301: Collect metric=cdb_dbNInstanceInfo
1302: */
1303: procedure collect_cdb_dbNInstanceInfo IS
1304: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;
1305: BEGIN
1306: FOR inst_id_row in l_res_cur LOOP
1307: write_metric('cdb_dbNInstanceInfo',
1308: 'with pdbview AS (SELECT DISTINCT con_id, name pdb FROM gv$containers where con_id != 2) ' ||

Line 1346: 'gv$instance c, ' ||

1342: 'end ' ||
1343: 'end ' ||
1344: 'FROM gv$database a, ' ||
1345: 'gv$version b, ' ||
1346: 'gv$instance c, ' ||
1347: 'CDB_PROPERTIES e, ' ||
1348: 'gv$nls_parameters nlsp1, ' ||
1349: 'gv$nls_parameters nlsp2, ' ||
1350: 'CDB_PROPERTIES p, ' ||

Line 1585: 'select 1 from (select count(*) CNT from gv$instance where rownum <=2) where CNT >= 2';

1581: IS
1582: l_isInstalledSQL VARCHAR2(500) :=
1583: 'SELECT 1 from v$option where parameter=''Real Application Clusters'' and value =''TRUE'' and rownum = 1';
1584: l_isUsedSQL VARCHAR2(500) :=
1585: 'select 1 from (select count(*) CNT from gv$instance where rownum <=2) where CNT >= 2';
1586: l_infoSQL VARCHAR2(500) := NULL;
1587: BEGIN
1588: write_option_record('RAC',l_isInstalledSQL,l_isUsedSQL,l_infoSQL);
1589: end write_rac;

Line 2221: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;

2217: Private procedure
2218: Collect metric=oracle_cdb_services
2219: */
2220: procedure collect_cdb_services IS
2221: CURSOR l_res_cur IS select inst_id,instance_name from gv$instance;
2222: BEGIN
2223: FOR inst_id_row in l_res_cur LOOP
2224: write_metric('cdb_services',
2225: 'WITH pdbs AS (SELECT DISTINCT con_id, name pdb, inst_id FROM gv$containers where con_id != 2) ' ||