Re: Newbie:How to estimate PROCESS

From: Steve Adams <steve.adams_at_acslink.net.au>
Date: 1997/07/27
Message-ID: <33db9a52.6209271@nntp.peg.apc.org>#1/1

Hi all,

I don't see what cursor_space_for_time has got to do with it, but for what it is worth one can get a highwater mark from x$ksupr that should give you a feel for how many processes you have been using.

select
  'processes' parameter,
  count(*) setting,
  count(decode(ksuprflg, 0, null, 0)) hwm,   to_char(
    100 * count(decode(ksuprflg, 0, null, 0)) / count(*),     '99999'
  ) || '%' usage
from
  sys.x$ksupr
/

HTH, Steve Adams
Oracle Internals Expert

On 26 Jul 1997 18:19:28 GMT, "Sheilah Scheurich" <scheuric_at_sprynet.com> wrote:

>The number of process is dependent on the size of your application,
>particularly: Are you suing multiple database writers, are you using
>cursor space for time and how many users are accessing your system. This
>will determine what that number should be.
>
>-Sheilah Scheurich
>DBA
>
>
>Pui Ming WONG <s11976_at_net2.hkbu.edu.hk> wrote in article
><5qp2kl$bfc$1_at_power42t.hkbu.edu.hk>...
>> I'm a newbie DBA (we run oracle 7.6.1 under Digital Unix 3.2)
>> I would like to know some guidelines on setting the PROCESS
>> parameter in our init.ora
>> Usually how many is enough ?
>

My real email address is: steveadams_at_acslink.net.au Received on Sun Jul 27 1997 - 00:00:00 CDT