Oracle PRVT_AWR_DATA
Version 21c

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 Not known
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 19c
What's New In 20c-21c

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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx