connections - netstat

Hi ,

 I ahve a question regarding to the db serverconnections.

The db server is 9.2.0.8 , and app server is 10g.

A is the db server

B is the app server.

According to the sql :

 select username,count(*) from v$session group by username

USERNAME                         COUNT(*)
------------------------------ ----------
usera                            45

WHEN I run the followin on db server:

bash-2.03$ netstat -an | grep B | wc -l

      51
bash-2.03$ netstat -an | grep B | grep ESTA |wc -l

      50

I see 50 connections connected from application server.

but when i check this on application server :

bash-2.05# netstat -an | grep A.1521 | grep ESTAB | wc -l

     103

I see 103 connections.

So , application server has 103 connections to the db , but db has 50 connections from app server.

Why do these numbers differ?

Kind Regards,
hope Received on Fri Dec 15 2006 - 01:56:41 CST