Re: Inactive Sessions/Java

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