Oracle | PRVTEMX

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