DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_SCHEDULER_CHAINS

Object Details
Object Name: CDB_SCHEDULER_CHAINS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All scheduler chains in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the scheduler chain
CHAIN_NAME VARCHAR2 (30) Yes Name of the scheduler chain
RULE_SET_OWNER VARCHAR2 (128)
Owner of the associated rule set
RULE_SET_NAME VARCHAR2 (128)
Name of the associated rule set
NUMBER_OF_RULES NUMBER

Number of rules in this chain
NUMBER_OF_STEPS NUMBER

Number of defined steps in this chain
ENABLED VARCHAR2 (5)
Whether the chain is enabled
EVALUATION_INTERVAL INTERVAL DAY(3) TO SECOND(0) (11)
Periodic interval at which to reevaluate rules for this chain
USER_RULE_SET VARCHAR2 (5)
Whether the chain uses a user-specified rule set
COMMENTS VARCHAR2 (240)
Comments on the chain
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      CHAIN_NAME
,      RULE_SET_OWNER
,      RULE_SET_NAME
,      NUMBER_OF_RULES
,      NUMBER_OF_STEPS
,      ENABLED
,      EVALUATION_INTERVAL
,      USER_RULE_SET
,      COMMENTS
,      CON_ID
FROM SYS.CDB_SCHEDULER_CHAINS;

Dependencies

[top of page]

SYS.CDB_SCHEDULER_CHAINS does not reference any database object

SYS.CDB_SCHEDULER_CHAINS is referenced by following:

SchemaPUBLIC
SynonymCDB_SCHEDULER_CHAINS