Oracle教程 2023-02-23

Oracle 视图 ALL_SCHEDULER_FILE_WATCHERS 官方解释，作用，如何使用详细说明

ALL_SCHEDULER_FILE_WATCHERS 视图用于查看Oracle数据库中当前用户或其他用户创建的文件观察器的详细信息。

使用ALL_SCHEDULER_FILE_WATCHERS视图可以查 brief_info，schedule_name，schedule_owner，job_name，job_owner，watcher_name，watch_type，directory_path，enabled 等信息。

可以使用以下语法从 ALL_SCHEDULER_FILE_WATCHERS 视图检索数据：

SELECT * FROM all_scheduler_file_watchers where watcher_name = ‘文件观察器名’ ;

此查询将返回文件观察器所执行任务的详细信息，包括调度程序名称、调度程序所有者名称、作业名称、作业所有者名称、文件观察器名称、监视类型（文件与目录）、目录路径以及是否启用等信息。

ALL_SCHEDULER_FILE_WATCHERS displays information about the Scheduler file watch requests accessible to the current user.

Related Views

DBA_SCHEDULER_FILE_WATCHERS displays information about all Scheduler file watch requests in the database.
USER_SCHEDULER_FILE_WATCHERS displays information about the Scheduler file watch requests owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the file watch request
`FILE_WATCHER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the file watch request
`ENABLED`	`VARCHAR2(5)`		Indicates whether this file watch request is enabled (`TRUE`) or disabled (`FALSE`)
`DESTINATION_OWNER`	`VARCHAR2(261)`		Owner of the named destination object
`DESTINATION`	`VARCHAR2(261)`		Name of the destination object
`DIRECTORY_PATH`	`VARCHAR2(4000)`	`NOT NULL`	Name of the directory path where the file will arrive
`FILE_NAME`	`VARCHAR2(512)`	`NOT NULL`	Name or pattern specifying the files that need to be monitored
`CREDENTIAL_OWNER`	`VARCHAR2(128)`		Owner of the credential that should be used to authorize the file watch
`CREDENTIAL_NAME`	`VARCHAR2(128)`		Name of the credential that should be used to authorize the file watch
`MIN_FILE_SIZE`	`NUMBER`	`NOT NULL`	Minimum size of the file being monitored
`STEADY_STATE_DURATION`	`INTERVAL DAY(3) TO SECOND(0)`		Time to wait before concluding that the file has stopped growing
`LAST_MODIFIED_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		Time at which this file watcher was last modified
`COMMENTS`	`VARCHAR2(4000)`		Comments on the file watch request