Re: best practice maximum number of OS processes
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Wed, 12 Jun 2013 16:08:20 -0700 (PDT)
Message-ID: <1371078500.32984.YahooMailClassic_at_web181203.mail.ne1.yahoo.com>
You need to think about ( or model ) how many of your processes are going to be on the run queue ( actively getting or trying to get/use CPU ) simultaneously.
Date: Wed, 12 Jun 2013 16:08:20 -0700 (PDT)
Message-ID: <1371078500.32984.YahooMailClassic_at_web181203.mail.ne1.yahoo.com>
You need to think about ( or model ) how many of your processes are going to be on the run queue ( actively getting or trying to get/use CPU ) simultaneously.
It all depends ... many OLTP environments can work just peachy with "thousands" of database connections ( Tom Kyte does not like this many connections but that's ok works for many of us ) on a small number of cores because even though connected they are not actively all doing database work simultaneously.
Obviously a 32 core machine will not do well if there are 256 processes ALWAYS trying to run/use CPU.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 13 2013 - 01:08:20 CEST