Oracle | DBMS_IREFSTATS

Oracle DBMS_IREFSTATS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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

      

      PL/SQL procedure successfully completed.

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');

      

      PL/SQL procedure successfully completed.

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

      

      PL/SQL procedure successfully completed.

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

      

      PL/SQL procedure successfully completed.

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

      

      PL/SQL procedure successfully completed.