ALL_SCHEDULER_GROUPS displays information about the Scheduler object groups accessible to the current user.
DBA_SCHEDULER_GROUPS displays information about all Scheduler object groups in the database.
USER_SCHEDULER_GROUPS displays information about the Scheduler object groups owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the group |
GROUP_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the group |
GROUP_TYPE |
VARCHAR2(13) |
Type of object contained in the group:
|
|
ENABLED |
VARCHAR2(5) |
Indicates whether the group is enabled (TRUE) or disabled (FALSE) |
|
NUMBER_OF_MEMBERS |
NUMBER |
Number of members in this group | |
COMMENTS |
VARCHAR2(240) |
An optional comment about this group |