WebSphere SQL tracing

This is probably OTT but I've found that the following trace settings capture all SQL queries

com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement=all:
com.ibm.ws.oracle.*=all:
com.ibm.ws.database.*=all:
com.ibm.ws.runtime.WSThreadPool=all:
com.ibm.ws.rsadapter.dbutils.impl.*=all:
com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet=all:
com.ibm.ws.rsadapter.jdbc.WSJdbcStatement=all:
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource=all:
com.ibm.ws.rsadapter.jdbc.WSJdbcDatabaseMetaData=all

Configure IHS logging to show which WAS server handled a request

LogFormat "%h %l %u %t \"%r\" %>s %b %{WAS}e" sometag

It can also be useful to capture the JSESSION ID as follows... 
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{JSESSIONID}C\"" sometag