Oracle | DBMS

Oracle DBMS_RMIN 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 Resource Manager Utilities

AUTHID CURRENT_USER

Data Types TYPE upcgm_table_type ...

Dependencies

DBMS_RESOURCE_MANAGER	DBMS_RMGR_LIB	DBMS_SYS_ERROR
DBMS_RESOURCE_MANAGER_PRIVS	DBMS_RMIN_SYS	DBMS_WLM

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsrmin

Subprograms

RM$_BGN_SQLBLK	RM$_PROCESS_PRIV	RM$_SET_INITIAL_GROUP
RM$_END_SQLBLK	RM$_PROCESS_PRIV_EXT	RM$_UP_CONSUMER_GROUP_MAPPINGS
RM$_NONCDB_TO_PDB	RM$_RUN_QUEUED_PARALLEL_STMT	RM$_VERIFY_PRIVILEGES

RM$_BGN_SQLBLK

Undocumented dbms_rmin.rm$_bgn_sqlblk;

exec dbms_rmin.rm$_bgn_sqlblk;

      

      PL/SQL procedure successfully completed.

RM$_END_SQLBLK

Undocumented dbms_rmin.rm$_end_sqlblk;

exec dbms_rmin.rm$_end_sqlblk;

      

      PL/SQL procedure successfully completed.

RM$_NONCDB_TO_PDB

Undocumented dbms_rmin.rm$_noncdb_to_pdb;

exec dbms_rmin.rm$_noncdb_to_pdb;

      

      plan to import: MIXED_WORKLOAD_PLAN

      multilevel count: 0

      nonsubplan directives: 5

      total directives: 5

      plan to import: DEFAULT_MAINTENANCE_PLAN

      multilevel count: 0

      nonsubplan directives: 3

      total directives: 3

      plan to import: DEFAULT_PLAN

      multilevel count: 0

      nonsubplan directives: 3

      total directives: 3

      plan to import: INTERNAL_QUIESCE

      multilevel count: 0

      nonsubplan directives: 2

      total directives: 2

      plan to import: INTERNAL_PLAN

      multilevel count: 0

      nonsubplan directives: 3

      total directives: 3

      plan to import: DSS_PLAN

      multilevel count: 0

      nonsubplan directives: 7

      total directives: 7

      plan to import: ETL_CRITICAL_PLAN

      multilevel count: 0

      nonsubplan directives: 7

      total directives: 7

      plan to import: ORA$ROOT_PLAN

      multilevel count: 0

      nonsubplan directives: 2

      total directives: 2

      plan to import: ORA$QOS_PLAN

      multilevel count: 0

      nonsubplan directives: 7

      total directives: 7

      plan to import: APPQOS_PLAN

      multilevel count: 6

      nonsubplan directives: 7

      total directives: 7

      flattening plan: APPQOS_PLAN

      before cull plan dir count: 7

      after cull plan dir count: 7

      after cull and round, shares add up to 100

      

      PL/SQL procedure successfully completed.

RM$_PROCESS_PRIV

Undocumented dbms_rmin.rm$_process_priv( username IN VARCHAR2, is_syspriv IN BINARY_INTEGER, isgrant IN BINARY_INTEGER, class IN VARCHAR2, grant_or_admin_option IN BINARY_INTEGER, priv_code IN BINARY_INTEGER);

TBD

RM$_PROCESS_PRIV_EXT

Undocumented dbms_rmin.rm$_process_priv_ext( username IN VARCHAR2, is_syspriv IN BINARY_INTEGER, isgrant IN BINARY_INTEGER, consumer_group IN VARCHAR2, grant_or_admin_option IN BINARY_INTEGER, priv_code IN BINARY_INTEGER, user_fieldname IN VARCHAR2);

TBD

RM$_RUN_QUEUED_PARALLEL_STMT

Undocumented dbms_rmin.rm$_run_queued_parallel_stmt( sid IN BINARY_INTEGER, serial IN BINARY_INTEGER, inst_id IN BINARY_INTEGER, sql_id IN VARCHAR2);

TBD

RM$_SET_INITIAL_GROUP

Undocumented dbms_rmin.rm$_set_initial_group( user IN VARCHAR2, consumer_group IN VARCHAR2);

TBD

RM$_UP_CONSUMER_GROUP_MAPPINGS

Undocumented dbms_rmin.rm$_up_consumer_group_mappings( attributes IN sys.dbms_rmin.upcgm_table_type, attribute_values IN sys.dbms_rmin.upcgm_table_type, consumer_groups IN sys.dbms_rmin.upcgm_table_type);

TBD

RM$_VERIFY_PRIVILEGES

Undocumented dbms_rmin.rm$_verify_privileges;

exec dbms_rmin.rm$_verify_privileges;

      

      PL/SQL procedure successfully completed.