Re: Best way to find out how many DB connections that are open at any given time

You may also want to have a look at flexy pool - https://github.com/vladmihalcea/flexy-pool With kind regards Thomas With kind regards Thomas > Am 11.01.2017 um 01:36 schrieb Joleen Barker : > > As always, thank you Christopher, I'll take a look at the slides. > >

Re: Best way to find out how many DB connections that are open at any given time

As always, thank you Christopher, I'll take a look at the slides. And Thank you to the other for pointing me in some directions for this. -Joleen On Tue, Jan 10, 2017 at 3:19 PM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > >

Re: Best way to find out how many DB connections that are open at any given time

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Joleen, On 1/10/17 11:10 AM, Joleen Barker wrote: > Hello All, > > Details: Tomcat Version: 7.0.64.0 Java Version: 1.8.0 OS: AIX 6.1 > Database: Oracle 11 > > The web application installed on the server above makes data > connections to run file

Re: Best way to find out how many DB connections that are open at any given time

Thank you Andre and calder. On the AIX side this worked. I am limited also I think due to the shell. If I use the -p tcp option it gives me a long list of counts of TCP connections and bytes. This command gave me similar on AIX: netstat -a|grep 1526 tcp0 0 cpmfttapt21.51186

Re: Best way to find out how many DB connections that are open at any given time

On 10.01.2017 18:06, Joleen Barker wrote: Hi Andre - I played around a little more and ran the command netstat -a | grep 1526 which is the port number and received information that looks like 11 connections are open at this time. Do you know what the number is that follows the machine name in

Re: Best way to find out how many DB connections that are open at any given time

The fourth column is the "Local Address" (local machine) - in the case, a machine-name (vs IP address) and the port value (such as 51186) the machine is listening on. Of course, the machine-name will resolve to an IP address, so in some netstat output, you might see tcp 0 0 10.240.100.20:51186

Re: Best way to find out how many DB connections that are open at any given time

Hi Andre - I played around a little more and ran the command netstat -a | grep 1526 which is the port number and received information that looks like 11 connections are open at this time. Do you know what the number is that follows the machine name in the forth column for example the 51186?

Re: Best way to find out how many DB connections that are open at any given time

Hello Filippo - I do not have JConsole available and the proposed idea is past my knowledge level. Hello André - This was an interesting idea but it didn't work for me. I only have the ksh available and could only use netstat -p tcp but the output didn't make sense to me. On Tue, Jan 10, 2017 at

Re: Best way to find out how many DB connections that are open at any given time

On 10.01.2017 17:10, Joleen Barker wrote: Hello All, Details: Tomcat Version: 7.0.64.0 Java Version: 1.8.0 OS: AIX 6.1 Database: Oracle 11 The web application installed on the server above makes data connections to run file transfers from point A to point B. The default Database connection

Re: Best way to find out how many DB connections that are open at any given time

Ciao Joleen, maybe you could retrieve this information connecting via JMX (JConsole, VisualVM) to the tomcat instances. According to the way the datasource is configured, you could find a JMX bean exposing this information. Before that, tomcat should be launched in a way JMX connections are

Best way to find out how many DB connections that are open at any given time

Hello All, Details: Tomcat Version: 7.0.64.0 Java Version: 1.8.0 OS: AIX 6.1 Database: Oracle 11 The web application installed on the server above makes data connections to run file transfers from point A to point B. The default Database connection setting that are set when the application