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
Undocumented
AUTHID
CURRENT_USER
Dependencies
DBMS_ASH_INTERNAL
PRVT_AWR_INST_META
PRVT_AWR_PERIOD
DUAL
PRVT_AWR_INST_META_TAB
PRVT_CPADDM
PLITBLM
PRVT_AWR_NUMTAB
XMLTYPE
Documented
No
First Available
12.1
Security Model
Owned by SYS with EXECUTE granted to PUBLIC
Source
{ORACLE_HOME}/rdbms/admin/prvs_awr_data.plb
Subprograms
GET_BASIC_ASH_STATS
Undocumented
prvt_awr_data.get_basic_ash_stats(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_BC_ADVICE
Undocumented
prvt_awr_get_bc_advice(data.time_period IN/OUT sys.prvt_awr_period)
RETURN sys.xmltype;
DECLARE
awrper sys.prvt_awr_period := sys.prvt_awr_period(2140826538, 3400, 3509, NULL, NULL);
retVal sys.xmltype;
BEGIN
retVal := prvt_awr_data.get_bc_advice (awrper);
dbms_output.put_line(retVal.getClobVal());
END;
/
<bca></bca>
PL/SQL procedure successfully completed.
GET_CURSOR_INV
Undocumented
prvt_awr_data.get_cursor_inv(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_HOST_STATS
Undocumented
prvt_awr_data.get_host_stats(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
DECLARE
awrper sys.prvt_awr_period := sys.prvt_awr_period(2140826538, 3400, 3509, NULL, NULL);
retVal sys.xmltype;
BEGIN
retVal := prvt_awr_data.get_host_stats (awrper);
dbms_output.put_line(retVal.getClobVal());
END;
/
<host_stats></host_stats>
PL/SQL procedure successfully completed.
GET_ICDEV_STATS
Undocumented
prvt_awr_data.get_icdev_stats(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_IC_TRAFFIC
Undocumented
prvt_awr_data.get_ic_traffic(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_IC_TRANSFER_DETAILS
Undocumented
prvt_awr_data.get_ic_transfer_details(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_IO_STATS
Undocumented
prvt_awr_data.get_io_stats(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_LITERAL_USAGE_STATS
Undocumented
prvt_awr_data.get_literal_usage_stats(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_MEMORY_COMPONENTS
Undocumented
prvt_awr_data.get_memory_components(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_MEM_ADVICE
Undocumented
prvt_awr_data.get_mem_advice(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_OBJDETAILS
Undocumented
prvt_awr_data.get_objdetails(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_PARAMETERS
Undocumented
prvt_awr_data.get_parameters(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_PGASTAT
Undocumented
prvt_awr_data.get_pgastat(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_PGA_ADVICE
Undocumented
prvt_awr_data.get_pga_advice(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_PING_STATS
Undocumented
prvt_awr_data.get_ping_stats(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_SESS_STAT
Undocumented
prvt_awr_data.get_sess_stat(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_SGASTAT
Undocumented
prvt_awr_data.get_sgastat(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_SGA_ADVICE
Undocumented
prvt_awr_data.get_sga_advice(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_SHARED_POOL_ADVICE
Undocumented
prvt_awr_data.get_shared_pool_advice(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_SQLSTAT
Undocumented
prvt_awr_data.get_sqlstat(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_STREAMS_ADVICE
Undocumented
prvt_awr_data.get_streams_advice(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_SYSSTAT
Undocumented
prvt_awr_data.get_sysstat(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_TIME_MODEL
Undocumented
prvt_awr_data.get_time_model(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_TOP_SQL_DETAILS
Undocumented
prvt_awr_data.get_top_sql_details(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_WAITCLASS_CHART
Undocumented
prvt_awr_data.get_waitclass_chart(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD
GET_WAIT_EVENTS
Undocumented
prvt_awr_data.get_wait_events(time_period IN OUT sys.prvt_awr_period)
RETURN sys.xmltype;
TBD