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 DUAL

Line 421: select 161024246060, 321024246060 into c_time_16, c_time_32 from dual;

417: l_sql_piece VARCHAR2(200);
418: l_is_gmt VARCHAR2(10);
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 :=

Line 434: select 41024102410242575 into l_seconds_1988 from dual;

430: -- if no rows, then patch is not installed on 11.2.0.2 and 11.2.0.3
431: IF (l_patch = 0) THEN
432: l_max_rate := 32*1024;
433: l_base_year := 2009;
434: select 4*1024*1024*1024*2575 into l_seconds_1988 from dual;
435: END IF;
436: END IF;
437: -- current_scn, intrinsic change (not rate!)
438: IF (l_db_version > '10.0.0.0.0') THEN

Line 446: 'select dbms_flashback.get_system_change_number from dual';

442: '(SELECT sum(s.value) svalue from v$sysstat s WHERE s.name in (''calls to kcmgas'', ''redo writes''))';
443: EXECUTE IMMEDIATE l_sql_text INTO l_current_scn, l_scn_calls;
444: ELSE
445: l_sql_text :=
446: 'select dbms_flashback.get_system_change_number from dual';
447: EXECUTE IMMEDIATE l_sql_text INTO l_current_scn;
448: l_sql_text :=
449: 'SELECT sum(s.value) svalue from v$sysstat s WHERE s.name in (''calls to kcmgas'', ''redo writes'')';
450: EXECUTE IMMEDIATE l_sql_text INTO l_scn_calls;

Line 462: INTO l_maximum_scn FROM dual;

458: + (to_number(to_char(sysdate,'HH24')))) * 60
459: + (to_number(to_char(sysdate,'MI' )))) * 60
460: + (to_number(to_char(sysdate,'SS' ))))
461: * l_max_rate) + l_seconds_1988
462: INTO l_maximum_scn FROM dual;
463:
464: -- scn_headroom
465: IF (l_max_rate = 32768) THEN
466: IF (l_current_scn > l_seconds_1988) THEN

Line 468: INTO l_headroom FROM dual;

464: -- scn_headroom
465: IF (l_max_rate = 32768) THEN
466: IF (l_current_scn > l_seconds_1988) THEN
467: SELECT to_char(((l_maximum_scn - l_current_scn) / c_time_32),'99999D99')
468: INTO l_headroom FROM dual;
469: ELSE
470: SELECT to_char((((l_maximum_scn - l_seconds_1988) / c_time_32) +
471: ((l_seconds_1988 - l_current_scn) / c_time_16)),'99999D99')
472: INTO l_headroom FROM dual;

Line 472: INTO l_headroom FROM dual;

468: INTO l_headroom FROM dual;
469: ELSE
470: SELECT to_char((((l_maximum_scn - l_seconds_1988) / c_time_32) +
471: ((l_seconds_1988 - l_current_scn) / c_time_16)),'99999D99')
472: INTO l_headroom FROM dual;
473: END IF;
474: ELSE
475: SELECT to_char(((l_maximum_scn - l_current_scn) / c_time_16),'99999D99')
476: INTO l_headroom FROM dual;

Line 476: INTO l_headroom FROM dual;

472: INTO l_headroom FROM dual;
473: END IF;
474: ELSE
475: SELECT to_char(((l_maximum_scn - l_current_scn) / c_time_16),'99999D99')
476: INTO l_headroom FROM dual;
477: END IF;
478:
479: -- outgoing DB links
480: SELECT count(*) INTO l_dblink_out FROM DBA_DB_LINKS;

Line 1007: ' from dual ' ||

1003: END IF;
1004:
1005: write_metric('db_options',
1006: ' select ''INTER_MEDIA'' as name, decode((select username from dba_users where username=''ORDSYS''), ''ORDSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1007: ' from dual ' ||
1008: ' union ' ||
1009: ' select ''SPATIAL'' as name, decode((select username from dba_users where username=''MDSYS''), ''MDSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1010: ' from dual ' ||
1011: ' union ' ||

Line 1010: ' from dual ' ||

1006: ' select ''INTER_MEDIA'' as name, decode((select username from dba_users where username=''ORDSYS''), ''ORDSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1007: ' from dual ' ||
1008: ' union ' ||
1009: ' select ''SPATIAL'' as name, decode((select username from dba_users where username=''MDSYS''), ''MDSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1010: ' from dual ' ||
1011: ' union ' ||
1012: ' select ''OLAP'' as name, decode((select username from dba_users where username=''OLAPSYS''), ''OLAPSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1013: ' from dual ' ||
1014: ' union ' ||

Line 1013: ' from dual ' ||

1009: ' select ''SPATIAL'' as name, decode((select username from dba_users where username=''MDSYS''), ''MDSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1010: ' from dual ' ||
1011: ' union ' ||
1012: ' select ''OLAP'' as name, decode((select username from dba_users where username=''OLAPSYS''), ''OLAPSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1013: ' from dual ' ||
1014: ' union ' ||
1015: ' select ''ORACLE_TEXT'' as name, decode((select username from dba_users where username=''CTXSYS''), ''CTXSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1016: ' from dual ' ||
1017: ' union ' ||

Line 1016: ' from dual ' ||

1012: ' select ''OLAP'' as name, decode((select username from dba_users where username=''OLAPSYS''), ''OLAPSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1013: ' from dual ' ||
1014: ' union ' ||
1015: ' select ''ORACLE_TEXT'' as name, decode((select username from dba_users where username=''CTXSYS''), ''CTXSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1016: ' from dual ' ||
1017: ' union ' ||
1018: ' select ''ULTRA_SEARCH'' as name, decode((select username from dba_users where username=''WKSYS''), ''WKSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1019: ' from dual ' ||
1020: ' union ' ||

Line 1019: ' from dual ' ||

1015: ' select ''ORACLE_TEXT'' as name, decode((select username from dba_users where username=''CTXSYS''), ''CTXSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1016: ' from dual ' ||
1017: ' union ' ||
1018: ' select ''ULTRA_SEARCH'' as name, decode((select username from dba_users where username=''WKSYS''), ''WKSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1019: ' from dual ' ||
1020: ' union ' ||
1021: ' select ''LABEL_SECURITY'' as name, decode((select username from dba_users where username=''LBACSYS''), ''LBACSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1022: ' from dual ' ||
1023: ' union ' ||

Line 1022: ' from dual ' ||

1018: ' select ''ULTRA_SEARCH'' as name, decode((select username from dba_users where username=''WKSYS''), ''WKSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1019: ' from dual ' ||
1020: ' union ' ||
1021: ' select ''LABEL_SECURITY'' as name, decode((select username from dba_users where username=''LBACSYS''), ''LBACSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1022: ' from dual ' ||
1023: ' union ' ||
1024: ' select ''SAMPLE_SCHEMA'' as name, decode((select count(*) from dba_users where username IN(''HR'',''PM'',''QS'',''SH'',''OE'')), 0, ''FALSE'', ''TRUE'') as selected ' ||
1025: ' from dual ' ||
1026: ' union ' ||

Line 1025: ' from dual ' ||

1021: ' select ''LABEL_SECURITY'' as name, decode((select username from dba_users where username=''LBACSYS''), ''LBACSYS'', ''TRUE'', ''FALSE'') as selected ' ||
1022: ' from dual ' ||
1023: ' union ' ||
1024: ' select ''SAMPLE_SCHEMA'' as name, decode((select count(*) from dba_users where username IN(''HR'',''PM'',''QS'',''SH'',''OE'')), 0, ''FALSE'', ''TRUE'') as selected ' ||
1025: ' from dual ' ||
1026: ' union ' ||
1027: ' select ''JSERVER'' as name, decode((select count(*) from sys.obj$ where type#=29), 0, ''FALSE'', ''TRUE'') as selected ' ||
1028: ' from dual ' ||
1029: ' union ' ||

Line 1028: ' from dual ' ||

1024: ' select ''SAMPLE_SCHEMA'' as name, decode((select count(*) from dba_users where username IN(''HR'',''PM'',''QS'',''SH'',''OE'')), 0, ''FALSE'', ''TRUE'') as selected ' ||
1025: ' from dual ' ||
1026: ' union ' ||
1027: ' select ''JSERVER'' as name, decode((select count(*) from sys.obj$ where type#=29), 0, ''FALSE'', ''TRUE'') as selected ' ||
1028: ' from dual ' ||
1029: ' union ' ||
1030: l_data_mining ||
1031: ' from dual ' ||
1032: ' union ' ||

Line 1031: ' from dual ' ||

1027: ' select ''JSERVER'' as name, decode((select count(*) from sys.obj$ where type#=29), 0, ''FALSE'', ''TRUE'') as selected ' ||
1028: ' from dual ' ||
1029: ' union ' ||
1030: l_data_mining ||
1031: ' from dual ' ||
1032: ' union ' ||
1033: ' select ''XDB'' as name, decode((select username from dba_users where username=''XDB''), ''XDB'', ''TRUE'', ''FALSE'') as selected ' ||
1034: ' from dual ' ||
1035: ' union ' ||

Line 1034: ' from dual ' ||

1030: l_data_mining ||
1031: ' from dual ' ||
1032: ' union ' ||
1033: ' select ''XDB'' as name, decode((select username from dba_users where username=''XDB''), ''XDB'', ''TRUE'', ''FALSE'') as selected ' ||
1034: ' from dual ' ||
1035: ' union ' ||
1036: ' select ''EM_REPOSITORY'' as name, decode((select username from dba_users where username=''SYSMAN''), ''SYSMAN'', ''TRUE'', ''FALSE'') as selected ' ||
1037: ' from dual ');
1038:

Line 1037: ' from dual ');

1033: ' select ''XDB'' as name, decode((select username from dba_users where username=''XDB''), ''XDB'', ''TRUE'', ''FALSE'') as selected ' ||
1034: ' from dual ' ||
1035: ' union ' ||
1036: ' select ''EM_REPOSITORY'' as name, decode((select username from dba_users where username=''SYSMAN''), ''SYSMAN'', ''TRUE'', ''FALSE'') as selected ' ||
1037: ' from dual ');
1038:
1039: END collect_db_options;
1040:
1041:

Line 1054: ' where what like ''statspack.snap%'' and SCHEMA_USER=''PERFSTAT'' and rownum = 1) freq from dual');

1050: ' (select decode(count(*),1,''YES'',''NO'') FROM sys.obj$ o, sys.user$ u '||
1051: ' WHERE u.name = ''PERFSTAT'' AND o.owner# = u.user# AND o.name = ''STATSPACK'' '||
1052: ' AND o.type# = 11 AND o.status = 1) is_installed, '||
1053: ' (select nvl(INTERVAL,'''') from dba_jobs '||
1054: ' where what like ''statspack.snap%'' and SCHEMA_USER=''PERFSTAT'' and rownum = 1) freq from dual');
1055: END collect_statspack_config;
1056:
1057:
1058: /*

Line 1151: 'select ''CONTROLFILE AUTOBACKUP'',nvl((select value from v$rman_configuration where name=''CONTROLFILE AUTOBACKUP''),'''') from dual ' ||

1147: OR g_version_category = VERSION_11gR2
1148: OR g_version_category = VERSION_12gR1
1149: OR g_version_category = HIGHER_SUPPORTED_VERSION THEN
1150: write_metric('ha_rman_config',
1151: 'select ''CONTROLFILE AUTOBACKUP'',nvl((select value from v$rman_configuration where name=''CONTROLFILE AUTOBACKUP''),'''') from dual ' ||
1152: 'union ' ||
1153: 'select name, value from v$rman_configuration where name=''CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE'' and value like ''DISK%'' ' );
1154: END IF;
1155: END collect_ha_rman_config;

Line 1399: execute immediate 'select 1 from dual where exists (' || p_install_sql || ')' into l_isInstalled;

1395: BEGIN
1396: --check if installed
1397: IF p_install_sql is NOT NULL THEN
1398: BEGIN
1399: execute immediate 'select 1 from dual where exists (' || p_install_sql || ')' into l_isInstalled;
1400: EXCEPTION
1401: WHEN NO_DATA_FOUND THEN
1402: null;
1403: WHEN OTHERS THEN

Line 1426: execute immediate 'select ''TRUE'' from dual where exists (' || p_usage_sql || ')' into l_isUsed;

1422: END IF;
1423:
1424: --check if used
1425: BEGIN
1426: execute immediate 'select ''TRUE'' from dual where exists (' || p_usage_sql || ')' into l_isUsed;
1427: EXCEPTION
1428: WHEN NO_DATA_FOUND THEN
1429: null;
1430: WHEN OTHERS THEN

Line 1534: ' from dual');

1530: ''''',' || -- Aux Count
1531: ''''',' || -- Last Sample Date
1532: ''''',' || -- Last Sample Period
1533: '''' || replace(l_feature_info,'|','#') || '''' || -- Feature Info
1534: ' from dual');
1535: END IF;
1536:
1537: EXCEPTION
1538: WHEN OTHERS THEN

Line 1796: write_option_record('OEM 9i',NULL,'select 1 from dual');

1792: END;
1793: END IF;
1794:
1795: IF v_count > 0 THEN
1796: write_option_record('OEM 9i',NULL,'select 1 from dual');
1797: END IF;
1798: end write_oem;
1799:
1800:

Line 1810: 'select 1 from dual where sdo_version IS NOT NULL';

1806: */
1807: PROCEDURE write_spatial
1808: IS
1809: l_isInstalledSQL VARCHAR2(500) :=
1810: 'select 1 from dual where sdo_version IS NOT NULL';
1811: l_isUsedSQL VARCHAR2(500) :=
1812: 'select 1 from (select count(*) CNT from ALL_SDO_GEOM_METADATA where owner <> ''MDSYS'' and rownum =1) where CNT >0';
1813: l_infoSQL VARCHAR2(500) :=
1814: 'select count(*) from ALL_SDO_GEOM_METADATA where owner <> ''MDSYS''';

Line 1815: l_versionSQL VARCHAR2(50) := 'select sdo_version from dual';

1811: l_isUsedSQL VARCHAR2(500) :=
1812: 'select 1 from (select count(*) CNT from ALL_SDO_GEOM_METADATA where owner <> ''MDSYS'' and rownum =1) where CNT >0';
1813: l_infoSQL VARCHAR2(500) :=
1814: 'select count(*) from ALL_SDO_GEOM_METADATA where owner <> ''MDSYS''';
1815: l_versionSQL VARCHAR2(50) := 'select sdo_version from dual';
1816: BEGIN
1817: write_option_record('Spatial',l_isInstalledSQL,l_isUsedSQL,l_infoSQL,l_versionSQL);
1818: end write_spatial;
1819:

Line 2680: ' from (select '' '' instance_name from dual ' ||

2676:
2677: IF g_version_category = VERSION_10gR1 OR
2678: g_version_category = VERSION_10gR2 THEN
2679: execute immediate 'select * from (select instance_name ' ||
2680: ' from (select '' '' instance_name from dual ' ||
2681: ' union all ' ||
2682: ' select instance_name from v$asm_client) ' ||
2683: ' order by instance_name desc) ' ||
2684: ' where rownum = 1 ' into l_asm_instance_name;