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 Auto Task jobs
AUTHID
DEFINER
Data Types
TASKLISTTYPE
Dependencies
DBMS_AUTOTASK_PRVT_LIB
DBMS_SWAT_ARM_INTERNAL
DBMS_SWAT_VER_INTERNAL
DBMS_AUTO_TASK_IMMEDIATE
DBMS_SWAT_MM_INTERNAL
KET$_CLIENT_TASKS
DBMS_STANDARD
Documented
No
First Available
Not known
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/prvtatsk.plb
Subprograms
ABA
Undocumented
dbms_autotask_prvt.aba;
exec dbms_autotask_prvt.aba ;
ABORT_AUTOTASK
Aborts an executing autotask
dbms_autotask_prvt.abort_autotask(task_id IN BINARY_INTEGER);
exec dbms_autotask_prvt.abort_autotask (163);
AGE
Undocumented
dbms_autotask_prvt.age;
exec dbms_autotask_prvt.age ;
GET_TASKS
Undocumented
dbms_autotask_prvt.get_tasks(client_id IN BINARY_INTEGER)
RETURN sys.dbms_autotask_prvt.tasklisttype
TBD;
REFRESH_CLIENT_CONFIG
Refresh client autotask configuration
dbms_autotask_prvt.refresh_client_config;
exec dbms_autotask_prvt.refresh_client_config ;
PL/SQL procedure successfully completed.
REQUEST_GRACE_PERIOD (new 21c)
Undocumented
dbms_autotask_prvt.request_grace_period RETURN NUMBER;
SELECT dbms_autotask_prvt.request_grace_period
FROM dual;
REQUEST_GRACE_PERIOD
--------------------
1
RUN_AUTOTASK
Start autotask execution
dbms_autotask_prvt.run_autotask(task_id IN BINARY_INTEGER);
exec dbms_autotask_prvt.run_autotask (163);
SETUP
Undocumented
dbms_autotask_prvt.setup(window_group_sync_level IN BINARY_INTEGER);
exec dbms_autotask_prvt.setup (0);
exec dbms_autotask_prvt.setup (3);