Oracle | PRVTEMX

Oracle PRVTEMX_RSRCMGR 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 Undocumented

AUTHID CURRENT_USER

Dependencies

ALL_SCHEDULER_WINDOWS	DBMS_SQLTUNE_UTIL0	PRVT_AWRV_METADATA
ALL_SERVICES	DUAL	PRVT_AWR_VIEWER
ALL_USERS	GV_$RSRC_PLAN	PRVT_REPORT_TAGS
DBA_RSRC_GROUP_MAPPINGS	GV_$SESSION	V_$PARAMETER
DBA_RSRC_PLAN_DIRECTIVES	PRVTEMX_ADMIN	V_$RSRC_PLAN
DBMS_ASH_INTERNAL	PRVTEMX_DBHOME	WRI$_REPT_RSRCMGR
DBMS_REPORT	PRVT_AWRV_INSTTAB	XMLTYPE
DBMS_RESOURCE_MANAGER	PRVT_AWRV_MAPTAB	XQSEQUENCE
DBMS_SCHEDULER

Documented No

Exceptions

Error Code	Reason
ORA-13971	Unknown component

First Available 12.2

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtemx_rsrcmgr.plb

Subprograms

CREATE_CDB_PLAN_DIRECTIVE	REPORT_SET_ACTIVE_PLAN_XML	REPORT_SHOW_MAPPINGS_XML
CREATE_CDB_PLAN_DIR_SAVEERR	REPORT_SET_DIRECTIVES_XML	REPORT_SHOW_PLANS_XML
DELETE_CDB_PLAN_DIRECTIVE	REPORT_SET_INSTANCE_CAGING_XML	REPORT_SHOW_PLAN_XML
REPORT_ADD_GROUP_XML	REPORT_SET_MAINT_WINDOWS_XML	REPORT_SHOW_TIMELINE_XML
REPORT_CREATE_GROUP_XML	REPORT_SET_MAPPINGS_XML	REPORT_UPDATE_CDB_PLAN_XML
REPORT_CREATE_PLAN_XML	REPORT_SET_MAPPING_PRI_XML	REPORT_UPDATE_GROUP_XML
REPORT_DELETE_PLAN_XML	REPORT_SHOW_DASHBOARD_XML	REPORT_UPDATE_PDB_DIR_XML
REPORT_GET_ATTRIBUTES_XML	REPORT_SHOW_GROUPS_XML	REPORT_UPDATE_PLAN_XML
REPORT_GROUP_DELETABLE_XML	REPORT_SHOW_MAINT_WINDOWS_XML	UPDATE_CDB_PLAN_DIRECTIVE
REPORT_REMOVE_GROUP_XML

CREATE_CDB_PLAN_DIRECTIVE

Undocumented prvtemx_rsrcmgr.create_cdb_plan_directive( p_plan IN VARCHAR2, p_pdb IN VARCHAR2, p_shares IN NUMBER, p_cpu_limit IN NUMBER, p_px_limit IN NUMBER, p_memory_min IN NUMBER, p_memory_limit IN NUMBER, p_show_sql IN NUMBER) RETURN CLOB;

TBD

CREATE_CDB_PLAN_DIR_SAVEERR

Undocumented prvtemx_rsrcmgr.create_cdb_plan_dir_saveerr( p_plan IN VARCHAR2, p_pdb IN VARCHAR2, p_shares IN NUMBER, p_cpu_limit IN NUMBER, p_px_limit IN NUMBER, p_memory_min IN NUMBER, p_memory_limit IN NUMBER, p_show_sql IN NUMBER, p_error_xml OUT sys.xmltype) RETURN CLOB;

TBD

DELETE_CDB_PLAN_DIRECTIVE

Undocumented prvtemx_rsrcmgr.delete_cdb_plan_directive( p_plan IN VARCHAR2, p_pdb IN VARCHAR2, p_show_sql IN NUMBER) RETURN CLOB;

TBD

REPORT_ADD_GROUP_XML

Undocumented prvtemx_rsrcmgr.report_add_group_xml( p_plan IN VARCHAR2, p_name IN VARCHAR2, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_CREATE_GROUP_XML

Undocumented prvtemx_rsrcmgr.report_create_group_xml( p_plan IN VARCHAR2, p_name IN VARCHAR2, p_comment IN VARCHAR2, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_CREATE_PLAN_XML

Undocumented prvtemx_rsrcmgr.report_create_plan_xml( p_name IN VARCHAR2, p_comment IN VARCHAR2, p_consumer_groups_xml IN sys.xmltype, p_shares IN NUMBER, p_cpu_limit IN NUMBER, p_px_limit IN NUMBER, p_memory_min IN NUMBER, p_memory_limit IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_DELETE_PLAN_XML

Undocumented prvtemx_rsrcmgr.report_delete_plan_xml( p_name IN VARCHAR2, p_delete_cascade IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_GET_ATTRIBUTES_XML

Undocumented prvtemx_rsrcmgr.report_get_attributes_xml( p_get_service IN NUMBER, p_get_user IN NUMBER, p_get_program IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_GROUP_DELETABLE_XML

Undocumented prvtemx_rsrcmgr.report_group_deletable_xml( p_name IN VARCHAR2, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_REMOVE_GROUP_XML

Undocumented prvtemx_rsrcmgr.report_remove_group_xml( p_plan IN VARCHAR2, p_name IN VARCHAR2, p_delete_group IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SET_ACTIVE_PLAN_XML

Undocumented prvtemx_rsrcmgr.report_set_active_plan_xml( p_plan IN VARCHAR2, p_shares IN NUMBER, p_cpu_limit IN NUMBER, p_px_limit IN NUMBER, p_memory_min IN NUMBER, p_memory_limit IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SET_DIRECTIVES_XML

Undocumented prvtemx_rsrcmgr.report_set_directives_xml( p_plan IN VARCHAR2, p_name IN VARCHAR2, p_shares IN NUMBER, p_cpu_limit IN NUMBER, p_px_max_dop IN NUMBER, p_px_limit IN NUMBER, p_px_timeout IN NUMBER, p_px_bypass_queue IN NUMBER, p_rq_elapsed_time IN NUMBER, p_rq_cpu_time IN NUMBER, p_rq_io IN NUMBER, p_rq_logical_io IN NUMBER, p_rq_io_req IN NUMBER, p_rq_action IN VARCHAR2, p_max_pga IN NUMBER, p_max_temp IN NUMBER, p_max_idle_time IN NUMBER, p_max_idle_blocker_time IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SET_INSTANCE_CAGING_XML

Undocumented prvtemx_rsrcmgr.report_set_instance_caging_xml( p_enable IN NUMBER, p_cpu_count IN NUMBER, p_plan IN VARCHAR2, p_sid IN VARCHAR2, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SET_MAINT_WINDOWS_XML

Undocumented prvtemx_rsrcmgr.report_set_maint_windows_xml( p_plan IN VARCHAR2, p_windows_xml IN sys.xmltype, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SET_MAPPINGS_XML

Undocumented prvtemx_rsrcmgr.report_set_mappings_xml( p_name IN VARCHAR2, p_user IN sys.xmltype, p_service IN sys.xmltype, p_os_user IN sys.xmltype, p_program IN sys.xmltype, p_machine IN sys.xmltype, p_client_id IN sys.xmltype, p_module IN sys.xmltype, p_module_action IN sys.xmltype, p_service_module IN sys.xmltype, p_service_module_action IN sys.xmltype, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SET_MAPPING_PRI_XML

Undocumented prvtemx_rsrcmgr.report_set_mapping_pri_xml( p_explicit IN NUMBER, p_user IN NUMBER, p_service IN NUMBER, p_os_user IN NUMBER, p_program IN NUMBER, p_machine IN NUMBER, p_module IN NUMBER, p_module_action IN NUMBER, p_service_module IN NUMBER, p_service_module_action IN NUMBER, p_client_id IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SHOW_DASHBOARD_XML

Undocumented prvtemx_rsrcmgr.report_show_dashboard_xml( p_duration IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SHOW_GROUPS_XML

Undocumented prvtemx_rsrcmgr.report_show_groups_xml( p_plan_to_exclude IN VARCHAR2, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SHOW_MAINT_WINDOWS_XML

Undocumented prvtemx_rsrcmgr.report_show_maint_windows_xml( p_plan IN VARCHAR2, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SHOW_MAPPINGS_XML

Undocumented prvtemx_rsrcmgr.report_show_mappings_xml( p_consumer_group IN VARCHAR2, p_include_user IN NUMBER, p_include_service IN NUMBER, p_include_os_user IN NUMBER, p_include_program IN NUMBER, p_include_machine IN NUMBER, p_include_client_id IN NUMBER, p_include_module IN NUMBER, p_include_action IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SHOW_PLANS_XML

Undocumented prvtemx_rsrcmgr.report_show_plans_xml( p_level IN VARCHAR2, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SHOW_PLAN_XML

Undocumented prvtemx_rsrcmgr.report_show_plan_xml( p_plan IN VARCHAR2, p_duration IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_SHOW_TIMELINE_XML

Undocumented prvtemx_rsrcmgr.report_show_timeline_xml( p_duration IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_UPDATE_CDB_PLAN_XML

Undocumented prvtemx_rsrcmgr.report_update_cdb_plan_xml( p_plan IN VARCHAR2, p_comment IN VARCHAR2, p_shares IN NUMBER, p_cpu_limit IN NUMBER, p_px_limit IN NUMBER, p_memory_min IN NUMBER, p_memory_limit IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_UPDATE_GROUP_XML

Undocumented prvtemx_rsrcmgr.report_update_group_xml( p_consumer_group IN VARCHAR2, p_comment IN VARCHAR2, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_UPDATE_PDB_DIR_XML

Undocumented prvtemx_rsrcmgr.report_update_pdb_dir_xml( p_plan IN VARCHAR2, p_pdb IN VARCHAR2, p_comment IN VARCHAR2, p_shares IN NUMBER, p_cpu_limit IN NUMBER, p_px_limit IN NUMBER, p_memory_min IN NUMBER, p_memory_limit IN NUMBER, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

REPORT_UPDATE_PLAN_XML

Undocumented prvtemx_rsrcmgr.resport_update_plan_xml( p_plan IN VARCHAR2, p_comment IN VARCHAR2, p_show_sql IN NUMBER) RETURN sys.xmltype;

TBD

UPDATE_CDB_PLAN_DIRECTIVE

Undocumented prvtemx_rsrcmgr.update_cdb_plan_directive( p_plan IN VARCHAR2, p_pdb IN VARCHAR2, p_comment IN VARCHAR2, p_shares IN NUMBER, p_cpu_limit IN NUMBER, p_px_limit IN NUMBER, p_memory_min IN NUMBER, p_memory_limit IN NUMBER, p_show_sql IN NUMBER) RETURN CLOB;

TBD