Oracle | DBMS_SWAT_MM

Oracle DBMS_SWAT_MM_UTILS Version 26ai

General Information j

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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	OBJ$
ACTIVITY_TABLE$	DBMS_METADATA	PLITBLM
DBA_ACTIVITY_CONFIG	DBMS_OUTPUT	SUM$
DBA_ACTIVITY_MVIEW	DBMS_STANDARD	SWAT_ARM_FEEDBACK$
DBA_ACTIVITY_TABLE	DBMS_SUMA_LIB	SWAT_MM_ACT_MVIEWS$
DBA_DEPENDENCIES	DBMS_SWAT	SWAT_MM_ACT_SNAP_META$
DBA_INDEXES	DBMS_SWAT_ARM_INTERNAL	SWAT_MM_DBA_ACT_MVIEW$
DBA_MINING_MODELS	DBMS_SWAT_INTERNAL	SWAT_MM_DBA_ACT_TABLE$
DBA_MVIEWS	DBMS_SWAT_MM_INTERNAL	SWAT_MM_JOURNAL$
DBA_MVIEW_DETAIL_RELATIONS	DBMS_SWAT_VER_INTERNAL	SWAT_MM_REFRESH_HISTORY$
DBA_MVIEW_LOGS	DBMS_SWAT_XML	SWAT_MM_REFRESH_ID_SEQ$
DBA_OBJECTS	DBMS_SYSTEM	SWAT_MM_SID_MAPPING$
DBA_SEGMENTS	DBMS_SYS_ERROR	SWAT_VER_MV_BENEFIT$
DBA_TABLES	DBMS_UTILITY	USER$
DBA_VIEWS	DUAL	UTL_CALL_STACK
DBMS_ASSERT	GV$ACTIVITY_TABLE	WRI$_ADV_ACTIONS

Documented No

First Available 20c

Security Model Owned by SYS with no privileges granted

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/prvsswatmm.plb

Subprograms

CHECK_AUTO_MV_FEATURE_ALLOWED	FMTNUM	GET_REFRESH_ID
CHECK_VOL	GET_ACT_CHANGE_DATA	GET_TOTAL_REFRESH_TIME
CLEANUP_BEFORE_DISABLE	GET_AVAIL_SPACE	LOG_MESSAGE
CLEANUP_DRIVER	GET_AVG_MV_SPACE	MOS_PKG_DRIVER
DO_DDL	GET_CANON_DATE_INFO	NEW_LINE
DROP_FAILING_REFRESH_AUTOMVS	GET_CD	PRINT_PAGE_SEPERATOR
DROP_INVALID_AUTOMVS	GET_CHANGE_DATE	PUT
DROP_mv_AND_UNNEEDED_LOGS	GET_FACT_TABLE_SPACE_USAGE	PUT_LINE
DROP_UNUSED_AUTOMVLOGS	GET_MOS_RUN_PARAMS	RECORD_REFRESH_STATUS
DROP_UNUSED_MVS	GET_MV_SPACE_USAGE	SET_SWAT_MM_START_TIME
DUMP_TRACE	GET_NUM_DAYS	WRITE_TO_JOURNAL
ESTIMATED_REFRESH_TIME	GET_NUM_STALEMVS	WRITE_TRACE
FLUSH_MESSAGE

CHECK_AUTO_MV_FEATURE_ALLOWED (new 23ai)

Undocumented dbms_swat_mm_utils.check_auto_mv_feature_allowed;

TBD

CHECK_VOL

Undocumented dbms_swat_mm_utils.check_vol( obj_num IN NUMBER, vol_flag IN OUT NUMBER, vol_info IN OUT VARCHAR2;

Protected by from use by an Accessible By clause

CLEANUP_BEFORE_DISABLE

Undocumented dbms_swat_mm_utils.cleanup_before_disable;

Protected by from use by an Accessible By clause

CLEANUP_DRIVER

Undocumented dbms_swat_mm_utils.cleanup_driver RETURN BOOLEAN;

Protected by from use by an Accessible By clause

DO_DDL

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

Undocumented dbms_swat_mm_utils.drop_failing_refresh_automvs;

Protected by from use by an Accessible By clause

DROP_INVALID_AUTOMVS

Undocumented dbms_swat_mm_utils.drop_invalid_automvs;

Protected by from use by an Accessible By clause

DROP_MV_AND_UNNEEDED_LOGS

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

Undocumented dbms_swat_mm_utils.drop_unused_automvlogs;

Protected by from use by an Accessible By clause

DROP_UNUSED_MVS

Undocumented dbms_swat_mm_utils.drop_unused_mvs(in_current_date IN DATE);

Protected by from use by an Accessible By clause

DUMP_TRACE

Undocumented dbms_swat_mm_utils.dump_trace( message IN VARCHAR2, time_info IN BOOLEAN);

Protected by from use by an Accessible By clause

ESTIMATE_REFRESH_TIME (new 23ai)

Undocumented dbms_swat_mm_utils.estimate_refresh_time;

Protected by from use by an Accessible By clause

FLUSH_MESSAGE

Undocumented dbms_swat_mm_utils.flush_message(journaltype IN VARCHAR2);

Protected by from use by an Accessible By clause

FMTNUM

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

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_AVAIL_SPACE (new 23ai)

Undocumented dbms_swat_mm_utils.get_avail_space(in_tablespace_name IN VARCHAR2) RETURN NUMBER;

TBD

GET_AVG_MV_SPACE (new 23ai)

Undocumented dbms_swat_mm_utils.get_avg_mv_space(in_tablespace_name IN VARCHAR2) RETURN NUMBER;

TBD

GET_CANON_DATE_INFO

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

Undocumented dbms_swat_mm_utils.get_cd(trace_flag IN CHAR) RETURN DATE;

Protected by from use by an Accessible By clause

GET_CHANGE_DATE (new 23ai)

Undocumented dbms_swat_mm_utils.get_change_date;

Protected by from use by an Accessible By clause

GET_FACT_TABLE_SPACE_USAGE (new 23ai)

Undocumented dbms_swat_mm_utils.get_fact_table_space_usage( in_mv_owner IN VARCHAR2, in_mv_name IN VARCHAR2) RETURN NUMBER;

TBD

GET_MOS_RUN_PARAMS

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_MV_SPACE_USAGE (new 23ai)

Undocumented dbms_swat_mm_utils.get_mv_space_usage( in_mv_owner IN VARCHAR2, in_mv_name IN VARCHAR2) RETURN NUMBER;

TBD

GET_NUM_DAYS

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

Undocumented dbms_swat_mm_utils.get_num_staleMVs RETURN NUMBER;

Protected by from use by an Accessible By clause

GET_REFRESH_ID

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

Undocumented dbms_swat_mm_utils.get_total_refresh_time RETURN NUMBER;

Protected by from use by an Accessible By clause

LOG_MESSAGE

Undocumented dbms_swat_mm_utils.log_message(message IN VARCHAR2);

Protected by from use by an Accessible By clause

MOS_PKG_DRIVER

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

Undocumented dbms_swat_mm_utils.new_line;

Protected by from use by an Accessible By clause

PRINT_PAGE_SEPERATOR

Undocumented dbms_swat_mm_utils.print_page_seperator;

Protected by from use by an Accessible By clause

PUT

Undocumented dbms_swat_mm_utils.put(mesg IN VARCHAR2);

Protected by from use by an Accessible By clause

PUT_LINE

Undocumented dbms_swat_mm_utils.put_line(mesg IN VARCHAR2);

Protected by from use by an Accessible By clause

RECORD_REFRESH_STATUS

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

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

Undocumented dbms_swat_mm_utils.write_to_journal;

Protected by from use by an Accessible By clause

WRITE_TRACE

Undocumented dbms_swat_mm_utils.write_trace;

Protected by from use by an Accessible By clause