OraFAQ Forum: Performance Tuning » netstat| grep 1522| wc -l

Home » RDBMS Server » Performance Tuning » netstat| grep 1522| wc -l

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.....

Report message to a moderator

Previous Topic:	db_cache_size - correct size
Next Topic:	Which is memory set to shared pool?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 04 17:19:55 CST 2024