Oracle教程 2023-04-04

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

Oracle视图ALL_SCHEDULER_INCOMPATS用于检查和报告任务、程序及组的冲突。在每次作业调度程序实例启动时，此视图将冲突列为显示器中的行，其中指示存在冲突的任务、程序和组，以及冲突分类。

运行该视图可以帮助检查Schema内有冲突的任务、程序和组。可以使用以下语句来检查任何冲突：

SELECT OWNER,OBJECT_NAME,OBJECT_TYPE,INCOMPAT_OWNER,INCOMPAT_OBJECT_NAME,INCOMPAT_OBJECT_TYPE,TYPE FROM ALL_SCHEDULER_INCOMPATS;

如果没有取得冲突，则不会列出任何行。如果列出任何行，则应检查表中的冲突类别，然后可以采取适当的措施解决冲突。有关可能的冲突类型的详细信息，请参阅Oracle文档。

ALL_SCHEDULER_INCOMPATS displays all Scheduler incompatibility resource objects accessible to the current user.

Related Views

DBA_SCHEDULER_INCOMPATS displays all Scheduler incompatibility resource objects in the database.
USER_SCHEDULER_INCOMPATS displays all Scheduler incompatibility resource objects 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 incompatibility resource object
`INCOMPATIBILITY_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the incompatibility resource object
`CONSTRAINT_LEVEL`	`VARCHAR2(13)`		`JOB_LEVEL` or `PROGRAM_LEVEL` The default value `JOB_LEVEL` indicates that only a single job that is based on the program (or programs) mentioned in the `object_name` argument of the `DBMS_SCHEDULER.CREATE_INCOMPATIBILITY` procedure can run at one time. The value `PROGRAM_LEVEL` indicates that the programs are incompatible, but the jobs based on the same program are not incompatible.
`ENABLED`	`VARCHAR2(5)`		Indicates whether the incompatibility is enabled (`TRUE`) or not (`FALSE`)
`JOBS_RUNNING_COUNT`	`NUMBER`		Current number of running jobs using the incompatibility resource object
`COMMENTS`	`VARCHAR2(256)`		Comments for the resource incompatibility object