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: URGENT: Why are there so many Oracle (LOCAL=NO) processes?

RE: URGENT: Why are there so many Oracle (LOCAL=NO) processes?

From: Holman, Rodney <rodney.holman_at_lodgenet.com>
Date: Thu, 4 Jan 2001 17:40:09 -0600
Message-Id: <10731.125796@fatcity.com> 





Actually if you set the init parameter license_max_sessions=xx where xx is a
number  (I believe that's the one).  It stops any connections beyond the
number you give this parameter.   Think hard before setting this though,
because it will stop any connections beyond the number given (including cron
processes).  You could possibly crash (or at least stall) a critical process
if too may users are on line.



Rodd Holman



 -----Original Message-----

From: 	Winnie_Liu_at_infonet.com [mailto:Winnie_Liu_at_infonet.com] 
Sent:	Thursday, January 04, 2001 4:41 PM
To:	Multiple recipients of list ORACLE-L
Subject:	RE: URGENT: Why are there so many Oracle (LOCAL=NO)


processes?




these are delicated process. So the maximum amount you can have subject to
the PROCESSES parameter you set in the init.ora file. A larger number of
PROCESSES will definitely buy you more time.



But I don't think there is any way you can limit the number of these
connections.



Winnie







Larry Taylor <ltaylor_at_iq.com>@fatcity.com on 01/04/2001 02:11:14 PM



Please respond to ORACLE-L_at_fatcity.com



Sent by:  root_at_fatcity.com




To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:





Winnie, is there any way to limit the number of these connections?



Thanks,


larry



-----Original Message-----



Sent: Thursday, January 04, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L






Those are the processes for people who logon to your database through
sqlnet. For example, when you use your PC sqlplus to logon to your
database, there will be such a section in your server.



Winnie







Larry Taylor <ltaylor_at_iq.com>@fatcity.com on 01/04/2001 11:27:06 AM



Please respond to ORACLE-L_at_fatcity.com



Sent by:  root_at_fatcity.com




To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:





Does anyone know why so many of these Oracle processes named (LOCAL=NO)
have suddenly shown up? So many in fact, I can't bring up SVRMGR
until I kill them, but they keep coming back!



  oracle  9739     1  0 10:09:24 ?        0:00 oracleshark (LOCAL=NO)
  oracle  9687     1  0 09:59:15 ?        0:08 oracleshark (LOCAL=NO)
  oracle  9691     1  0 09:59:16 ?        1:09 oracleshark (LOCAL=NO)
  oracle  9695     1  0 09:59:19 ?        0:00 oracleshark (LOCAL=NO)
  oracle  9699     1  0 09:59:19 ?        0:02 oracleshark (LOCAL=NO)
  oracle  9703     1  0 09:59:25 ?        0:06 oracleshark (LOCAL=NO)
  oracle  9709     1  0 09:59:49 ?        0:10 oracleshark (LOCAL=NO)
  oracle  9667     1  0 09:49:58 ?        0:00 ora_d009_shark
  oracle  9713     1  0 10:00:09 ?        0:11 oracleshark (LOCAL=NO)
  oracle  9685     1  0 09:59:15 ?        0:13 oracleshark (LOCAL=NO)
  oracle  9721     1  0 10:00:45 ?        0:00 oracleshark (LOCAL=NO)
  oracle  9683     1  0 09:59:15 ?        0:00 /orabin/8.1.6/bin/tnslsnr
LISTENER -inherit
  oracle  9727     1  0 10:01:33 ?        0:01 oracleshark (LOCAL=NO)
  oracle  9689     1  1 09:59:16 ?        0:33 oracleshark (LOCAL=NO)
  oracle  9733     1  0 10:05:55 ?        0:02 oracleshark (LOCAL=NO)
  oracle  9693     1  1 09:59:16 ?        0:13 oracleshark (LOCAL=NO)
  oracle  9788     1  0 10:36:22 ?        0:00 oracleshark (LOCAL=NO)
  oracle  9697     1  0 09:59:19 ?        0:05 oracleshark (LOCAL=NO)
  oracle  9792     1  0 10:42:54 ?        0:00 oracleshark (LOCAL=NO)
  oracle  9701     1  0 09:59:23 ?        0:12 oracleshark (LOCAL=NO)
  oracle  9768     1  0 10:21:05 ?        0:05 oracleshark (LOCAL=NO)
  oracle  9706     1  0 09:59:35 ?        0:01 oracleshark (LOCAL=NO)
  oracle  9801     1  0 10:50:08 ?        0:00 oracleshark (LOCAL=NO)
  oracle  9797     1  0 10:44:11 ?        0:00 oracleshark (LOCAL=NO)
  oracle  9820     1  0 10:55:00 ?        0:00 oracleshark (LOCAL=NO)
  oracle  9715     1  0 10:00:14 ?        0:11 oracleshark (LOCAL=NO)
  oracle  9811     1  0 10:51:14 ?        0:00 oracleshark (LOCAL=NO)
  oracle  9723     1  0 10:00:45 ?        0:05 oracleshark (LOCAL=NO)
  oracle  9823     1  0 10:56:06 ?        0:03 oracleshark (LOCAL=NO)
  oracle  9729     1  0 10:03:45 ?        0:00 oracleshark (LOCAL=NO)
  oracle  9829     1  0 10:57:27 ?        0:00 oracleshark (LOCAL=NO)





Thanks in Advance


larry


--



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


--



Author: Larry Taylor


  INET: ltaylor_at_iq.com


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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).





--



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


--



Author:


  INET: Winnie_Liu_at_infonet.com


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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).


--



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


--



Author: Larry Taylor


  INET: ltaylor_at_iq.com


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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).





-- 



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


-- 



Author: 


  INET: Winnie_Liu_at_infonet.com


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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
Received on Thu Jan 04 2001 - 17:40:09 CST












Original text of this message













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