ALL_SCHEDULER_RESOURCES

ALL_SCHEDULER_RESOURCES displays all scheduler resource objects in the database that are accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the resource object
RESOURCE_NAME VARCHAR2(128) NOT NULL Name of the resource object
STATUS VARCHAR2(19)   Resource status for resource object.
RESOURCE_UNITS NUMBER   Maximum number of available units for the resource object
UNITS_USED NUMBER   Current number of resource units in use for the resource object
JOBS_RUNNING_COUNT NUMBER   Current number of running jobs using the resource object
COMMENTS VARCHAR2(256)   Comments for the resource object

See Also: