Oracle 9i, tomcat
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: [EMAIL PROTECTED] 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: [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).
Re: Oracle 9i, tomcat
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 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] 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: [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).
RE: Oracle 9i, tomcat
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 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] 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: [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.com -- Author: JOSHY MON M C INET: [EMAIL PROTECTED] 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: [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).
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 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [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.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] 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: [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.com -- Author: JOSHY MON M C INET: [EMAIL PROTECTED] 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: [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.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] 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: [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).