Oracle PRVT_AWR_DATA
Version 21c

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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AWR_REPORT_LAYOUT
DBMS_MANAGEMENT_BOOTSTRAP
DBMS_MANAGEMENT_PACKS
DBMS_WORKLOAD_REPOSITORY
PRVTEMX_RSRCMGR
PRVT_AWR_DATA_CP
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx