Oracle | DBMS_RMIN

Oracle DBMS_RMIN_SYS 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 Internal support for the DBMS_RESOURCE_MANAGER package which manages CPU and I/O resources for consumer groups and containers

AUTHID DEFINER

Dependencies

CDB_RESOURCE_PLAN$	DBMS_RMIN	RESOURCE_GROUP_MAPPING$
CDB_RESOURCE_PLAN_DIRECTIVE$	DBMS_SYS_ERROR	RESOURCE_MAPPING_PRIORITY$
DBMS_OUTPUT	PLITBLM	RESOURCE_PLAN$
DBMS_RESOURCE_MANAGER	RESOURCE_CATEGORY$	RESOURCE_PLAN_DIRECTIVE$
DBMS_RMGR_LIB	RESOURCE_CONSUMER_GROUP$

Documented No

First Available 12.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmsrmin.plb
{ORACLE_HOME}/rdbms/admin/prvtrmin.plb

Subprograms

BEGIN_IMPORT_EXPORT	RM$_CRT_PLAN_DIRECTIVE	RM$_NONCDB_TO_PDB
DOWNGRADE_PREP	RM$_DRP_CATEGORY	RM$_SET_CONSUMER_GROUP_MAPPING
INSTALL	RM$_DRP_CDB_DIRECTIVE	RM$_SUBPAREA
QPARAM	RM$_DRP_CDB_PLAN	RM$_SWTCH_SESSION_GROUP
RESTORE_OLD_INTERNAL_PLAN	RM$_DRP_GROUP	RM$_SWTCH_USR_GROUP
RM$_CALIBRATE_IO	RM$_DRP_PLAN	RM$_UPD_CATEGORY
RM$_CLRPAREA	RM$_DRP_PLAN_CSD	RM$_UPD_CDB_DIRECTIVE
RM$_CONSUMER_GROUP_MAPPING_PRI	RM$_DRP_PLAN_DIRECTIVE	RM$_UPD_CDB_PLAN
RM$_CRTPAREA	RM$_FLATTEN_PLANS	RM$_UPD_GROUP
RM$_CRT_CATEGORY	RM$_GET_MAINTENANCE_PLAN	RM$_UPD_PLAN
RM$_CRT_CDB_DIRECTIVE	RM$_GET_PLAN_TOTAL_SHARES	RM$_UPD_PLAN_DIRECTIVE
RM$_CRT_CDB_PLAN	RM$_IS_OTHER_GROUPS_SPECD	RM$_VLDPAREA
RM$_CRT_GROUP	RM$_IS_PDB_ENABLED	UNINSTALL
RM$_CRT_PLAN	RM$_IS_SYS_GROUP_SPECD

BEGIN_IMPORT_EXPORT

Undocumented dbms_rmin_sys.begin_import_export;

exec dbms_rmin_sys.begin_import_export;

DOWNGRADE_PREP

Undocumented dbms_rmin_sys.downgrade_prep( drop_all_cdb IN BOOLEAN, drop_all_profiles IN BOOLEAN);

TBD

INSTALL

Undocumented: Creates consumer groups, jobs, and resource plans dbms_rmin_sys.install;

exec dbms_rmin_sys.install;

      

      PL/SQL procedure successfully completed.

      

      SELECT owner, object_name, object_type

      FROM dba_objects

      WHERE last_ddl_time > SYSDATE-1/48

      ORDER BY 3,2,1;

      

      OWNER        OBJECT_NAME                   OBJECT_TYPE

      ------------ ----------------------------- -------------------------

      SYS          DEFAULT_CONSUMER_GROUP        CONSUMER GROUP

      SYS          LOW_GROUP                     CONSUMER GROUP

      SYS          SYS_GROUP                     CONSUMER GROUP

      SYS          CLEANUP_NON_EXIST_OBJ         JOB

      SYS          CLEANUP_ONLINE_IND_BUILD      JOB

      SYS          CLEANUP_ONLINE_PMO            JOB

      SYS          CLEANUP_TAB_IOT_PMO           JOB

      SYS          CLEANUP_TRANSIENT_PKG         JOB

      SYS          CLEANUP_TRANSIENT_TYPE        JOB

      SYS          FGR$AUTOPURGE_JOB             JOB

      SYS          ORA$AUTOTASK_CLEAN            JOB

      SYS          PMO_DEFERRED_GIDX_MAINT_JOB   JOB

      SYS          PURGE_LOG                     JOB

      SYS          RSE$CLEAN_RECOVERABLE_SCRIPT  JOB

      SYS          SM$CLEAN_AUTO_SPLIT_MERGE     JOB

      SYS          STOPJOB                       JOB

      SYS          APPQOS_PLAN                   RESOURCE PLAN

      SYS          DEFAULT_MAINTENANCE_PLAN      RESOURCE PLAN

      SYS          DEFAULT_PLAN                  RESOURCE PLAN

      SYS          DSS_PLAN                      RESOURCE PLAN

      SYS          ETL_CRITICAL_PLAN             RESOURCE PLAN

      SYS          MIXED_WORKLOAD_PLAN           RESOURCE PLAN

      SYS          ORA$QOS_PLAN                  RESOURCE PLAN

QPARAM

Undocumented dbms_rmin_sys.qparam(param IN VARCHAR2) RETURN VARCHAR2;

TBD

RESTORE_OLD_INTERNAL_PLAN

Undocumented dbms_rmin_sys.restore_old_internal_plan;

exec dbms_rmin_sys.restore_old_internal_plan;

      

      
      PL/SQL procedure successfully completed.

RM$_CALIBRATE_IO

Initiates an I/O calibration

The demo code at right will take a substantial amount of time to execute and will push IOPS to 100%

Run time on a laptop with a single 250GB SSD was as shown at right dbms_rmin_sys.rm$_calibrate_io( num_disks IN BINARY_INTEGER, max_latency IN BINARY_DOUBLE, max_iops OUT BINARY_INTEGER, max_mbps OUT BINARY_INTEGER, actual_latency OUT BINARY_DOUBLE, additional_info OUT VARCHAR2, additional_infolen IN BINARY_INTEGER);

set timing on

      

      DECLARE

       maxiops BINARY_INTEGER;

       maxmbps BINARY_INTEGER;

       actlat  BINARY_DOUBLE;

       addinfo dbms_id;

      BEGIN

        dbms_rmin_sys.rm$_calibrate_io(1, 100, maxiops, maxmbps, actlat, addinfo, 1);

        dbms_output.put_line(maxiops);

        dbms_output.put_line(maxmbps);

        dbms_output.put_line(actlat);

        dbms_output.put_line(addinfo);

      END;

      /

      

      Elapsed: 00:09:38.78

      

      PL/SQL procedure successfully completed.

RM$_CLRPAREA

Undocumented dbms_rmin_sys.rm$_clrparea(install IN BOOLEAN);

exec dbms_rmin_sys.rm$_clrparea(TRUE);

      

      
      PL/SQL procedure successfully completed.

RM$_CONSUMER_GROUP_MAPPING_PRI

Undocumented dbms_rmin_sys.rm$_consumer_group_mapping_pri( explicit IN NUMBER, oracle_user IN NUMBER, service_name IN NUMBER, client_os_user IN NUMBER, client_program IN NUMBER, client_machine IN NUMBER, module_name IN NUMBER, module_name_action IN NUMBER, service_module IN NUMBER, service_module_action IN NUMBER, client_id IN NUMBER)

TBD

RM$_CRTPAREA

Undocumented dbms_rmin_sys.rm$_crtparea(install IN BOOLEAN);

exec dbms_rmin_sys.rm$_crtparea(TRUE);

      

      
      PL/SQL procedure successfully completed.

RM$_CRT_CATEGORY

Undocumented dbms_rmin_sys.rm$_crt_category( category IN VARCHAR2, comment IN VARCHAR2, mandatory IN BOOLEAN);

TBD

RM$_CRT_CDB_DIRECTIVE

Undocumented dbms_rmin_sys.rm$_crt_cdb_directive( plan IN VARCHAR2, name IN VARCHAR2, comment IN VARCHAR2, shares IN NUMBER, utilization_limit IN NUMBER, parallel_server_limit IN NUMBER, memory_min IN NUMBER, memory_limit IN NUMBER, mandatory IN BOOLEAN, directive_type IN VARCHAR2, install IN BOOLEAN);

TBD

RM$_CRT_CDB_PLAN

Undocumented dbms_rmin_sys.rm$_crt_cdb_plan( plan IN VARCHAR2, comment IN VARCHAR2, mandatory IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_CRT_GROUP

Undocumented dbms_rmin_sys.rm$_crt_group( consumer_group IN VARCHAR2, comment IN VARCHAR2, mgmt_mth IN VARCHAR2, category IN VARCHAR2, internal_use IN BOOLEAN, mandatory IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_CRT_PLAN

Undocumented dbms_rmin_sys.rm$_crt_plan( plan IN VARCHAR2, comment IN VARCHAR2, mgmt_mth IN VARCHAR2, asl_mth IN VARCHAR2, pdl_mth IN VARCHAR2, qtimeout_mth IN VARCHAR2, sub_plan IN BOOLEAN, mandatory IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_CRT_PLAN_DIRECTIVE

Undocumented dbms_rmin_sys.rm$_crt_plan_directive( plan IN VARCHAR2, group_or_subplan IN VARCHAR2, comment IN VARCHAR2, cpu_p1 IN NUMBER, cpu_p2 IN NUMBER, cpu_p3 IN NUMBER, cpu_p4 IN NUMBER, cpu_p5 IN NUMBER, cpu_p6 IN NUMBER, cpu_p7 IN NUMBER, cpu_p8 IN NUMBER, active_sess_pool_p1 IN NUMBER, queueing_p1 IN NUMBER, parallel_degree_limit_p1 IN NUMBER, switch_group IN VARCHAR2, switch_time IN NUMBER, switch_estimate IN BOOLEAN, max_est_exec_time IN NUMBER, undo_pool IN NUMBER, max_idle_time IN NUMBER, max_idle_blocker_time IN NUMBER, switch_time_in_call IN NUMBER, mgmt_p1 IN NUMBER, mgmt_p2 IN NUMBER, mgmt_p3 IN NUMBER, mgmt_p4 IN NUMBER, mgmt_p5 IN NUMBER, mgmt_p6 IN NUMBER, mgmt_p7 IN NUMBER, mgmt_p8 IN NUMBER, switch_io_megabytes IN NUMBER, switch_io_reqs IN NUMBER, switch_for_call IN BOOLEAN, max_utilization_limit IN NUMBER, parallel_target_percentage IN NUMBER, parallel_queue_timeout IN NUMBER, parallel_server_limit IN NUMBER, utilization_limit IN NUMBER, switch_io_logical IN NUMBER, switch_elapsed_time IN NUMBER, shares IN NUMBER, parallel_stmt_critical IN VARCHAR2, session_pga_limit IN NUMBER, pq_timeout_action IN VARCHAR2, mandatory IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_DRP_CATEGORY

Undocumented dbms_rmin_sys.rm$_drp_category( category IN VARCHAR2, mandatory_drp IN BOOLEAN);

TBD

RM$_DRP_CDB_DIRECTIVE

Undocumented dbms_rmin_sys.rm$_drp_cdb_directive( plan IN VARCHAR2, name IN VARCHAR2, mandatory_drp IN BOOLEAN, directive_type IN VARCHAR2, install IN BOOLEAN);

TBD

RM$_DRP_CDB_PLAN

Undocumented dbms_rmin_sys.rm$_drp_cdb_plan( plan IN VARCHAR2, mandatory_drp IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_DRP_GROUP

Undocumented dbms_rmin_sys.rm$_drp_group( consumer_group IN VARCHAR2, mandatory_drp IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_DRP_PLAN

Undocumented dbms_rmin_sys.rm$_drp_plan( plan IN VARCHAR2, mandatory_drp IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_DRP_PLAN_CSD

Undocumented dbms_rmin_sys.rm$_drp_plan_csd(plan IN VARCHAR2);

TBD

RM$_DRP_PLAN_DIRECTIVE

Undocumented dbms_rmin_sys.rm$_drp_plan_directive( plan IN VARCHAR2, group_or_subplan IN VARCHAR2, mandatory_drp IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_FLATTEN_PLANS

Undocumented dbms_rmin_sys.rm$_flatten_plans;

exec dbms_rmin_sys.rm$_flatten_plans;

      

      PL/SQL procedure successfully completed.

RM$_GET_MAINTENANCE_PLAN

Undocumented dbms_rmin_sys.rm$_get_maintenance_plan RETURN VARCHAR2;

SELECT dbms_rmin_sys.rm$_get_maintenance_plan

      FROM dual;

      

      RM$_GET_MAINTENANCE_PLAN

      -------------------------

      DEFAULT_MAINTENANCE_PLAN

RM$_GET_PLAN_TOTAL_SHARES

Undocumented dbms_rmin_sys.rm$_get_plan_total_shares(plan_name IN VARCHAR2) RETURN NUMBER;

TBD

RM$_IS_OTHER_GROUPS_SPECD

Undocumented dbms_rmin_sys.rm$_is_other_groups_specd(plan_name IN VARCHAR2) RETURN BOOLEAN;

TBD

RM$_IS_PDB_ENABLED

Undocumented dbms_rmin_sys.rm$_is_pdb_enabled RETURN BOOLEAN;

BEGIN

        IF dbms_rmin_sys.rm$_is_pdb_enabled THEN

          dbms_output.put_line('PDB Resource Plans Enabled');

        ELSE

          dbms_output.put_line('PDB Resource Plans Not Enabled');

        END IF;

      END;

      /

      PDB Resource Plans Enabled

      

      PL/SQL procedure successfully completed.

RM$_IS_SYS_GROUP_SPECD

Undocumented dbms_rmin_sys.rm$_is_sys_group_specd(plan_name IN VARCHAR2) RETURN BOOLEAN;

TBD

RM$_NONCDB_TO_PDB

Undocumented dbms_rmin_sys.rm$_noncdb_to_pdb;

exec dbms_rmin_sys.rm$_noncdb_to_pdb;

RM$_SET_CONSUMER_GROUP_MAPPING

Undocumented dbms_rmin_sys.rm$_set_consumer_group_mapping( attribute IN VARCHAR2, attribute_value IN VARCHAR2, consumer_group IN VARCHAR2, install IN BOOLEAN);

TBD

RM$_SUBPAREA

Undocumented dbms_rmin_sys.rm$_subparea;

exec dbms_rmin_sys.rm$_subparea;

      

      PL/SQL procedure successfully completed.

RM$_SWTCH_SESSION_GROUP

Undocumented dbms_rmin_sys.rm$_swtch_session_group( session_id IN NUMBER, session_serial IN NUMBER, consumer_group IN VARCHAR2);

TBD

RM$_SWTCH_USR_GROUP

Undocumented dbms_rmin_sys.rm$_swtch_usr_group( user IN VARCHAR2, consumer_group IN VARCHAR2);

TBD

RM$_UPD_CATEGORY

Undocumented dbms_rmin_sys.rm$_upd_category( category IN VARCHAR2, new_comment IN VARCHAR2, mandatory IN BOOLEAN);

TBD

RM$_UPD_CDB_DIRECTIVE

Undocumented dbms_rmin_sys.rm$_upd_cdb_directive( plan IN VARCHAR2, name IN VARCHAR2, new_comment IN VARCHAR2, new_shares IN NUMBER, new_utilization_limit IN NUMBER, new_parallel_server_limit IN NUMBER, new_memory_min IN NUMBER, new_memory_limit IN NUMBER, mandatory IN BOOLEAN, directive_type IN VARCHAR2, install IN BOOLEAN);

TBD

RM$_UPD_CDB_PLAN

Undocumented dbms_rmin_sys.rm$_upd_cdb_plan( plan IN VARCHAR2, new_comment IN VARCHAR2, mandatory IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_UPD_GROUP

Undocumented dbms_rmin_sys.rm$_upd_group( consumer_group IN VARCHAR2, new_comment IN VARCHAR2, new_mgmt_mth IN VARCHAR2, new_category IN VARCHAR2, new_internal_use IN BOOLEAN, mandatory IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_UPD_PLAN

Undocumented dbms_rmin_sys.rm$_upd_plan( plan IN VARCHAR2, new_comment IN VARCHAR2, new_mgmt_mth IN VARCHAR2, new_asl_mth IN VARCHAR2, new_pdl_mth IN VARCHAR2, new_qtimeout_mth IN VARCHAR2, new_sub_plan IN BOOLEAN, mandatory IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_UPD_PLAN_DIRECTIVE

Undocumented dbms_rmin_sys.rm$_upd_plan_directive( plan IN VARCHAR2, group_or_subplan IN VARCHAR2, new_comment IN VARCHAR2, new_cpu_p1 IN NUMBER, new_cpu_p2 IN NUMBER, new_cpu_p3 IN NUMBER, new_cpu_p4 IN NUMBER, new_cpu_p5 IN NUMBER, new_cpu_p6 IN NUMBER, new_cpu_p7 IN NUMBER, new_cpu_p8 IN NUMBER, new_active_sess_pool_p1 IN NUMBER, new_queueing_p1 IN NUMBER, new_parallel_degree_limit_p1 IN NUMBER, new_switch_group IN VARCHAR2, new_switch_time IN NUMBER, new_switch_estimate IN BOOLEAN, new_max_est_exec_time IN NUMBER, new_undo_pool IN NUMBER, new_max_idle_time IN NUMBER, new_max_idle_blocker_time IN NUMBER, new_switch_time_in_call IN NUMBER, new_mgmt_p1 IN NUMBER, new_mgmt_p2 IN NUMBER, new_mgmt_p3 IN NUMBER, new_mgmt_p4 IN NUMBER, new_mgmt_p5 IN NUMBER, new_mgmt_p6 IN NUMBER, new_mgmt_p7 IN NUMBER, new_mgmt_p8 IN NUMBER, new_switch_io_megabytes IN NUMBER, new_switch_io_reqs IN NUMBER, new_switch_for_call IN BOOLEAN, new_max_utilization_limit IN NUMBER, new_parallel_target_percentage IN NUMBER, new_parallel_queue_timeout IN NUMBER, new_parallel_server_limit IN NUMBER, new_utilization_limit IN NUMBER, new_switch_io_logical IN NUMBER, new_switch_elapsed_time IN NUMBER, new_shares IN NUMBER, new_parallel_stmt_critical IN VARCHAR2, new_session_pga_limit IN NUMBER, new_pq_timeout_action IN VARCHAR2, mandatory IN BOOLEAN, install IN BOOLEAN);

TBD

RM$_VLDPAREA

Undocumented dbms_rmin_sys.rm$_vldparea;

exec dbms_rmin_sys.rm$_vldparea;

      

      PL/SQL procedure successfully completed.

UNINSTALL

Undocumented dbms_rmin_sys.uninstall;

exec dbms_rmin_sys.uninstall;

      

      PL/SQL procedure successfully completed.