Oracle | PRVT_AWR

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	GET_MEMORY_COMPONENTS	GET_SGA_ADVICE
GET_BC_ADVICE	GET_MEM_ADVICE	GET_SHARED_POOL_ADVICE
GET_CURSOR_INV	GET_OBJDETAILS	GET_SQLSTAT
GET_HOST_STATS	GET_PARAMETERS	GET_STREAMS_ADVICE
GET_ICDEV_STATS	GET_PGASTAT	GET_SYSSTAT
GET_IC_TRAFFIC	GET_PGA_ADVICE	GET_TIME_MODEL
GET_IC_TRANSFER_DETAILS	GET_PING_STATS	GET_TOP_SQL_DETAILS
GET_IO_STATS	GET_SESS_STAT	GET_WAITCLASS_CHART
GET_LITERAL_USAGE_STATS	GET_SGASTAT	GET_WAIT_EVENTS

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