Oracle PRVT_AWR_DATA_CP
Version 20c

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 Not Documented.

Note: This page has been posted prior to the GA release of 20c. It will be completed once we have access to the release version.
AUTHID CURRENT_USER
Data Types SQL> desc sys.prvt_awr_period
Name                 Null? Type
-------------------- ----- ---------------
M_TYPE                     VARCHAR2(10)
M_DBID                     NUMBER(38)
M_BEGIN_SNAP_ID            NUMBER(38)
M_END_SNAP_ID              NUMBER(38)
M_REQ_ANALYSIS             VARCHAR2(10)
M_ACTUAL_ANALYSIS          VARCHAR2(10)
M_INSTANCE_LIST            VARCHAR2(512)
M_INSTANCES                sys.prvt_awr_inst_meta_tab
M_DB_VERSION               VARCHAR2(17)
M_AWR_VERSION              VARCHAR2(17)
M_DB_NAME                  VARCHAR2(9)
M_BEGIN_TIME               DATE
M_END_TIME                 DATE
M_SNAPSHOT_INTR            NUMBER
M_DB_TIME                  NUMBER
M_ASH_ROW_CNT              NUMBER(38)
M_WRR_METADATA             XMLTYPE
M_IS_IMPORTED              NUMBER(38)
M_ERROR_XML                XMLTYPE
M_WARNING_XML              XMLTYPE

METHOD
------
FINAL CONSTRUCTOR FUNCTION PRVT_AWR_PERIOD RETURNS SELF AS RESULT
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
P_DBID                         NUMBER                  IN
P_BEGIN_SNAP_ID                NUMBER                  IN
P_END_SNAP_ID                  NUMBER                  IN
P_INSTANCE_NUMBER              NUMBER                  IN     DEFAULT
P_TYPE                         VARCHAR2                IN     DEFAULT

METHOD
------
MEMBER FUNCTION TO_XML RETURNS XMLTYPE

METHOD
------
MEMBER FUNCTION GET_INST_CLAUSE RETURNS VARCHAR2
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
P_TABLE_NAME                   VARCHAR2                IN

METHOD
------
MEMBER FUNCTION GET_TIME_PER_ROW RETURNS NUMBER

METHOD
------
MEMBER FUNCTION GET_ROW_CNT RETURNS NUMBER
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
P_DBTIME                       NUMBER                  IN
P_DEFAULT                      NUMBER                  IN
Dependencies
DBMS_ASSERT PRVT_AWR_EVTLIST PRVT_CPADDM
DUAL PRVT_AWR_PERIOD XMLTYPE
PLITBLM    
Documented No
First Available 12cR1
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvs_awr_data_cp.plb
Subprograms
 
GET_COMPATIBILITY
Undocumented prvt_awr_data_cp.get_compatibility(
base_time_period IN OUT sys.prvt_awr_period,
comp_time_period IN OUT sys.prvt_awr_period)
RETURN sys.prvt_awr_period;
TBD
 
GET_ECLS_HOTOBJ
Undocumented prvt_awr_data_cp.get_ecls_hotobj(
base_time_period IN OUT sys.prvt_awr_period,
base_xml         IN OUT sys.xmltype,
comp_time_period IN OUT sys.prvt_awr_period,
comp_xml         IN OUT sys.xmltype,
WAITCLASSLIST    IN     sys.prvt_awr_evtlist,
p_tag            IN     VARCHAR2,
cutoff           IN     NUMBER);
TBD
 
GET_EVTS_HOTOBJ
Undocumented prvt_awr_data_cp.get_evts_hotobj(
base_time_period IN OUT sys.prvt_awr_period,
base_xml         IN OUT sys.xmltype,
comp_time_period IN OUT sys.prvt_awr_period,
comp_xml         IN OUT sys.xmltype,
eventlist        IN OUT sys.prvt_awr_evtlist,
p_tag            IN     VARCHAR2,
cutoff           IN     NUMBER);
TBD
 
GET_EVT_HOTOBJ
Undocumented prvt_awr_data_cp.get_evt_hotobj(
base_time_period IN OUT sys.prvt_awr_period,
base_xml         IN OUT sys.xmltype,
comp_time_period IN OUT sys.prvt_awr_period,
comp_xml         IN OUT sys.xmltype,
eventname        IN     VARCHAR2,
cutoff           IN     NUMBER);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AWR_REPORT_LAYOUT
DBMS_MANAGEMENT_BOOTSTRAP
DBMS_MANAGEMENT_PACKS
DBMS_WORKLOAD_REPOSITORY
What's New In 19c
What's New In 20c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx