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

From: <Winnie_Liu_at_infonet.com>
Date: Thu, 4 Jan 2001 14:37:25 -0800
Message-Id: <10731.125790@fatcity.com>

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:

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

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 Received on Thu Jan 04 2001 - 16:37:25 CST