Yep. Forgot to mention that. But there is a catch. Sometimes the Connection pooling logic doesn't make call to the same SID,Serial# combination. Hence you might find quite a no.of SNIPEd sessions remaining in v$session. Just keep an eye on it along with avbl shared_pool at runtime. When you reach the threshold you may be forced to bounce the tomcat server. This is in 9.2.0.1; AFAIK, 8i (8.1.6.3 doesn't release SNIPEd sessions).
HTH GovindanK > If the problem is with idle sessions remaining open, then you can use > profile IDLE_TIME to kill them. > > Tanel. > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Saturday, August 30, 2003 3:14 PM > > >> Nuala, >> >> I have been on this damn Java Client connections for quite a while. >> >> If it is development , you can use PROFILES/SESSIONS_PER_USER and >> prevent >> init.ora setting from being reached and hog the system. >> >> The unfortunate thing is the connection pool is that the code is not > proven >> in most of the cases. We have a mechanism by which every connection gets >> its SID (courtesy v$mystat) and keeps track of the connections created >> initially. The pool is allotted in a round robin fashion based on which >> of the pool is free. Besides the settings are Initial = x, next = y for >> the connection pooling. The default setting is Minimum = Initial. >> Besides >> there is a timeout after which the 'extra' sessions are timed out and >> closed. Hence after running for a while you shall find only the min.no >> of connections against the user. It does not stop here. The connection >> (since not closed or since it is reused) continues to grab memory and if >> the Tomcat is not shutdown periodically (based on your SGA setting and >> no.of.trns etc) you are likely to run into ORA-04030. Add to this , the >> compatibility of the jdbc driver. We are on 9iRel2 (9.2.0.1). >> I understand that there are some memory related fixes avbl. but my >> first area of investigation would be the connection pool + jdbc driver. >> >> Also, i suggest you program your conn.pool mechanism to close after >> every n trips to the database. Get a new connection. This way you are >> not likely to run into the problem. >> >> As of now , i am able to recollect only this much. >> May be someone else in the list has a better idea. >> >> IMHO, SQLNET_TIMEOUT does not work for inactive connections. It is for >> DCDs (Dead Client Detection). >> >> >> HTH >> >> GovindanK >> >> >> >> > Nuala >> > I think many of us are struggling to understand the new >> > Web/Internet/Java >> > world. Many times the Java program is hosted by an application server. >> I >> > don't think that is essential though. There are many different > application >> > servers, so you might ask around. Popular ones are Oracle9i AS, > Weblogic, >> > Tomcat. Most application servers perform a connection pooling >> function. > If >> > the connection pooling is set incorrectly, that can cause problems in >> > Oracle >> > like running out of processes. >> > If you don't have an application server, in Oracle you can >> configure >> > MTS >> > to handle huge numbers of connections. Essentially this is Oracle's >> way > of >> > performing connection pooling. >> > Another feature is Oracle Connection Manager's connection > concentration >> > feature, but I'm not sure if that will work, depending on whether your >> > application is using the Oracle Thin Client or thick client. And that > may >> > be >> > something you should learn about this application. >> > Another aspect of your issue might be setting a time limit in >> sqlnet >> > for >> > inactive sessions. I think the parameter is SQLNET_TIMEOUT, but I have > not >> > used this myself. >> > >> > -----Original Message----- >> > Sent: Friday, August 29, 2003 11:20 AM >> > To: Multiple recipients of list ORACLE-L >> > >> > >> > Hi Dennis, >> > >> > I'm not too sure what you are asking so I will give you a brief >> overview >> > of >> > the set up; >> > >> > The oracle server (version 8.1.7.4) (running on windows2000) >> > The java process is running on this server. >> > Users connect to the java process via Radio Data Terminals.(RDT's) >> > The java process then handles all the calls made by the RDT's. >> > >> > So the answer to your question I think is that the java process >> connect >> > directly to the server. >> > >> > Later, >> > >> > N. >> > >> > :->-----Original Message----- >> > :->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> > :->Behalf Of >> > :->DENNIS WILLIAMS >> > :->Sent: 29 August 2003 16:49 >> > :->To: Multiple recipients of list ORACLE-L >> > :->Subject: RE: Inactive Sessions/Java >> > :-> >> > :-> >> > :->Naula >> > :-> Are these Java processes being hosted by an application >> > :->server or do they >> > :->just connect directly to your Oracle database? >> > :-> >> > :->Dennis Williams >> > :->DBA, 80%OCP, 100% DBA >> > :->Lifetouch, Inc. >> > :->[EMAIL PROTECTED] >> > :-> >> > :-> >> > :->-----Original Message----- >> > :->Sent: Friday, August 29, 2003 4:49 AM >> > :->To: Multiple recipients of list ORACLE-L >> > :-> >> > :-> >> > :-> >> > :->Hi Tanel, >> > :-> >> > :->Thanks for the reply. >> > :-> >> > :->The "Java process" is an application that allows the users >> > :->to connect via >> > :->Radio Data Terminals to the Database. >> > :->The only thing is the number of processes is increasing the >> > :->whole time and >> > :->when it's reaches the limit sent in the init.ora no more >> > :->connections are >> > :->allowed which causes some problems!! >> > :-> >> > :->Bar setting the number of processes in the init.ora to some >> > :->huge number >> > :->and/or stop and restarting the java process is there any other way >> of >> > :->stopping this from happing? >> > :-> >> > :->Thanks, >> > :-> >> > :->N. >> > :-> >> > :->:->-----Original Message----- >> > :->:->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> > :->:->Behalf Of >> > :->:->Tanel Poder >> > :->:->Sent: 28 August 2003 20:59 >> > :->:->To: Multiple recipients of list ORACLE-L >> > :->:->Subject: Re: Inactive Sessions/Java >> > :->:-> >> > :->:-> >> > :->:->What is "Java process"? Is it a java class running in some kind >> of >> > :->:->application server? >> > :->:->If yes, then your application server is keeping your >> > :->:->connections open and >> > :->:->using connection pooling to share them between your >> > :->:->"processes", somewhat >> > :->:->reducing the overhead to create & drop a connection for >> > :->:->every interaction >> > :->:->with database. This is generally a good thing. >> > :->:-> >> > :->:->Tanel. >> > :->:->----- Original Message ----- >> > :->:->To: "Multiple recipients of list ORACLE-L" >> <[EMAIL PROTECTED]> >> > :->:->Sent: Thursday, August 28, 2003 8:29 PM >> > :->:-> >> > :->:-> >> > :->:->> >> > :->:->> >> > :->:->> Hi All, >> > :->:->> >> > :->:->> I have a problem with inactive sessions (despite having set >> the >> > :->:->> sqlnet.expire parameter) >> > :->:->> >> > :->:->> Some of the users connect to the database via a java >> > :->:->process - when I >> > :->:->stop >> > :->:->> this process from running the number of sessions just >> > :->:->shots right down. >> > :->:->> >> > :->:->> Short of scheduling a start and restart of this process >> > :->:->can anybody else >> > :->:->> come up with a solution?? >> > :->:->> >> > :->:->> I am reluctant to touch the java process as this is part >> > :->:->of the production >> > :->:->> box. (plus my knowledge of java is hovering over zero percent) >> > :->:->> >> > :->:->> Any ideas appreciated, >> > :->:->> >> > :->:->> thanks, >> > :->:->> >> > :->:->> N. >> > :->:->> >> > :->:-> >> > :->:-> >> > :->:->-- >> > :->:->Please see the official ORACLE-L FAQ: http://www.orafaq.net >> > :->:->-- >> > :->:->Author: Tanel Poder >> > :->:-> INET: [EMAIL PROTECTED] >> > :->:-> >> > :->:->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: [EMAIL PROTECTED] (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.net >> > -- >> > Author: Nuala Cullen >> > INET: [EMAIL PROTECTED] >> > >> > 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: [EMAIL PROTECTED] (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.net >> > -- >> > Author: DENNIS WILLIAMS >> > INET: [EMAIL PROTECTED] >> > >> > 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: [EMAIL PROTECTED] (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.net >> > -- >> > Author: Nuala Cullen >> > INET: [EMAIL PROTECTED] >> > >> > 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: [EMAIL PROTECTED] (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.net >> > -- >> > Author: DENNIS WILLIAMS >> > INET: [EMAIL PROTECTED] >> > >> > 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: [EMAIL PROTECTED] (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.net >> -- >> Author: Corniche Park >> INET: [EMAIL PROTECTED] >> >> 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: [EMAIL PROTECTED] (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.net > -- > Author: Tanel Poder > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containin > g: 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.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
