*schedulerchains shows all chains - Oracle DBA

Q.  Which view shows all chains?
- Published on 12 Aug 15

a. *_scheduler_chains
b. *_scheduler_chain_rules
c. *_scheduler_chain_steps
d. None of the above

ANSWER: *_scheduler_chains
 

    Discussion

  • Nirja Shah   -Posted on 21 Aug 15
    -The commands *_scheduler_chains, *_scheduler_chain_rules, *_scheduler_chain_steps etc are used to monitor the job chains .
    *_scheduler_chains - these views shows all the chains

    *_scheduler_chain_rules - These views show all rules for all chains.

    *_scheduler_chain_steps - These views show all steps for all chains.
    - There are many other views which are used to monitor the job chains

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)