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