Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: "processes" initialization parameter

Re: "processes" initialization parameter

From: Kevin S. Smith <SpamNoMore_at_EriePlating.com>
Date: Wed, 27 Mar 2002 10:12:56 -0500
Message-ID: <ua3oc6jjd2r10f@corp.supernews.com>


Thank you for your response....will bounce instance. I now know how to querey to see if a parameter is dynamic or static.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:ua1tabchcn9o5a_at_corp.supernews.com...
>
> "Kevin S. Smith" <SpamNoMore_at_EriePlating.com> wrote in message
> news:ua1no28268krba_at_corp.supernews.com...
> > I am installing Enterprise Manager for Oracle 8i. When creating the
> > management server, I am getting an error stating that it won't be
> supported
> > becuase my "processes" init param is set to 150 and the minimum is 200.
> (if
> > you could explain why it needs to be that high, that would be great
too.)
> > Anyway, I change the init param, but don't want to wait until the time
is
> > right (which is no time soon) to bounce the database. Is there a way to
> > change this dynamically. Any suggestions would be great.
> >
> >
>
> The processes parameter is a static parameter, which can be verified from
> the is_sysmodifiable and is_sesmodifiable columns in the v$parameter view
> (where name = 'processes')
>
> No other solution than to bounce the instance, I am afraid.
>
> Regards
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
Received on Wed Mar 27 2002 - 09:12:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US