eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

ORACLE_OCM.MGMT_DB_LL_METRICS dependencies on V$INSTANCE

Line 7: g_db_version v$instance.version%TYPE := NULL;

3: g_config_handle UTL_FILE.FILE_TYPE := NULL;
4: g_version_category VARCHAR2(10) := NULL;
5:
6: g_dbID v$database.DBID%TYPE := NULL;
7: g_db_version v$instance.version%TYPE := NULL;
8:
9: g_is_cdb VARCHAR2(4) := 'NO';
10:
11: METRIC_END_MARKER constant VARCHAR2(4) := ':End';

Line 21: l_db_version v$instance.version%TYPE;

17: /*
18: Compute the version category
19: */
20: FUNCTION get_version_category RETURN VARCHAR2 IS
21: l_db_version v$instance.version%TYPE;
22: l_temp_version v$instance.version%TYPE;
23: l_compat_vers v$parameter.value%TYPE;
24: l_major_version_ndx NUMBER;
25: BEGIN

Line 22: l_temp_version v$instance.version%TYPE;

18: Compute the version category
19: */
20: FUNCTION get_version_category RETURN VARCHAR2 IS
21: l_db_version v$instance.version%TYPE;
22: l_temp_version v$instance.version%TYPE;
23: l_compat_vers v$parameter.value%TYPE;
24: l_major_version_ndx NUMBER;
25: BEGIN
26: IF g_db_version IS NULL THEN

Line 27: select version into l_db_version from v$instance;

23: l_compat_vers v$parameter.value%TYPE;
24: l_major_version_ndx NUMBER;
25: BEGIN
26: IF g_db_version IS NULL THEN
27: select version into l_db_version from v$instance;
28: ELSE
29: l_db_version := g_db_version;
30: END IF;
31:

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 423: SELECT LPAD(version, 10, '0') into l_db_version from v$instance;

419:
420: BEGIN
421: select 16*1024*24*60*60, 32*1024*24*60*60 into c_time_16, c_time_32 from dual;
422:
423: SELECT LPAD(version, 10, '0') into l_db_version from v$instance;
424: IF (l_db_version = '11.2.0.2.0' OR l_db_version = '11.2.0.3.0') THEN
425: l_sql_text :=
426: 'SELECT count(*) from dba_registry_history ' ||
427: 'where comments=''CPUJan2012'' OR comments=''CPUApr2012''';

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 1394: l_option_version v$instance.version%TYPE := NULL;

1390: l_feature_row VARCHAR2(4000) := NULL;
1391: l_feature_info VARCHAR2(4000) := NULL;
1392: l_size INTEGER := 4000;
1393: l_row_separator VARCHAR2(1) := ';';
1394: l_option_version v$instance.version%TYPE := NULL;
1395: BEGIN
1396: --check if installed
1397: IF p_install_sql is NOT NULL THEN
1398: BEGIN

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) ' ||

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

2604: get the destination file name
2605: */
2606: FUNCTION get_dest_file_name(p_ext IN VARCHAR2 DEFAULT '.ll') RETURN VARCHAR2 IS
2607: l_db_name v$database.name%TYPE;
2608: l_par v$instance.PARALLEL%TYPE;
2609: BEGIN
2610: SELECT name into l_db_name FROM v$database ;
2611: /*
2612: Check if the database is running in RAC mode.

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

2611: /*
2612: Check if the database is running in RAC mode.
2613: If so, name the file as -RAC.ll
2614: */
2615: select PARALLEL into l_par from v$instance;
2616: IF l_par = 'YES' THEN
2617: RETURN l_db_name || '-RAC'||p_ext;
2618: END IF;
2619:

Line 2629: l_vers v$instance.version%TYPE;

2625: */
2626: PROCEDURE write_file_header
2627: IS
2628: l_db_characterset VARCHAR2(20);
2629: l_vers v$instance.version%TYPE;
2630: l_comp_cnt NUMBER;
2631: l_checkXMLdb VARCHAR2(500);
2632: BEGIN
2633: select value into l_db_characterset from NLS_DATABASE_PARAMETERS where parameter = 'NLS_CHARACTERSET';

Line 2638: select LPAD(version,10,'0') into l_vers from v$instance;

2634: UTL_FILE.PUT_LINE(g_config_handle,'META_VER=' || ORACLE_DATABASE_META_VER);
2635: UTL_FILE.PUT_LINE(g_config_handle,'TIMESTAMP=' || TO_CHAR(sysdate,'yyyy-mm-dd hh24:mi:ss'));
2636: UTL_FILE.PUT_LINE(g_config_handle,'NLS_CHARACTERSET=' || l_db_characterset);
2637: -- If 11+, check for XML DB before calling UTL_INADDR package, otherwise go ahead
2638: select LPAD(version,10,'0') into l_vers from v$instance;
2639: IF l_vers >= '11.0.0.0.0' THEN
2640: l_checkXMLdb :=
2641: 'select count(*) from dba_registry where COMP_NAME = ''Oracle XML Database'' ' ||
2642: 'and STATUS = ''VALID''' ;

Line 2751: select version into g_db_version from v$instance;

2747: raise_exp BOOLEAN DEFAULT FALSE) IS
2748: BEGIN
2749: BEGIN
2750: select dbid into g_dbID from v$database;
2751: select version into g_db_version from v$instance;
2752:
2753: g_version_category := get_version_category();
2754: IF g_version_category != NOT_SUPPORTED_VERSION THEN
2755: BEGIN

Line 2799: select version into g_db_version from v$instance;

2795: raise_exp BOOLEAN DEFAULT FALSE) IS
2796: BEGIN
2797: BEGIN
2798: select dbid into g_dbID from v$database;
2799: select version into g_db_version from v$instance;
2800:
2801: g_version_category := get_version_category();
2802: IF g_version_category != NOT_SUPPORTED_VERSION THEN
2803: BEGIN

Line 2851: l_hostName v$instance.HOST_NAME%TYPE;

2847: END;
2848: END collect_stats_metrics;
2849:
2850: procedure write_db_ccr_file_impl IS
2851: l_hostName v$instance.HOST_NAME%TYPE;
2852: l_dbUniqueName v$parameter.VALUE%TYPE;
2853: l_dbDomain v$parameter.VALUE%TYPE;
2854:
2855: l_diagDest v$parameter.VALUE%TYPE;

Line 2862: select host_name into l_hostName from v$instance;

2858:
2859: BEGIN
2860: write_file_header();
2861:
2862: select host_name into l_hostName from v$instance;
2863: select value into l_dbUniqueName from v$parameter where name='db_unique_name';
2864: select value into l_dbDomain from v$parameter where name='db_domain';
2865:
2866: UTL_FILE.PUT_LINE(g_config_handle,'HOST_NAME=' || l_hostName);

Line 2906: select version into g_db_version from v$instance;

2902: raise_exp BOOLEAN DEFAULT FALSE) IS
2903: BEGIN
2904: BEGIN
2905: select dbid into g_dbID from v$database;
2906: select version into g_db_version from v$instance;
2907:
2908: g_version_category := get_version_category();
2909: IF g_version_category != NOT_SUPPORTED_VERSION THEN
2910: BEGIN