Oracle | DBMS

Oracle DBMS_RMIN 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 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.