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

Re:RE: URGENT: Why are there so many Oracle (LOCAL=NO) proce

From: <dgoulet_at_vicr.com>
Date: Fri, 5 Jan 2001 09:25:27 -0500
Message-Id: <10732.125827@fatcity.com> 





Larry,



    How do you limit these dedicated processes:



    
  
  1.   set up the multi threaded server (MTS) that way they go away all
together.  Although this does work, MTS has it's own drawbacks, like having too
few shared servers which causes a performance problem.

  
  2.   which user, inside the database, is causing the problem?  Check the
username column of V$SESSION to find out.  Does this user have unlimited # of
sessions in their profile?  If so you can change that to something reasonable,
like 50.  Also do they have unlimited idle time, consider changing that to say 5
minutes.

  
  3.   lastly, assuming it's a WEB application with IIS, ASP, and ODBC find the
developer & bring it to his/her attention and add their boss into the
conversation too.  Many times with these types of individuals they 1) don't know
their doing anything out of the ordinary in the first place, and 2) they assume
the database is strictly for their use & they can do what they want.  If they
are given an understanding of the problem most, although not all, are willing to
look into the problem & find a solution.






Been there, done all of that, and now have a happy relationship with the WEB
folks.  BTW: In most circumstances you are the only one who knows what is going
on & handing over OEM & DBA privileges is not a viable option.  Therefore, pay a
visit to www.luminate.com.  Download a copy of MAMBA.  It's FREE, runs on
Windows NT/2000, comes complete and is WEB based & is a READ-ONLY tool.  Perfect
for allowing a WEB developer to see what he/she is doing to the database & even
helping them understand which ASP page is causing the problem.  WARNING: be
prepared to do a lot of hand holding at first & enjoy some real benefits in the
end.



Dick Goulet


____________________Reply Separator____________________


Subject:    RE: URGENT: Why are there so many Oracle (LOCAL=NO) processe
Author: Winnie_Liu_at_infonet.com


Date:       1/4/2001 2:41 PM




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 Fri Jan 05 2001 - 08:25:27 CST












Original text of this message













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