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 > > 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 transfers from point A to point B. The > > default Database connection setting that are set when the > > application server comes up are as follows: > > > > DataBasePoolingFlag - APACHE MaxActive - 400 MaxIdle - 20 MinIdle - > > 10 > > > > We had an incident where all these connections were actually used > > up due to a script someone had that looped. I need to determine at > > any given point in time how many DB connections exist from the web > > application to the DB. There may be more than one way to do this. I > > am sure there is a DB command that could be run against the schema > > but the schema is pointed to by many servers. I am wondering if > > there is a java command of some kind that I could run that may tell > > me how many connections are open at that time or possibly a tomcat > > or apache command. > > This may be helpful: > > http://people.apache.org/~schultz/ApacheCon%20NA%202016/Monitoring%20Apa > che%20Tomcat%20with%20JMX.pdf > > Slides 15-16 show you where you can find the DataSource information > via JMX, and then later on in the presentation there are slides to > show how you can get that information via HTTP instead of JMX. Scripts > are provided to fetch a value at intervals, track values over time, etc. > > - -chris > -----BEGIN PGP SIGNATURE----- > Comment: GPGTools - http://gpgtools.org > Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ > > iQIcBAEBCAAGBQJYdUHCAAoJEBzwKT+lPKRY8lAP/0C6wfLboz4K2MxaHR/86moX > sKIev9jV+wQ17n0nf1Wj1UA7GDGALye485Z2XMgIjlOaXmufVClfa3MWY07z+bv2 > R67AmDQ797jlCwTAAhpaRtB0FJmX4cd0EnJkC9r03NCH+kPRIK8G91bkgn8ehw4L > x0jrgKO/N0UEpshNI/baPxRJRX7yr83g2ZHiKVoFAXM25rEcJNSPOkvlTkBxZ5Yv > RCQuobinJa9X64p8beYXSkO/9wbP+b5/wcUxpewfvByK9Hits+n33/Mbq5RpKlR7 > vIHpwDJKlTo2/8ivIDHngIPiRQetlXEgwSWwN+5Fsr+V4bFSh6XnzIBAiB8SNoua > A9m71pyOoyQhdAAQzNfWwtLPWg9jrDaIRB7bj+HnbrKnCUa4rDyWfUDm4IwanfLW > QcDUggAgD151UstbSAQafLKJb0TBCWqHpIAvsJwCziOb6LnvtIf5xoLe7s48JZE9 > 44YfDFI4qg0NSdP59vF/Z1Ho5sveScHrcgmB03BGWVunj9caclqKOWWnJOscAVLJ > UXQG0B6VvboLJRgKUU4/z0s1a2sOcTLRUz+H1Ib9giqLirI6NVYUSg0lEZdVm5BA > 0Ctwd6qD7G1j8e4ZiuChC3paCA0nYVhEea0dAVHXB+ZYER89yeoBzPkZnc/vWLEe > LO1AZaxZ2nDebk0ubBn9 > =JgPw > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >