Oracle 18cR3 DBMS_AUTOTASK

Oracle DBMS_AUTOTASK_PRVT Version 18.3.0.1

General Information

Library Note

Morgan's Library Page Header

For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.

Purpose Internal support for Auto Task jobs

AUTHID DEFINER

Dependencies

DBMS_AUTOTASK_PRVT_LIB	DBMS_STANDARD	KET$_CLIENT_TASKS
DBMS_AUTO_TASK_IMMEDIATE

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtatsk.plb

Subprograms

ABA	GET_TASKS	SETUP
AGE

ABA

Undocumented dbms_autotask_prvt.aba;

exec dbms_autotask_prvt.aba;

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;

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