Home » RDBMS Server » Performance Tuning » netstat| grep 1522| wc -l
netstat| grep 1522| wc -l [message #264949] Wed, 05 September 2007 01:47
nonstopkaran
Messages: 9
Registered: September 2007
Location: chennai
Junior Member
Hi dudes,

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

<ContextParam>
<param-name>defaultMaxActive</param-name>
<param-value>200</param-value>
</ContextParam>

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.....
Previous Topic: db_cache_size - correct size
Next Topic: Which is memory set to shared pool?
Goto Forum:
  


Current Time: Fri Dec 02 16:16:41 CST 2016

Total time taken to generate the page: 0.17520 seconds