AnsweredAssumed Answered

DB_CONNECTIONS and SCHED_SCALE

Question asked by wghan on Nov 15, 2017
Latest reply on Nov 16, 2017 by zgofa01

Hi all.

Actually we have around 140 autosys agent. (11.3.6).

  . Autosys AGENT : 140

                    JOBS : 6,500

                    Running jobs per day : 720,000

  . DB:  ORACLE 11G RAC

            PROCESSES :1,500

            SESSIONS : 2,300

The autosys manager parameters were seted as below.

. DB_CONNECTIONS : 128 (max)

. SCHED_SCALE : 42

 

My questions are below.

1. What are the appropriate values of DB_CONNECTIONS and SCHED_SCALE of our environment?

2. What does the DB_CONNECTIONS value related to?

    number of concurrent running jobs or number of agents? 

3. If the SCHED_SCALE is set to over  limit (for example 200), What would be the problem?

 

Thanks in advanced.

Outcomes