|netstat| grep 1522| wc -l [message #264949]
||Wed, 05 September 2007 01:47
Registered: September 2007
I am taking care of a small application.
oracle 9i(10g Jar)
In the DB side there seems some connections are not getting closed.
when i issue this command
netstat| grep 1522| wc -l
it displays 100 and some times more than that.
When i approached the DB they are saying that there are some connections which are not closed for more than 24 hours.
once it croses some limit, the application hangs..
and so we changed form 9i jar to 10g jar
and also changed the max active parameter to 200
now it is ok,but still some open connections are there...
is there any ways to fine tune it......
do you need any more information for this.....