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