Oracle PRVT_AWR_DATA_CP
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 Internal AWR Report Support Utilities
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 12.1
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
PRVT_AWR_DATA
What's New In 21c
What's New In 23c

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