Re: connections - netstat

Hi ,

We use jdbc connection pooling. But event with jdbc connection pooling , establishede tcp communications must have both ends , mustnt it?

On the other hand , iwe have another app server called C , it has the same problem , we dont use connection pooling on it.

Kind Regards,
hope

EscVector wrote:
> 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

>