Oracle DBMS_IREFSTATS
Version 18.3.0.1

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_SNAPSHOT_KKXRCA MVREF$_STATS
DBMS_ASSERT DBMS_SPACE MVREF$_STATS_PARAMS
DBMS_IREFRESH DBMS_STANDARD MVREF$_STATS_SYS_DEFAULTS
DBMS_ISNAPSHOT DBMS_SYNC_REFRESH_INTERNAL MVREF$_STMT_STATS
DBMS_MVIEW_STATS DBMS_SYSTEM OBJ$
DBMS_MVIEW_STATS_INTERNAL MVREF$_CHANGE_STATS USER$
DBMS_REFRESH MVREF$_RUN_STATS  
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
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 18cR3
What's New In 19cR3

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