| General Information |
| Note: OCM = Oracle Configuration Manager |
| Source |
The source code is unwrapped
header
{ORACLE_HOME}/rdbms/admin/ocmdbd.sql
body
{ORACLE_HOME}/rdbms/admin/ocmdbb.sql |
| First Available |
11.2.0.1 |
Constants
|
| Name |
Data Type |
Value |
| ORACLE_DATABASE_META_VER |
VARCHAR(17) |
'10.3.5.0.0' |
| VERSION_817 |
VARCHAR(3) |
'817' |
| VERSION_9i |
VARCHAR(3) |
'9i' |
| VERSION_9iR2 |
VARCHAR(4) |
'9iR2' |
| VERSION_10gR1 |
VARCHAR(5) |
'10gR1' |
| VERSION_10gR2 |
VARCHAR(5) |
'10gR2' |
| VERSION_11gR1 |
VARCHAR(5) |
'11gR1' |
| VERSION_11gR2 |
VARCHAR(5) |
'11gR2' |
| MIN_SUPPORTED_VERSION |
VARCHAR(10) |
'08.1.7.0.0' |
| NOT_SUPPORTED_VERSION |
VARCHAR(3) |
'NSV' |
| HIGHER_SUPPORTED_VERSION |
VARCHAR(3) |
'HSV' |
|
| Data Types |
TYPE GenericCurType IS REF CURSOR; |
| Dependencies |
| DBA_TABLES |
NLS_DATABASE_PARAMETERS |
V$DATABASE |
V$PROCESS |
| DBMS_SQL |
UTL_FILE |
V$INSTANCE |
V$SESSION |
| GV$INSTANCE |
UTL_INADDR |
V$PARAMETER |
|
|
| Security Model |
Owned by ORACLE_OCM with no privileges granted |
| Subprograms |
|
| |
| COLLECT_CONFIG_METRICS |
Puts the configuration data into the file
By default, this procedure does not raise an exception. |
mgmt_db_ll_metrics.collect_config_metrics(directory_location IN VARCHAR2, raise_exp BOOLEAN DEFAULT FALSE); |
| exec oracle_ocm.mgmt_db_ll_metrics.collect_config_metrics('CTEMP'); |
| |
| COLLECT_STATS_METRICS |
Puts the statistics config data into the file
By default, this procedure does not raise an exception. |
mgmt_db_ll_metrics.collect_stats_metrics(directory_location IN VARCHAR2, raise_exp BOOLEAN DEFAULT FALSE); |
conn / as sysdba
CREATE OR REPLACE DIRECTORY ctemp AS 'c:\temp';
exec oracle_ocm.mgmt_db_ll_metrics.collect_stats_metrics('CTEMP'); |
| |
| GET_VERSION_CATEGORY |
| Compute the version category |
mgmt_db_ll_metrics.get_version_category RETURN VARCHAR2; |
SELECT oracle_ocm.mgmt_db_ll_metrics.get_version_category
FROM dual; |
| |
| WRITE_DB_CCR_FILE |
| Write DB info to a file (for RAC discovery/ADR info collection) using UTL_FILE |
mgmt_db_ll_metrics.write_db_ccr_file(directory_location IN VARCHAR2, raise_exp BOOLEAN DEFAULT FALSE); |
-- this code from {ORACLE_HOME}/rdbms/admin/ocmjb10.sql: formatted here for clarity
PROCEDURE collect_config IS
CURSOR l_res_cur IS
SELECT inst_id, instance_number
FROM gv$instance;
BEGIN
FOR inst_id_row IN l_res_cur LOOP
submit_job_for_inst(inst_id_row.inst_id, inst_id_row.instance_number, JOB_NAME,
'BEGIN
ORACLE_OCM.MGMT_DB_LL_METRICS.COLLECT_CONFIG_METRICS(''ORACLE_OCM_CONFIG_DIR'');
END;',
'BEGIN
ORACLE_OCM.MGMT_DB_LL_METRICS.WRITE_DB_CCR_FILE(''ORACLE_OCM_CONFIG_DIR2'', TRUE);
END;');
END LOOP;
END collect_config; |
