Oracle | DBMS_IREFSTATS

Oracle DBMS_IREFSTATS 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 Internal support for Materialized View refreshes

AUTHID DEFINER

Dependencies

DBMS_ADVISOR	DBMS_STANDARD	MVREF$_STATS_PARAMS
DBMS_ASSERT	DBMS_SYSTEM	MVREF$_STATS_SYS_DEFAULTS
DBMS_MVIEW_STATS	MVREF$_CHANGE_STATS	MVREF$_STMT_STATS
DBMS_MVIEW_STATS_INTERNAL	MVREF$_RUN_STATS	OBJ$
DBMS_SPACE	MVREF$_STATS	USER$

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtsnmap.plb

Subprograms

DUMP_TRACE	PURGE_STATS	RUN_SA
PURGE_ALL_STATS	PURGE_STATS_MV_RP	WRITE_TRACE

DUMP_TRACE

Undocumented dbms_irefstats.dump_trace( message IN VARCHAR2, time_info IN BOOLEAN);

exec dbms_irefstats.dump_trace('Test Message', TRUE);

PURGE_ALL_STATS

Undocumented dbms_irefstats.purge_all_stats( in_mv_owner IN VARCHAR2, in_mv_name IN VARCHAR2);

exec dbms_irefstats.purge_all_stats('UWCLASS', 'MV_FORCE');

PURGE_STATS

Undocumented dbms_irefstats.purge_stats( in_time IN TIMESTAMP, in_mv_owner IN VARCHAR2, in_mv_name IN VARCHAR2, in_retention_period IN NUMBER);

exec dbms_irefstats.purge_stats(SYSDATE-1, 'UWCLASS', 'MV_FORCE', 1);

PURGE_STATS_MV_RP

Undocumented dbms_irefstats.purge_stats_mv_rp( in_time IN TIMESTAMP, in_objnum IN NUMBER, in_retention_period IN NUMBER)

exec dbms_irefstats.purge_stats_mv_rp(SYSDATE-1, 84851, 1);

RUN_SA

Undocumented dbms_irefstats.run_sa( in_user_name IN VARCHAR2, in_table_name IN VARCHAR2, out_task_id OUT BINARY_INTEGER, out_recommendations OUT VARCHAR2, out_stmt1 OUT VARCHAR2, out_stmt2 OUT VARCHAR2);

TBD

WRITE_TRACE

Undocumented dbms_irefstats.write_trace( message IN VARCHAR2, time_info IN BOOLEAN, event_number IN NUMBER, event_level IN NUMBER);

exec dbms_irefstats.write_trace('Test Msg', TRUE, 10046, 12);