It would be nice if I could alter the log format of the P6Spy driver. Currently, it looks like:
current time|execution time|category|statement SQL String|effective SQL string
But I only want to see the effective SQL string...
It would help if there were a "ConversionPattern" something similiar to log4j...
What I'm getting in my log file is alittle different. There seems to be an extra item.
Here is one of my lines in the file:
12/01/2005 16:24:58:604|48|1|statement|stmt sql|eff sql
this would be:
timestamp|execution time|??|category|stmt sql|eff sql
What is the number in the 3rd column?
The third column seems to be a connection identifier/number.
I have a connection pool with 5 Oracle connections and a regular check of the connections
by my application server. The output in the log file is :
11-30-06 10:22:30:717|2|4|statement|select count(*) from dual|select count(*) from dual
11-30-06 10:22:30:719|1|3|statement|select count(*) from dual|select count(*) from dual
11-30-06 10:22:30:720|1|2|statement|select count(*) from dual|select count(*) from dual
11-30-06 10:22:30:722|1|1|statement|select count(*) from dual|select count(*) from dual
11-30-06 10:22:30:724|1|0|statement|select count(*) from dual|select count(*) from dual