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