Oracle | DBMS_SWAT_VER

Oracle DBMS_SWAT_VER_INTERNAL Version 21c

General Information

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 Internal support for utilities that manage automatically created, think autonomous self-tuning, materialized views.

AUTHID DEFINER

Dependencies

ALL_USERSNS	DBMS_AUTOTASK_PRVT	DBMS_STANDARD
DBA_ADVISOR_EXECUTIO	DBMS_AUTO_TASK_ADMIN	DBMS_SUMA_LIB
DBA_ADVISOR_TASKS	DBMS_LOB	DBMS_SWAT
DBA_AUTO_MV_ANALYSIS_EXECUTIONS	DBMS_LOCK	DBMS_SYSTEM
DBA_DEPENDENCIES	DBMS_OUTPUT	DBMS_UTILITY
DBA_MVIEW_LOGS	DBMS_RANDOM	OBJ$
DBA_SQLSET	DBMS_SQLPA	PLITBLM
DBA_TABLES	DBMS_SQLTUNE	PRVT_ADVISOR
DBMS_ASSERT	DBMS_SQLTUNE_UTIL0	SNAP$
SWAT$CONFIG_PARAMS	SWAT_VER_MV_BENEFIT$	WRI$_ADV_SQLA_MAP
SWAT_ARM_FEEDBACK$	SWAT_VER_STATE$	WRI$_ADV_SQLA_STMTS
SWAT_ARM_STATUS$	USER$	WRI$_ADV_TASKS
SWAT_VER$	UTL_CALL_STACK	X$KSPPCV
SWAT_VER_JOURNAL$	WRI$_ADV_ACTIONS	X$KSPPI

Documented No

First Available 21c

Security Model Owned by SYS with EXECUTE granted to the

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

Subprograms

CLEANUP_ALL_EXECUTIONS	SVER_AUTO_TASK_SWITCH	VERIFY_SARM_TASK
RECORD_FAILURE

CLEANUP_ALL_EXECUTIONS (new 21c)

Undocumented dbms_swat_ver_internal.cleanup_all_executions;

exec dbms_swat_ver_internal.cleanup_all_executions;

      

      PL/SQL procedure successfully completed.

RECORD_FAILURE (new 21c)

Undocumented dbms_swat_ver_internal.record_failure( mvowner IN VARCHAR2, mvname IN VARCHAR2, feedbackid IN NUMBER, mvimpltime IN DATE, mvddltxt IN CLOB, errnum IN NUMBER, errmsg IN VARCHAR2);

TBD

SVER_AUTO_TASK_SWITCH (new 21c)

Undocumented dbms_swat_ver_internal.sver_auto_task_switch(enable IN BOOLEAN);

exec dbms_swat_ver_internal.sver_auto_task_switch(FALSE);

      

      PL/SQL procedure successfully completed.

VERIFY_SARM_TASK (new 21c)

Undocumented dbms_swat_ver_internal.verify_sarm_task( taskid IN NUMBER execname IN VARCHAR2 stsname IN VARCHAR2 stsowner IN VARCHAR2

TBD