Re: Inactive Sessions/Java

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" <ORACLE-L_at_fatcity.com> 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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On
> > :->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.
> > :->dwilliams_at_lifetouch.com
> > :->
> > :->
> > :->-----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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On
> > :->:->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" <ORACLE-L_at_fatcity.com>
> > :->:->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: tanel.poder.003_at_mail.ee
> > :->:->
> > :->:->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: 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.net
> > --
> > Author: Nuala Cullen
> > INET: ncullen_at_catlogic.com
> >
> > 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: 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.net
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.COM
> >
> > 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: 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.net
> > --
> > Author: Nuala Cullen
> > INET: ncullen_at_catlogic.com
> >
> > 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: 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.net
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.COM
> >
> > 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: 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.net
> --
> Author: Corniche Park
> INET: cornichepark_at_cwazy.co.uk
>
> 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: 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.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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