Oracle | PRVT_AWR

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