Oracle DBMS_IREFSTATS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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.0.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtsnmap.plb
Subprograms
 
DUMP_TRACE (new 12.2)
Undocumented dbms_irefstats.dump_trace(
message   IN VARCHAR2,
time_info IN BOOLEAN);
exec dbms_irefstats.dump_trace('Test Message', TRUE);
 
PURGE_ALL_STATS (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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);

Related Topics
Built-in Functions
Built-in Packages
DBMS_IREFRESH
DBMS_MVIEW
DBMS_REFRESH
DBMS_SNAPSHOT_UTL
Materialized Views
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved