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