Oracle | PRVT_AWR_DATA

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