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

Related Topics
Built-in Functions
Built-in Packages
DBMS_IREFRESH
DBMS_MVIEW
DBMS_REFRESH
DBMS_SNAPSHOT_UTL
Materialized Views
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx