Oracle | DBMS_IREFSTATS

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