Oracle DBMS_SWAT_MM_UTILS
Version 21c

General Information j
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
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

Direct access to some objects in this package is prevented by means of an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/prvsswatmm.plb
Subprograms
CHECK_VOL FLUSH_MESSAGE LOG_MESSAGE
CLEANUP_BEFORE_DISABLE FMTNUM MOS_PKG_DRIVER
CLEANUP_DRIVER GET_ACT_CHANGE_DATA NEW_LINE
DO_DDL GET_CANON_date_INFO PRINT_PAGE_SEPERATOR
DROP_FAILING_REFRESH_AUTOMVS GET_CD PUT
DROP_INVALID_AUTOMVS GET_MOS_RUN_PARAMS PUT_LINE
DROP_mv_AND_UNNEEDED_LOGS GET_NUM_DAYS RECORD_REFRESH_STATUS
DROP_UNUSED_AUTOMVLOGS GET_NUM_STALEMVS SET_SWAT_MM_START_TIME
DROP_UNUSED_MVS GET_REFRESH_ID WRITE_TO_JOURNAL
DUMP_TRACE GET_TOTAL_REFRESH_TIME WRITE_TRACE
 
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 21c
What's New In 23c

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