Home » RDBMS Server » Performance Tuning » netstat| grep 1522| wc -l
netstat| grep 1522| wc -l [message #264949] Wed, 05 September 2007 01:47
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


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: Too many redo log file (merged)
Next Topic: SQL Tuning Urgent
Goto Forum:

Current Time: Sun Aug 20 10:41:41 CDT 2017

Total time taken to generate the page: 0.08006 seconds