-----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
