Oracle DBMS_RMIN_SYS
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
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
ORACLE_OCM   MGMT_CONFIG_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.

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_RESOURCE_MANAGER
DBMS_RESOURCE_MANAGER_PRIVS
DBMS_RMGR_GROUP_EXPORT
DBMS_RMGR_PACT_EXPORT
DBMS_RMGR_PLAN_EXPORT
DBMS_RMIN
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx