Regarding the oddity I have found the query is running every 15 minutes and gives me a warning
2009.06.26 09:59:38 #1991 was active for 324813 milliseconds and has been removed automaticaly. The Thread responsible was named ‘pool-monitoring5620’, but the last SQL it performed is unknown because the trace property is not enabled.
2009.06.26 10:14:18 #1986 was active for 304828 milliseconds and has been removed automaticaly. The Thread responsible was named ‘pool-monitoring5622’, but the last SQL it performed is unknown because the trace property is not enabled.
2009.06.26 10:29:38 #1989 was active for 324844 milliseconds and has been removed automaticaly. The Thread responsible was named ‘pool-monitoring5622’, but the last SQL it performed is unknown because the trace property is not enabled.
2009.06.26 10:44:39 #1994 was active for 324969 milliseconds and has been removed automaticaly. The Thread responsible was named ‘pool-monitoring5630’, but the last SQL it performed is unknown because the trace property is not enabled.