Oracle | PRVT_AWR_DATA

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	GET_EVTS_HOTOBJ	GET_EVT_HOTOBJ
GET_ECLS_HOTOBJ

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