Resolution:
Description:
===========
By default TIBCO BusinessEvents agent executes the following SQL statement every 60secs (backingstore enabled).

"Select 10 from dual"

Environment:
===========
TIBCO Business Events 4.x/5.x
All Operating Systems

Symptoms:
=========
SQL statement "Select 10 from dual" processed every 60 secs.

Cause:
======
This is a static query to validate the database connection (by default executed every  60 seconds).

Resolution:
========
It is possible to define the check intervall by adding the following property to the Cluster Deployment Descriptor (CDD)

e.g. increase time interval to 600 secs
&ltproperty name="be.backingstore.test.connections.interval" value="600"/>