Oracle | DBMS_SWAT_VER

Oracle DBMS_SWAT_VER_INTERNAL Version 21c

General Information

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