UCP connection pool logging
- From: Martin Bach <development@xxxxxxxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 08 Mar 2010 17:12:03 +0000
Dear list members,
I am currently experimenting with the UCP for RAC 11.2 using tomcat 6 as
the "application server". I have configured a datasource and can connect
quite happily to the database service. FAN and FCF do work as
advertised,and so does runtime load balancing.
The documentation states that there are various log levels for UCP,
beginning from INTERNAL_ERROR over SEVERE to FINEST:
-> http://www.oracle.sh.cn/java.112/e12265/dgn_conpool.htm
However it seems that the code is instrumented only to emit traces for
FINE and FINEST, which is a bit too verbose for my liking
My setup:
- tomcat 6.0.24
- JDK 1.6_18 64bit
- ant 1.8.0
ls -l $CATALINA_HOME/lib:
total 9120
-rw-r--r-- 1 mbach root 15119 Jan 19 13:42 annotations-api.jar
-rw-r--r-- 1 mbach root 53459 Jan 19 13:42 catalina-ant.jar
-rw-r--r-- 1 mbach root 128412 Jan 19 13:42 catalina-ha.jar
-rw-r--r-- 1 mbach root 234845 Jan 19 13:42 catalina-tribes.jar
-rw-r--r-- 1 mbach root 1180908 Jan 19 13:42 catalina.jar
-rw-r--r-- 1 mbach root 32126 Jan 19 13:42 el-api.jar
-rw-r--r-- 1 mbach root 107431 Jan 19 13:42 jasper-el.jar
-rw-r--r-- 1 mbach root 1408152 Jan 19 13:42 jasper-jdt.jar
-rw-r--r-- 1 mbach root 522568 Jan 19 13:42 jasper.jar
-rw-r--r-- 1 mbach root 76644 Jan 19 13:42 jsp-api.jar
-rw-r--r-- 1 mbach root 2111220 Mar 4 09:02 ojdbc6.jar
-rw-r--r-- 1 mbach root 63590 Mar 4 09:03 ons.jar
-rw-r--r-- 1 mbach root 1656280 Mar 4 09:02 orai18n.jar
-rw-r--r-- 1 mbach root 88199 Jan 19 13:42 servlet-api.jar
-rw-r--r-- 1 mbach root 758225 Jan 19 13:42 tomcat-coyote.jar
-rw-r--r-- 1 mbach root 232785 Jan 19 13:42 tomcat-dbcp.jar
-rw-r--r-- 1 mbach root 69862 Jan 19 13:42 tomcat-i18n-es.jar
-rw-r--r-- 1 mbach root 51791 Jan 19 13:42 tomcat-i18n-fr.jar
-rw-r--r-- 1 mbach root 54850 Jan 19 13:42 tomcat-i18n-ja.jar
-rw-r--r-- 1 mbach root 447280 Mar 4 09:03 ucp.jar
all Oracle JARs are from an 11.2 64bit client which I installed locally
on the tomcat machine.
Now I don't pretend I am a java developer so maybe I'm doing something
wrong here? My logging.conf in my src/ directory of my webapp contains
the following lines (and it generates the debugging info in
$CATALINA_HOME/logs); whenever I try to set anything less than FINE no
output is generated even if I relocate/start/stop services which should
generate FAN events.
handlers = org.apache.juli.FileHandler, java.util.logging.ConsoleHandler
org.apache.juli.FileHandler.level = ALL
org.apache.juli.FileHandler.directory = ${catalina.base}/logs
org.apache.juli.FileHandler.prefix = ucp.
org.apache.juli.FileHandler.formatter = oracle.ucp.util.logging.UCPFormatter
java.util.logging.ConsoleHandler.level = SEVERE
.level = CONFIG
# FCF classes
oracle.ucp.common.FailoverEventHandlerThreadBase.level = ALL
oracle.ucp.jdbc.oracle.ONSDatabaseFailoverEvent.level = ALL
oracle.ucp.jdbc.oracle.ONSRuntimeLBEventHandlerThread.level = ALL
oracle.ucp.jdbc.oracle.ONSOracleRuntimeLBEventSubscriber.level = ALL
oracle.ucp.jdbc.oracle.ONSRuntimeLoadBalancingEvent.level = ALL
oracle.ucp.jdbc.oracle.ONSOracleFailoverEventSubscriber.level = ALL
oracle.ucp.jdbc.oracle.ONSDatabaseEventHandlerThread.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverEvent.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverEventSubscriber.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverEventImpl.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverEventNotification.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverHandler.level = ALL
oracle.ucp.jdbc.oracle.OracleFailoverablePooledConnection.level = ALL
oracle.ucp.jdbc.oracle.OraclePooledConnectionConnectionPool.level = ALL
oracle.ucp.jdbc.oracle.OracleConnectionConnectionPool.level = ALL
oracle.ucp.jdbc.oracle.OracleXAConnectionConnectionPool.level = ALL
oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.level = ALL
oracle.ucp.jdbc.oracle.OracleDatabaseInstanceInfo.level = ALL
oracle.ucp.jdbc.oracle.OracleDatabaseInstanceInfoList.level = ALL
# RCLB classes
oracle.ucp.jdbc.oracle.ONSRuntimeLBEventHandlerThread.level = ALL
oracle.ucp.jdbc.oracle.ONSOracleRuntimeLBEventSubscriber.level = ALL
oracle.ucp.jdbc.oracle.OracleRuntimeLoadBalancingHandler.level = ALL
oracle.ucp.jdbc.oracle.ONSRuntimeLoadBalancingEvent.level = ALL
Anyone have any ideas?
Thanks a lot in advance!
Martin
--
Martin Bach
OCM 10g
http://martincarstenbach.wordpress.com
http://www.linkedin.com/in/martincarstenbach
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » UCP connection pool logging - Martin Bach
