tomcat performence issues..Urgent

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

[2186 byte] By [newwavea] at [2007-11-27 7:30:37]
# 1
any help would appreciate..
newwavea at 2007-7-12 19:10:51 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2
> i closed all database connections in all servlets/jsp pagesAnd Statements? PreparedStatements? ResultSets?You may consider implementing a robust DAO/ORM instead of writing it on your own. Hibernate for example. I bet that your code is not written very well.
BalusCa at 2007-7-12 19:10:51 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...