Oracle DBMS_SWAT_MM_UTILS
Version 21c

General Information j
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 Undocumented internal utility supporting Automatic Materialized Views
AUTHID DEFINER
Data Types TYPE all_mv_rec_table_type ...
Dependencies
ACTIVITY_SNAP_META$ DBMS_DATA_MINING SWAT_MM_ACT_MVIEW$
ACTIVITY_TABLE$ DBMS_OUTPUT SWAT_MM_ACT_SNAL_META$
DBA_ACTIVITY_CONFIG DBMS_STANDARD SWAT_MM_DBA_ACT_MVIEW$
DBA_ACTIVITY_MVIEW DBMS_SUMA_LIB SWAT_MM_DBA_ACT_TABLE$
DBA_ACTIVITY_TABLE DBMS_SWAT_INTERNAL SWAT_MM_JOURNAL$
DBA_DEPENDENCIES DBMS_SWAT_MM_INTERNAL SWAT_MM_REFRESH_HISTORY$
DBA_MINING_MODELS DBMS_SYSTEM SWAT_MM_REFRESH_ID_SEQ$
DBA_MVIEWS DBMS_UTILITY SWAT_MM_SID_MAPPING$
DBA_MVIEW_DETAIL_RELATIONS DUAL SWAT_VER_MV_BENEFIT$
DBA_MVIEW_LOGS OBJ$ USER$
DBA_VIEWS PLITBLM UTL_CALL_STACK
DBMS_ASSERT SUM$  
Documented No
First Available 20c
Security Model Owned by SYS with no privileges granted

All functionality in this package is protected by an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/prvsswatmm.plb
Subprograms
 
CHECK_VOL (new 21c)
Undocumented dbms_swat_mm_utils.check_vol(obj_num IN NUMBER) RETURN NUMBER;
SELECT object_id, object_type
FROM dba_objects
WHERE owner = 'C##UWCLASS'
AND object_name = 'MV_SIMPLE';

 OBJECT_ID OBJECT_TYPE
---------- -------------------------
90063      TABLE
90065      MATERIALIZED VIEW


SELECT dbms_swat_mm_utils.check_vol(9065)
FROM dual;
SELECT dbms_swat_mm_utils.check_vol(9065)
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object DBMS_SWAT_MM_UTILS
 
CLEANUP_BEFORE_DISABLE (new 21c)
Undocumented dbms_swat_mm_utils.cleanup_before_disable;
Protected by from use by an Accessible By clause
 
CLEANUP_DRIVER (new 21c)
Undocumented dbms_swat_mm_utils.cleanup_driver RETURN BOOLEAN;
Protected by from use by an Accessible By clause
 
DO_DDL (new 21c)
Undocumented dbms_swat_mm_utils.do_ddl(
command      IN VARCHAR2,
owner        IN VARCHAR2,
name         IN VARCHAR2,
post_command IN VARCHAR2);
Protected by from use by an Accessible By clause
 
DROP_FAILING_REFRESH_AUTOMVS (new 21c)
Undocumented dbms_swat_mm_utils.drop_failing_refresh_automvs;
Protected by from use by an Accessible By clause
 
DROP_INVALID_AUTOMVS (new 21c)
Undocumented dbms_swat_mm_utils.drop_invalid_automvs;
Protected by from use by an Accessible By clause
 
DROP_MV_AND_UNNEEDED_LOGS (new 21c)
Undocumented dbms_swat_mm_utils.drop_mv_and_unneeded_logs(
in_mv_owner IN VARCHAR2,
in_mv_name  IN VARcHAR2);
Protected by from use by an Accessible By clause
 
DROP_UNUSED_AUTOMVLOGS (new 21c)
Undocumented dbms_swat_mm_utils.drop_unused_automvlogs;
Protected by from use by an Accessible By clause
 
DROP_UNUSED_MVS (new 21c)
Undocumented dbms_swat_mm_utils.drop_unused_mvs(in_current_date IN DATE);
Protected by from use by an Accessible By clause
 
DUMP_TRACE (new 21c)
Undocumented dbms_swat_mm_utils.dump_trace(
message   IN VARCHAR2,
time_info IN BOOLEAN);
Protected by from use by an Accessible By clause
 
FLUSH_MESSAGE (new 21c)
Undocumented dbms_swat_mm_utils.flush_message(journaltype IN VARCHAR2);
Protected by from use by an Accessible By clause
 
FMTNUM (new 21c)
Undocumented dbms_swat_mm_utils.fmtNum(
num    IN NUMBER,
maxval IN NUMBER,
fmtarg IN VARCHAR2)
RETURN VARCHAR2;
Protected by from use by an Accessible By clause
 
GET_ACT_CHANGE_DATA (new 21c)
Undocumented dbms_swat_mm_utils.get_act_change_data(
in_mv_owner       IN  VARCHAR2,
in_mv_name        IN  VARCHAR2,
last_refresh_date IN  DATE,
in_current_date   IN  DATE,
act_change_data   OUT sys.dbms_swat_mm_internal.change_data_rec,
num_tables        OUT NUMBER);
Protected by from use by an Accessible By clause
 
GET_CANON_DATE_INFO (new 21c)
Undocumented dbms_swat_mm_utils.get_canon_date_info(
curds                    IN  DATE,
curde                    IN  DATE,
snapshot_interval        IN  NUMBER,
real_snap_id             IN  NUMBER,
same_canon_snapshot_flag OUT BOOLEAN,
first_snapid             OUT NUMBER,
first_snap_startdate     OUT DATE,
first_snap_enddate       OUT DATE,
first_fraction           OUT NUMBER,
last_snapid              OUT NUMBER,
last_snap_startdate      OUT DATE,
last_snap_enddate        OUT DATE,
last_fraction            OUT NUMBER,
trace_flag               IN  BOOLEAN);
Protected by from use by an Accessible By clause
 
GET_CD (new 21c)
Undocumented dbms_swat_mm_utils.get_cd(trace_flag IN CHAR) RETURN DATE;
Protected by from use by an Accessible By clause
 
GET_MOS_RUN_PARAMS (new 21c)
Undocumented dbms_swat_mm_utils.get_mos_run_params(
in_current_date   IN  DATE,
current_dow       OUT NUMBER,
current_snap      OUT NUMBER,
starting_dow      OUT NUMBER,
starting_snap     OUT NUMBER,
ending_dow        OUT NUMBER,
ending_snap       OUT NUMBER,
prediction_window OUT NUMBER,
mos_prob_method   OUT VARCHAR2,
mos_pred_window   OUT NUMBER,
tot_gen_days      OUT NUMBER);
Protected by from use by an Accessible By clause
 
GET_NUM_DAYS (new 21c)
Undocumented dbms_swat_mm_utils.get_num_days(
in_obj_num      IN  NUMBER,
in_current_date IN  DATE,
min_canon_sid   OUT NUMBER,
num_gen_days    OUT NUMBER,
tot_dow_days    OUT NUMBER,
num_dow_days    OUT NUMBER);
Protected by from use by an Accessible By clause
 
GET_NUM_STALEMVS (new 21c)
Undocumented dbms_swat_mm_utils.get_num_staleMVs RETURN NUMBER;
Protected by from use by an Accessible By clause
 
GET_REFRESH_ID< (new 21c)
Undocumented dbms_swat_mm_utils.get_refresh_id(
swat_mm_start_time IN DATE,
in_mv_owner        IN VARCHAR2,
in_mv_name         IN VARCHAR2,
in_mv_size         IN NUMBER,
in_refresh_type    IN NUMBER)
RETURN NUMBER;
Protected by from use by an Accessible By clause
 
GET_TOTAL_REFRESH_TIME (new 21c)
Undocumented dbms_swat_mm_utils.get_total_refresh_time RETURN NUMBER;
Protected by from use by an Accessible By clause
 
LOG_MESSAGE (new 21c)
Undocumented dbms_swat_mm_utils.log_message(message IN VARCHAR2);
Protected by from use by an Accessible By clause
 
MOS_PKG_DRIVER (new 21c)
Undocumented dbms_swat_mm_utils.mos_pkg_driver(
ranked_mvs OUT sys.dbms_swat_mm_utils.all_mv_rec_table_type);
Protected by from use by an Accessible By clause
 
NEW_LINE (new 21c)
Undocumented dbms_swat_mm_utils.new_line;
Protected by from use by an Accessible By clause
 
PRINT_PAGE_SEPERATOR (new 21c)
Undocumented dbms_swat_mm_utils.print_page_seperator;
Protected by from use by an Accessible By clause
 
PUT (new 21c)
Undocumented dbms_swat_mm_utils.put(mesg IN VARCHAR2);
Protected by from use by an Accessible By clause
 
PUT_LINE (new 21c)
Undocumented dbms_swat_mm_utils.put_line(mesg IN VARCHAR2);
Protected by from use by an Accessible By clause
 
RECORD_REFRESH_STATUS (new 21c)
Undocumented dbms_swat_mm_utils.record_refresh_status(
in_swat_mm_start_time IN DATE,
in_refresh_id         IN NUMBER,
in_mv_owner           IN VARCHAR2,
in_mv_name            IN VARCHAR2,
in_mv_size            IN NUMBER,
in_refresh_type       IN NUMBER,
in_status             IN NUMBER,
in_error              IN NUMBER);
Protected by from use by an Accessible By clause
 
SET_SWAT_MM_START_TIME (new 21c)
Undocumented dbms_swat_mm_utils.set_swat_mm_start_time(swat_mm_start_time IN DATE);
Protected by from use by an Accessible By clause
 
WRITE_TO_JOURNAL (new 21c)
Undocumented dbms_swat_mm_utils.write_to_journal;
Protected by from use by an Accessible By clause
 
WRITE_TRACE (new 21c)
Undocumented dbms_swat_mm_utils.write_trace;
Protected by from use by an Accessible By clause

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SWAT
DBMS_SWAT_ARM_INTERNAL
DBMS_SWAT_INTERNAL
DBMS_SWAT_MM_UTILS
DBMS_SWAT_VER_INTERNAL
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