tomcat memory performence issues

Hi all,

iam facing performence issues with tomcat 5.5.9.

i have developed one webapllication which uses 20,000 employees...

problem is tomcat not releasing the memory ...memory is growing up to some peek stage then it is not allowed any requests and it going down..

plz see below cofigurations what iset for my tomcat....

server.xml.

<Connector

port="8080" maxHttpHeaderSize="8192" debug="0"

maxThreads="200" minSpareThreads="25" maxSpareThreads="200"

enableLookups="false" redirectPort="8443" acceptCount="20"

connectionTimeout="10000" disableUploadTimeout="true" />

context.xml for connection pooling

<Resource name="jdbc/Ids" auth="Container" type="javax.sql.DataSource" username="DATASYNC"password="DATASYNC"

driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@10.3.1.163:1521:ISPC" removeAbandoned="true" logAbandoned="true" removeAbandonedTimeout="300"

maxActive="1000" maxIdle="50" maxWait="10000" />

my server has 2GB of RAM

i set heap size initially as 512 MB

database is Oracle 9i in which max procees are set as 1000

i closed all database connections in all servlets/jsp pages .....still problem persits...

some times ...my databse is giving exception ORA-00020: maximum number of processes (1000) exceeed...once i restarted tomcat every thing working...

is there any thing need to be done from my end . to improve the performence......

Plz share your to improve my application performence.....Thanks in advance

[2193 byte] By [newwavea] at [2007-11-27 7:30:38]
# 1
sorry, but if your connections are not being returned to the pool, you are *not* closing your connections everywhere. Do you close your connections in finally clauses everywhere? Otherwise a thrown exception might prevent the connection from being closed.
gimbal2a at 2007-7-12 19:10:52 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2
It is also recommended that you explicitly close all result sets and statements and not rely on closing the connection to close them.
tolmanka at 2007-7-12 19:10:52 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...