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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Set processes at init.ora

Re: Set processes at init.ora

From: Mitchell <mitchell.lee_at_rogers.com>
Date: Mon, 27 Oct 2003 15:09:25 -0800
Message-ID: <F001.005D4B55.20031027150925@fatcity.com>

 

Thanks Pd for your answered. The Os is window 2000 and Oracle 8.1.6.0.0. I run the query v$resource_limit after I reset processes No to 250. and saw the No. is up and stable to 110 process. I will keep monitor it and make sure all session disconnected.  

I wonder if processes is set to higher, any impact to memory or resource usage?    

Mitchell    

Mitchell,  

It would be most helpful if you supplied the Oracle Server version info.  

You may have simply had legitimately 190 users connected. You may have a problem with sessions being disconnected by the client that are not being terminated properly. It is a known issue that support for dead connection detection on win32 is non-existent, hence improperly terminated sessions can hang around for quite awhile.  

You do not have to explicitly set any OS parameters in hiking up the number of processes in the init.ora. Depending upon your oracle server version (which again, is unknown here) you might want to change either the number of rollback segments or the number of transactions/segment.  

hth.  

Pd

Mitchell <mitchell.lee_at_rogers.com> wrote:

DBAs

Our database running on NT 2000 is over 200 processes today and I had to reset to a hight No. As I know, if I set highter for this parameter, the will be impact on Unix system, I wonder there is any impact on windows.

thanks in advance
Mitchell
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mitchell
INET: mitchell.lee_at_rogers.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services



To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).

Do you Yahoo!?
Exclusive Video Premiere - Britney
<http://launch.yahoo.com/video/?1093432&fs=1&redirectURL=http://launch.y ahoo.com/promos/britneyspears/> Spears

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mitchell
  INET: mitchell.lee_at_rogers.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Oct 27 2003 - 17:09:25 CST

Original text of this message

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