Oracle DBMS_IREFSTATS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.
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