dmstool ってのを使えば、コネクションプールの状態を見れるみたい。
組込みパフォーマンス・ツールを使用した監視
パフォーマンス・メトリック
追記(2009/03/30):
実際に使ってみる。
$ dmstool -l grep -i jdbc /web1/OC4J:3304:6003/JDBC/ /web1/OC4J:3304:6003/JDBC/Driver/ /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCloseCount.count /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.active /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.avg /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.completed /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.maxTime /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.minTime /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.time /web1/OC4J:3304:6003/JDBC/Driver/ConnectionOpenCount.count
$ dmstool -c 100 -i 10 /web1/OC4J:3304:6003/JDBC/ Mon Mar 30 15:11:45 JST 2009 /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCloseCount.count 276 ops /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.active 0 threads /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.avg 0.7318840579710145 msecs /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.completed 276 ops /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.maxTime 110 msecs /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.minTime 0 msecs /web1/OC4J:3304:6003/JDBC/Driver/ConnectionCreate.time 202 msecs /web1/OC4J:3304:6003/JDBC/Driver/ConnectionOpenCount.count 0 ops ...
$ dmstool -table JDBC_Driver Mon Mar 30 15:23:50 JST 2009 ----------- JDBC_Driver ----------- ConnectionCloseCount.count: 276 ops ConnectionCreate.active: 0 threads ConnectionCreate.avg: 0.7318840579710145 msecs ConnectionCreate.completed: 276 ops ConnectionCreate.maxTime: 110 msecs ConnectionCreate.minTime: 0 msecs ConnectionCreate.time: 202 msecs ConnectionOpenCount.count: 0 ops timeStamp.ts: 1238394230862 milliseconds Host: web1 Name: Driver Parent: /JDBC Process: Sample:OC4J:3304:6003 iasInstance: MiddleTier.web1 uid: 1582497846
$ dmstool -table JVM Mon Mar 30 15:39:16 JST 2009 --- JVM --- activeThreadGroups.maxValue: 3.0 groups activeThreadGroups.minValue: 1.0 groups activeThreadGroups.value: 3 groups activeThreads.maxValue: 19.0 threads activeThreads.minValue: 7.0 threads activeThreads.value: 19 threads cpuTime.value: not implemented msecs freeMemory.maxValue: 2686.0 kbytes freeMemory.minValue: 128.0 kbytes freeMemory.value: 315 kbytes startTime.value: 1238392411519 msecs timeStamp.ts: 1238395156439 milliseconds totalMemory.maxValue: 5104.0 kbytes totalMemory.minValue: 1984.0 kbytes totalMemory.value: 5104 kbytes upTime.value: 2744920 msecs Host: web1 Name: JVM Parent: / Process: Sample:OC4J:3302:6003 iasInstance: MiddleTier.web1 uid: 1582497844
