Oracle教程 2023-02-26

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

ALL_SCHEDULER_RSC_CONSTRAINTS视图包含系统中所有资源约束信息，即定义哪些作业可以在某些特定的时间作业调度器调度。它主要用于调度作业，以及约束作业何时执行。

使用此视图可以在某些特定的资源上实施约束，保证作业执行的顺畅。例如，可以限制作业仅可在工作日，或仅在非工作日执行，确保系统正常正常运行，避免频繁崩溃。

ALL_SCHEDULER_RSC_CONSTRAINTS lists all Oracle Scheduler resource constraint members accessible to the current user.

Related Views

DBA_SCHEDULER_RSC_CONSTRAINTS lists all Oracle Scheduler resource constraint members in the database.
USER_SCHEDULER_RSC_CONSTRAINTS lists all Oracle Scheduler resource constraint members owned by the current user.

Column	Datatype	NULL	Description
`OBJECT_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the resource object the member is in
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the resource object the member is in
`RESOURCE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the resource constraint resource member
`RESOURCE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the resource constraint resource member
`UNITS_USED`	`NUMBER`		Number of units used of the resource by this constraint resource member