Oracle 18cR3 DBMS

Oracle DBMS_ISCHEDFW 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 utilities supporting the File Watch functionality of DBMS_SCHEDULER.

AUTHID DEFINER

Dependencies

AQ$_AGENT	DBMS_UTILITY	SCHEDULER_FILEWATCHER_REQUEST
DBMS_AQ	PLITBLM	SCHEDULER_FILEWATCHER_REQ_LIST
DBMS_DEBUG_JDWP	SCHEDULER$_FILEWATCHER_RESEND	SCHEDULER_FILEWATCHER_RESULT
DBMS_ISCHED	SCHEDULER_FILEWATCHER_HISTORY	SCHEDULER_FILEWATCHER_RES_LIST
DBMS_SYSTEM	SCHEDULER_FILEWATCHER_HST_LIST	UTL_IDENT
DBMS_TRANSACTION

Documented No

First Available 18.1.0.0

Security Model Owned by SYS with no privileges granted

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

Subprograms

FILE_WATCH_JOB

WATCH_FOR_FILES

FILE_WATCH_JOB (new 18.1)

Undocumented dbms_ischedfw.file_watch_job;

exec dbms_ischedfw.file_watch_job;

WATCH_FOR_FILES (new 18.1)

Undocumented dbms_isched_fw.watch_for_files( req_list IN scheduler_filewatcher_req_list, req_hist IN OUT scheduler_filewatcher_hst_list, ohome IN VARCHAR2, hostname IN VARCHAR2, RETURN scheduler_filewatcher_res_list,

TBD