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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SWAT
DBMS_SWAT_ARM_INTERNAL
DBMS_SWAT_MM_INTERNAL
DBMS_SWAT_MM_UTILS
DBMS_SWAT_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
  DBSecWorx