RE: Oracle 9i, tomcat

Joshy,

In some versions of 8i there were bug related to OCI driver where closing Statements and ResultSet aren't enough, you have to close Connection which is obviously not good for connection pooling. Not sure if 9i could have this problem too.

Also, check on how you close the Statements and ResultSets. Are they closed in the Finally clause so no matter what happens they get closed. And I have found out people claim to close them but close it the wrong way. i.e. after ResultSet rs gets reassigned they tried to close it.

Richard Ji

-----Original Message-----
Sent: Wednesday, July 31, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L

Hi Neyman,
Thanks for your quick response. I use connection pool. Initially it makes 25 connection objects and put in the pool and they are reused. Not closed. But I close prep statements and resultset after using it, but to no avail. Any idea?
Thanks
Joshy

-----Original Message-----
Sent: Wednesday, July 31, 2002 10:04 PM
To: Multiple recipients of list ORACLE-L

Most probably, it's not Oracle, it's your application, that does not allow oracle to release memory.
Are you closing your connections properly?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, July 31, 2002 11:33 AM

> Hi All,
>
> Can anyone help me. This is very urgent.
>
> I have a ticker application written in Java, that accesses oracle 9i
> database in Linux. It gets data from database in every 2 minutes. When as
> many as 10 ticker clients are accessing database together for 30 minutes,
> oracle eventually dies.
>
> Ticker gets data from database thru Tomcat, on examination I found that
each
> time memory utilization for Oracle increases with database access. It
starts
> with 5% mem utilizations and increases - in every 2 minutes - 6%, 7% etc,
> for each database access from clients. When it reaches some 30% oracle
slows
> down and ticker apllication also slows down.
>
> Does anyone of you have a quick solution - Also why oracle not relasing
> memory after database access ?
>
> Thanks in Advance
> Joshy
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: JOSHY MON M C
> INET: JOSHYMON_at_nestec.net
>
> 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: Igor Neyman
  INET: ineyman_at_perceptron.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: JOSHY MON M C
  INET: JOSHYMON_at_nestec.net

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: Ji, Richard
  INET: Richard.Ji_at_MobileSpring.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).