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

Related Topics
Built-in Functions
Built-in Packages
Database Security
PRVTEMX_ADMIN
PRVT_AWR_DATA
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