| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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;
PL/SQL procedure successfully completed. |
| |
| ABORT_AUTOTASK |
| Aborts an executing autotask |
dbms_autotask_prvt.abort_autotask(task_id IN BINARY_INTEGER); |
exec dbms_autotask_prvt.abort_autotask(3);
PL/SQL procedure successfully completed. |
| |
| AGE |
| Undocumented |
dbms_autotask_prvt.age; |
exec dbms_autotask_prvt.age;
PL/SQL procedure successfully completed. |
| |
CLEANUP_ATSK_INMEM_DATA (new 23ai)  |
| Undocumented |
dbms_autotask_prvt.cleanup_atsk_inmem_data(con_id IN NUMBER); |
exec dbms_autotask_prvt.cleanup_atsk_inmem_data(3);
PL/SQL procedure successfully completed. |
| |
| DISABLE_MMON_RESTRICTED_MODE (new 23ai) |
| Undocumented |
dbms_autotask_prvt.disable_mmon_restricted_mode; |
exec dbms_autotask_prvt.disable_mmon_restricted_mode;
PL/SQL procedure successfully completed. |
| |
| ENABLE_MMON_RESTRICTED_MODE (new 23ai) |
| Undocumented |
dbms_autotask_prvt.enable_mmon_restricted_mode; |
exec dbms_autotask_prvt.enable_mmon_restricted_mode;
PL/SQL procedure successfully completed. |
| |
| 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 |
| Undocumented |
dbms_autotask_prvt.request_grace_period RETURN NUMBER; |
SELECT dbms_autotask_prvt.request_grace_period;
REQUEST_GRACE_PERIOD
--------------------
1 |
| |
| RESTORE_DISPATCHER_OPTIMIZATION (new 23ai) |
| Undocumented |
dbms_autotask_prvt.restore_dispatcher_optimization(task_name IN VARCHAR2); |
| TBD |
| |
| RUN_AUTOTASK (new 23ai parameter) |
| Start autotask execution |
dbms_autotask_prvt.run_autotask(
task_id IN BINARY_INTEGER,
magic_num IN NUMBER); |
exec dbms_autotask_prvt.run_autotask(3, 3.14);
PL/SQL procedure successfully completed. |
| |
| SETUP |
| Undocumented |
dbms_autotask_prvt.setup(window_group_sync_level IN BINARY_INTEGER); |
exec dbms_autotask_prvt.setup(99999);
PL/SQL procedure successfully completed. |
| |
| SKIP_DISPATCHER_OPTIMIZATION (new 23ai) |
| Undocumented |
dbms_autotask_prvt.skip_dispatcher_optimization(task_name IN VARCHAR2); |
| TBD |