Oracle DBMS_SWAT_MM_UTILS

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

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_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