Re: connections - netstat

On Dec 15, 2:56 am, "hopehope_123" <hopehope_..._at_yahoo.com> wrote:
> 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

Connection Pooling, are you using MTS? If not, pool is app side or load balanced on hardware. Received on Fri Dec 15 2006 - 12:04:45 CST