Oracle 12c DBMS_AUTO

Oracle DBMS_AUTO_TASK Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,

Purpose

Undocumented support utility for Auto Task administratin

AUTHID

Definer

Data Types

TYPE window_calendar_entry IS RECORD (
window_name dba_scheduler_windows.window_name%TYPE,
start_time TIMESTAMP WITH TIME ZONE,
duration dba_scheduler_windows.duration%TYPE);

TYPE window_calendar_t IS TABLE OF window_calendar_entry;

TYPE winname_t IS RECORD (
window_name dba_scheduler_windows.window_name%TYPE,
start_date TIMESTAMP WITH TIME ZONE,
end_date TIMESTAMP WITH TIME ZONE);

TYPE refcur_winname_t IS REF CURSOR RETURN winname_t;

Dependencies

DBA_AUTOTASK_CLIENT	DBA_AUTOTASK_WINDOW_CLIENTS	DBMS_SCHEDULER
DBA_AUTOTASK_OPERATION	DBA_SCHEDULER_WINDOWS	DBMS_STANDARD
DBA_AUTOTASK_SCHEDULE	DBMS_AUTOTASK_PRVT_LIB	KET$_WINDOW_LIST
DBMS_AUTOTASK_TASK

Documented

Yes

First Available

11.1.0.6

Security Model

Owned by SYS with EXECUTE granted to PUBLIC

Source

$ORACLE_HOME/rdbms/admin/dbmsatsk.sql

Subprograms

CHECK_CLIENT_STATUS_OVERRIDE	GET_CLIENT_STATUS_OVERRIDE	RECONCILE_ATTRIBUTES
DECODE_ATTRIBUTES	GET_SCHEDULE_DATE	WINDOW_CALENDAR

CHECK_CLIENT_STATUS_OVERRIDE

Signal an error if the client is overridden to DISABLED even if it is enabled on disk (e.g. pack disabled, underscore parameter, etc). Called to validate an ENABLE operation.

dbms_auto_task.check_client_status_override(client_id IN PLS_INTEGER);

TBD

DECODE_ATTRIBUTES

Decode attribute flags into a string for display

dbms_auto_task.decode_attributes(attr IN NUMBER DEFAULT 0) RETURN VARCHAR2;

SELECT dbms_auto_task.decode_attributes(28)
FROM dual;

DBMS_AUTO_TASK.DECODE_ATTRIBUTES(28)
--------------------------------------------------
LIGHT, STABLE, VOLATILE

SELECT dbms_auto_task.decode_attributes(99)
FROM dual;

DBMS_AUTO_TASK.DECODE_ATTRIBUTES(99)
--------------------------------------------------
ONCE PER WINDOW, HEAVY, DO NOT KILL, SAFE TO KILL

GET_CLIENT_STATUS_OVERRIDE

Determine if a given client's status should be overridden to DISABLED even if it is ENABLED on disk (e.g. pack disabled, underscore parameter, etc). A return value of 1 means such an override exists, 0 means it does not.

dbms_auto_task.get_client_status_override(client_id IN PLS_INTEGER)
RETURN PLS_INTEGER;

TBD

GET_SCHEDULE_DATE

Compute a list of the task scheduled date provide the start and end dates. Taskname is the defined autotask name (used by EM)

dbms_auto_task.get_schedule_date(
taskname       IN VARCHAR2,
start_date     IN TIMESTAMP WITH TIME ZONE,
end_date       IN TIMESTAMP WITH TIME ZONE,
scheduled_list OUT ket$_window_list);

desc ket$_window_list

RECONCILE_ATTRIBUTES

Combines supplied attribute flag sets into a single set of attribute flags. Arguments listed in order of descending priority. I.e. ask_rep_attr settings, if any, override all of the other settings.

dbms_auto_task.reconcile_attributes(
cli_comp_attr IN NUMBER DEFAULT 0, -- client compile-time attributes
cli_rep_attr   IN NUMBER DEFAULT 0, -- client repository attributes
op_comp_attr   IN NUMBER DEFAULT 0, -- operation compile-time attr.
op_rep_attr    IN NUMBER DEFAULT 0, -- operation repository attr.
task_comp_attr IN NUMBER DEFAULT 0, -- task client-defined attr.
task_rep_attr IN NUMBER DEFAULT 0) -- task repository override attr.
RETURN NUMBER;

TBD

WINDOW_CALENDAR

Undocumented

dbms_auto_task.window_calendar(w IN refcur_winname_t)
RETURN window_calendar_t PIPELINED;

TBD