Oracle | MGMT

Oracle MGMT_CONFIG Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose This package is executed with invoker's rights. It is needed so that the ORACLE_OCM user does not need to be granted EXECUTE on DBMS_SYSTEM.

AUTHID DEFINER

Dependencies

DBA_SCHEDULER_JOBS	DBMS_SCHEDULER	GV$INSTANCE
DBMS_OUTPUT	DBMS_STANDARD	V$INSTANCE

Documented No

First Available Not Known

Security Model Owned by ORACLE_OCM with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/ocmjd10.sql

Subprograms

COLLECT_CONFIG	PRINT_JOB_DETAILS	STOP_JOB
COLLECT_STATS	RUN_NOW	SUBMIT_JOB

COLLECT_CONFIG

Run the configuration collection job mgmt_config.collect_config;

exec oracle_ocm.mgmt_config.collect_config;

      

      PL/SQL procedure successfully completed.

COLLECT_STATS

Run the statistics collection job mgmt_config.collect_stats;

exec oracle_ocm.mgmt_config.collect_stats;

      

      PL/SQL procedure successfully completed.

PRINT_JOB_DETAILS

Print details of the confguration collection job mgmt_config.print_job_details;

exec oracle_ocm.mgmt_config.print_job_details;

      Configuration collection job name: MGMT_CONFIG_JOB

      Statistics collection job name: MGMT_STATS_CONFIG_JOB

      Job Schedule: DAILY

RUN_NOW

Runs the configuration collection job mgmt_config.run_now;

exec oracle_ocm.mgmt_config.run_now;

      

      PL/SQL procedure successfully completed.

STOP_JOB

Stop running the configuration collection job mgmt_config.stop_job;

exec oracle_ocm.mgmt_config.stop_job;

      

      PL/SQL procedure successfully completed.

SUBMIT_JOB

Submit a job to collect the configuration.
Basically, a job with what->printCollectConfigMetrics(<collection directory> mgmt_config.submit_job;

exec oracle_ocm.mgmt_config.submit_job;

      

      PL/SQL procedure successfully completed.