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$PARAMETER

Line 23: l_compat_vers v$parameter.value%TYPE;

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
27: select version into l_db_version from v$instance;

Line 33: select substr(value,1,5) into l_compat_vers from v$parameter where lower(name) = 'compatible';

29: l_db_version := g_db_version;
30: END IF;
31:
32: begin
33: select substr(value,1,5) into l_compat_vers from v$parameter where lower(name) = 'compatible';
34: exception
35: WHEN NO_DATA_FOUND THEN
36: l_compat_vers := SUBSTR(l_db_version,1,5);
37: end;

Line 238: ' isdefault FROM gv$parameter ' ||

234: ' when name=''filesystemio_options'' and value like ''setall%'' then ''setall'''||
235: ' when name=''filesystemio_options'' then '' '''||
236: ' else value '||
237: ' end,'||
238: ' isdefault FROM gv$parameter ' ||
239: ' WHERE name != ''resource_manager_plan'' '||
240: ' AND inst_id = ' || inst_id_row.inst_id,inst_id_row.instance_name);
241: END LOOP;
242: END collect_db_init_params;

Line 521: SELECT value INTO l_reject_thresh FROM v$parameter WHERE name='_external_scn_rejection_threshold_hours';

517: SELECT to_char(created,'YYYY-MM-DD HH24:MI:SS') INTO l_created FROM v$database;
518:
519: -- reject threshold (may not exist, catch that)
520: BEGIN
521: SELECT value INTO l_reject_thresh FROM v$parameter WHERE name='_external_scn_rejection_threshold_hours';
522: EXCEPTION
523: WHEN NO_DATA_FOUND THEN
524: l_reject_thresh := -1;
525: END;

Line 2852: l_dbUniqueName v$parameter.VALUE%TYPE;

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;
2856: l_dbName v$parameter.VALUE%TYPE;

Line 2853: l_dbDomain v$parameter.VALUE%TYPE;

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;
2856: l_dbName v$parameter.VALUE%TYPE;
2857: l_dbInstanceName v$parameter.VALUE%TYPE;

Line 2855: l_diagDest v$parameter.VALUE%TYPE;

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;
2856: l_dbName v$parameter.VALUE%TYPE;
2857: l_dbInstanceName v$parameter.VALUE%TYPE;
2858:
2859: BEGIN

Line 2856: l_dbName v$parameter.VALUE%TYPE;

2852: l_dbUniqueName v$parameter.VALUE%TYPE;
2853: l_dbDomain v$parameter.VALUE%TYPE;
2854:
2855: l_diagDest v$parameter.VALUE%TYPE;
2856: l_dbName v$parameter.VALUE%TYPE;
2857: l_dbInstanceName v$parameter.VALUE%TYPE;
2858:
2859: BEGIN
2860: write_file_header();

Line 2857: l_dbInstanceName v$parameter.VALUE%TYPE;

2853: l_dbDomain v$parameter.VALUE%TYPE;
2854:
2855: l_diagDest v$parameter.VALUE%TYPE;
2856: l_dbName v$parameter.VALUE%TYPE;
2857: l_dbInstanceName v$parameter.VALUE%TYPE;
2858:
2859: BEGIN
2860: write_file_header();
2861:

Line 2863: select value into l_dbUniqueName from v$parameter where name='db_unique_name';

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);
2867: UTL_FILE.PUT_LINE(g_config_handle,'DB_UNIQUE_NAME=' || l_dbUniqueName);

Line 2864: select value into l_dbDomain from v$parameter where name='db_domain';

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);
2867: UTL_FILE.PUT_LINE(g_config_handle,'DB_UNIQUE_NAME=' || l_dbUniqueName);
2868: UTL_FILE.PUT_LINE(g_config_handle,'DB_DOMAIN=' || l_dbDomain);

Line 2873: select value into l_diagDest from v$parameter where lower(name)='diagnostic_dest';

2869:
2870: -- diagnostic_dest is property introduced from 11g
2871: -- So, pre 11g db will not have this so prepare for that
2872: BEGIN
2873: select value into l_diagDest from v$parameter where lower(name)='diagnostic_dest';
2874: UTL_FILE.PUT_LINE(g_config_handle,'DIAG_DEST=' || l_diagDest);
2875: EXCEPTION
2876: WHEN NO_DATA_FOUND THEN
2877: null;

Line 2880: select value into l_dbName from v$parameter where name='db_name';

2876: WHEN NO_DATA_FOUND THEN
2877: null;
2878: END;
2879:
2880: select value into l_dbName from v$parameter where name='db_name';
2881: select value into l_dbInstanceName from v$parameter where name='instance_name';
2882:
2883: UTL_FILE.PUT_LINE(g_config_handle,'DB_NAME=' || l_dbName);
2884: UTL_FILE.PUT_LINE(g_config_handle,'INSTANCE_NAME=' || l_dbInstanceName);

Line 2881: select value into l_dbInstanceName from v$parameter where name='instance_name';

2877: null;
2878: END;
2879:
2880: select value into l_dbName from v$parameter where name='db_name';
2881: select value into l_dbInstanceName from v$parameter where name='instance_name';
2882:
2883: UTL_FILE.PUT_LINE(g_config_handle,'DB_NAME=' || l_dbName);
2884: UTL_FILE.PUT_LINE(g_config_handle,'INSTANCE_NAME=' || l_dbInstanceName);
2885: