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